Changing default user's passwd

From: "reshat(dot)sabiq(dot)1" <sabiq(at)purdue(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Cc: sabiq(at)purdue(dot)edu
Subject: Changing default user's passwd
Date: 2002-09-11 17:36:39
Message-ID: Pine.SOL.4.43.0209111235320.3594-100000@herald.cc.purdue.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Chad Thompson 2002-09-11 21:38:01 A and C not B
Previous Message Roland Roberts 2002-09-11 17:21:28 Re: Unique indices and nulls