Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 42CB29FB57F for ; Fri, 7 Sep 2007 13:38:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 79237-06 for ; Fri, 7 Sep 2007 13:38:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id B6B839FB538 for ; Fri, 7 Sep 2007 13:38:01 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id u77so1157671pyb for ; Fri, 07 Sep 2007 09:38:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=1JhX0iB578CnRS34opRDWId03/QLNa4V6f1dpKbwaKQ=; b=NT4e0vuLciZCucGQCylv3syFBdWeCFWvJXoBJnc9zen4NE6rN/NXg1u6PRSWHRuxjI2uQOR6P4bV8YLQ3vJng6TOOulyoGkdJqKloTeujETr2uPZ+VQ3OmGykFw+95U7iHMHO7DWg7/L3VSfxbr9jwmSj8UhmT7kfk9Y1c3GwmI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=IxbXFy4ZCaNjM/gQFbtKxd2KBqbSjwg0cVlQhkw7gxJNOk45iVYBW3c65quivO8oA+BSGoeUi1BsiMK5O372YqCCWvyP43/XoSoa4ZheRlXY/w/aoMG+/cN9KS7lkqki3kvcFvvgncaUtN+z4hiD91n6kwHNAAJ5WKLLPUUixrU= Received: by 10.65.107.10 with SMTP id j10mr3929422qbm.1189183079980; Fri, 07 Sep 2007 09:37:59 -0700 (PDT) Received: by 10.65.110.15 with HTTP; Fri, 7 Sep 2007 09:37:59 -0700 (PDT) Message-ID: <8078a1730709070937l7af17e8ey4068dff38383dd4c@mail.gmail.com> Date: Fri, 7 Sep 2007 09:37:59 -0700 From: "Medi Montaseri" To: smiley2211 Subject: Re: Postgres User Password File???? Cc: pgsql-admin@postgresql.org In-Reply-To: <12558458.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1156_18519452.1189183079966" References: <12558458.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/44 X-Sequence-Number: 26805 ------=_Part_1156_18519452.1189183079966 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 > ------=_Part_1156_18519452.1189183079966 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_1156_18519452.1189183079966--