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