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

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


pgsql-novice by date

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

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