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

Re: Changing default user's passwd

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: "reshat(dot)sabiq(dot)1" <sabiq(at)purdue(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Changing default user's passwd
Date: 2002-09-16 20:21:04
Message-ID: 1032207664.13211.16.camel@linda (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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."
                               Hebrews 12:1 

In response to

pgsql-novice by date

Next:From: Terry YaptDate: 2002-09-16 20:43:39
Subject: Re: psql and readline library: cursor keys
Previous:From: Oliver ElphickDate: 2002-09-16 20:18:24
Subject: Re: SIGHUP postmaster

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