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

Re: Postgres User Password File????

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: smiley2211 <smiley2211(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres User Password File????
Date: 2007-09-07 16:37:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
PG maintains user passwd within itself in a table called pg_shadow.
But based on the error message, it seems like you are having problem
connecting to the server.
Try accessing PG from command line with something like psql(1) as in

psql -U proot -d databaseName

and see what error message do you get...can you connect to PG as a different
user ?

On 9/7/07, smiley2211 <smiley2211(at)yahoo(dot)com> wrote:
> Hello all,
> Where do I find the PASSWORDs for users on Postgresql???  It seems
> connections are failing because user PROOT's password is not correct -
> where
> do I find out what it's set to - do I need to change it???
> DataObjects_Users : CONNECT :
> a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB_Error":8:{s:20:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4:"code";i:-24;s:7:"message";s:24:"DB
> Error: connect failed";s:8:"userinfo";s:171:" [nativecode=Unable to
> connect
> to PostgreSQL server: FATAL: password authentication failed for user
> "proot"]
> Thanks...Michelle
> --
> View this message in context:
> Sent from the PostgreSQL - admin mailing list archive at
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

In response to


pgsql-admin by date

Next:From: smiley2211Date: 2007-09-07 16:49:45
Subject: Re: Postgres User Password File????
Previous:From: smiley2211Date: 2007-09-07 16:15:22
Subject: Postgres User Password File????

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