Skip site navigation (1) Skip section navigation (2)

Can't connect from any system account other than postgres

From: James Colannino <james(at)eracks(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Can't connect from any system account other than postgres
Date: 2008-06-23 22:58:37
Message-ID: 48602A9D.3000004@eracks.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hey everyone.  I hope you'll forgive this most likely stupid question, 
but I'm having trouble connecting to a postgresql database when on any 
system account other than postgres.

I understand that the way my PostgreSQL installation is setup, the 
account postgres functions as a trusted account that will allow me to 
run psql without a password.  However, after I've setup an initial 
database, user and password (the database is set to belong to this 
user), when I try to run the command psql -d database -U username -W, 
after entering the password, I'm told that authentication failed.

I also tried logging into the system as postgres, and then setting the 
password for the database user postgres.  However, I have the same 
problem when I try to connect as this user from any other system account.

I'm guessing I missed something in my server configuration, but I can't 
for the life of me figure it out.  Thanks in advance for any help anyone 
can provide!

James
-- 
eRacks Open Source Systems
http://www.eracks.com/

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-06-23 23:23:51
Subject: Re: Can't connect from any system account other than postgres
Previous:From: Sava ChankovDate: 2008-06-23 14:13:19
Subject: md5 password authentication does not work when db_user_namespace = on

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group