Thread: Changing default user's passwd

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.

Thank you in advance,
r

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
passwords.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
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."
                               Hebrews 12:1