Re: Can't connect from any system account other than postgres

On Mon, Jun 23, 2008 at 4:58 PM, James Colannino <james(at)eracks(dot)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.