Thread: Can't connect from any system account other than postgres
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/
On Mon, Jun 23, 2008 at 4:58 PM, James Colannino <james@eracks.com> wrote: > 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. Let me guess, it says something about ident authentication failed, right? Take a look here: http://www.postgresql.org/docs/8.3/interactive/client-authentication.html This section has been moved for future versions of the docs, but it's still in a kind of "too later to save you" position for now.
Scott Marlowe wrote: > Let me guess, it says something about ident authentication failed, right? Yep, sure does. > http://www.postgresql.org/docs/8.3/interactive/client-authentication.html > > This section has been moved for future versions of the docs, but it's > still in a kind of "too later to save you" position for now. That was very helpful. Thanks! James -- eRacks Open Source Systems http://www.eracks.com/