From: Medi Montaseri <montaseri@gmail.com>
To: smiley2211 <smiley2211@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres User Password File????
Date: Fri, 7 Sep 2007 09:37:59 -0700
Message-ID: <8078a1730709070937l7af17e8ey4068dff38383dd4c@mail.gmail.com> (raw)
In-Reply-To: <12558458.post@talk.nabble.com>
References: <12558458.post@talk.nabble.com>
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@yahoo.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:
> http://www.nabble.com/Postgres-User-Password-File-----tf4402207.html#a12558458
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: montaseri@gmail.com, smiley2211@yahoo.com
Subject: Re: Postgres User Password File????
In-Reply-To: <8078a1730709070937l7af17e8ey4068dff38383dd4c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox