[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
postgres help.
- Subject: postgres help.
- From: Milton Calnek <..hidden..>
- Date: Mon, 09 Jun 2008 12:28:58 -0600
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I'm having troubles setting my postgres server.
I'm trying to run ledger on a Centos 5 (aka rhel 5) system, with
postgres 8.1.11.
I can connect to the ledger db as users ledgersmb, postgres, root
and apache. Everyone but ledgersmb is a superuser:
As root I can connect to ledgersmb db as user root, but not as user
ledgersmb. ie:
psql -d ledgersmb -> works
psql -U ledgersmb -d ledgersmb -W -> does not work.
This is from pg_dumpall:
CREATE ROLE apache;
ALTER ROLE apache WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
CREATE ROLE ledgersmb;
ALTER ROLE ledgersmb WITH NOSUPERUSER INHERIT NOCREATEROLE CREATEDB
LOGIN PASSWORD 'md5ab61fc5b6b7ef0f56920f335e02265b1';
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
CREATE ROLE root;
ALTER ROLE root WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
My pg_hba.conf files follows:
I added the md5/pam lines in an effort
# "local" is for Unix domain socket connections only
local all all ident sameuser
local all all md5
local all all pam
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 pam
# IPv6 local connections:
host all all ::1/128 ident sameuser
tia.
- --
Milton Calnek BSc, A/Slt(Ret.)
..hidden..
306-717-8737
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFITXZqHgnbf2T2QqMRAiyCAKCAM6yfYChXpMSsHY6wdmJsd5XLOwCeIAZn
gF6ai0L77BkZSh9KMKxspMY=
=RQNi
-----END PGP SIGNATURE-----
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.