On Mon, Jun 23, 2008 at 4:58 PM, James Colannino <james@xxxxxxxxxx> 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.