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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

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

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