On Wed, 2002-09-11 at 18:36, reshat.sabiq.1 wrote:
> We've been trying to
> alter user postgres with passwd '...' createdb createuser;
> and the like, and we get
> alter user
> output showing that the command is successful.
> However, when we later psql -U postgres postgres
> we are getting:
> psql: FATAL 1: IDENT authentication failed for user "postgres".
> Is there a way to change this default user's password to avoid su'ing.
You have successfully changed the password, but postgresql is ignoring
it. Look in $PGDATA/pg_hba.conf to define how to validate access
requests. At present, it is set to use ident authentication rather than
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Therefore, since we have so great a cloud of witnesses
surrounding us, let us also lay aside every weight,
and the sin which so easily entangles us, and let us
run with endurance the race that is set before us."
In response to
pgsql-novice by date
|Next:||From: Terry Yapt||Date: 2002-09-16 20:43:39|
|Subject: Re: psql and readline library: cursor keys|
|Previous:||From: Oliver Elphick||Date: 2002-09-16 20:18:24|
|Subject: Re: SIGHUP postmaster|