Re: [NOVICE] Authentication problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: the inquirer <listquestions(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Authentication problems
Date: 2004-08-24 19:16:00
Message-ID: 6574.1093374960@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

the inquirer <listquestions(at)yahoo(dot)com> writes:
> $ psql -W -d database -U user
> Password:
> psql: FATAL: IDENT authentication failed for user "user"

It looks like you would rather use password authentication than the
default IDENT-based auth (it's default in Debian distro of postgres
anyway). IDENT will only let you in when you do *not* use -U, ie,
your postgres user name is the same as your Unix user name. Change
this in pg_hba.conf, and don't forget to SIGHUP or restart the
postmaster afterwards.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2004-08-24 19:18:04 Re: Problem to connect to the Windows Port
Previous Message David Wheeler 2004-08-24 18:39:47 Re: UTF-8 and LIKE vs =

Browse pgsql-novice by date

  From Date Subject
Next Message michael 2004-08-24 19:48:58 Re: DATE column doesn't like empty string or null value
Previous Message Tom Lane 2004-08-24 19:11:28 Re: DATE column doesn't like empty string or null value