DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=3hcyMe/dgvzMi0DWqkegZ0Xn46iGesH0kEMNSOmvo9HZe3EuHBiKt/rmlX6xAuBLZ/yZvzk4RvNfaUPjswMm29nMOvbnycll9sfqrbPkr9s4uo6VTqmiudhgRsmWiP7161IEC1ixqVnhHcNRnVvVggPcJ7ZKGnCwv46U/okPvrQ=;
Message-ID: <213541.11913.qm@web43403.mail.sp1.yahoo.com>
References: <218848.40985.qm@web43403.mail.sp1.yahoo.com>
	<49CD5DBD.2080908@gmx.de>
Date: Fri, 27 Mar 2009 16:33:19 -0700 (PDT)
From: Newbie Poster <newbie.poster@yahoo.com>
Subject: Re: Logging in with postgres remotely
To: PGSQL Admin <pgsql-admin@postgresql.org>
In-Reply-To: <49CD5DBD.2080908@gmx.de>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-221948249-1238196799=:11913"


--0-221948249-1238196799=:11913
Content-Type: text/plain; charset=us-ascii

Thanks for the response. I was able to get postgres user to connect to the remote database by using the 'alter user' command from within psql.  However, I am unable to connect to the same server with a different user.  I created a generic user called pgAdmin and used the command:

grant all privileges on database clients to user pgAdmin

I am certain I know that users password yet I cannot connect with it from my workstation. Do you think the pgpass file will help in this instance?


________________________________
From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Newbie Poster <newbie.poster@yahoo.com>
Sent: Friday, March 27, 2009 4:14:05 PM
Subject: Re: [ADMIN] Logging in with postgres remotely

Newbie Poster wrote:

>  Error connecting to the server: FATAL:  password authentication failed
> for user "postgres"

Sounds like a hunt for the pgpass file is recommended:

http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html

Peter


--0-221948249-1238196799=:11913
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Thanks for the response. I was able to get postgres user to connect to the remote database by using the 'alter user' command from within psql.&nbsp; However, I am unable to connect to the same server with a different user.&nbsp; I created a generic user called pgAdmin and used the command:<br><br>grant all privileges on database clients to user pgAdmin<br><br>I am certain I know that users password yet I cannot connect with it from my workstation. Do you think the pgpass file will help in this instance?<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Jan-Peter Seifert
 &lt;Jan-Peter.Seifert@gmx.de&gt;<br><b><span style="font-weight: bold;">To:</span></b> Newbie Poster &lt;newbie.poster@yahoo.com&gt;<br><b><span style="font-weight: bold;">Sent:</span></b> Friday, March 27, 2009 4:14:05 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [ADMIN] Logging in with postgres remotely<br></font><br>
Newbie Poster wrote:<br><br>&gt;&nbsp; Error connecting to the server: FATAL:&nbsp; password authentication failed<br>&gt; for user "postgres"<br><br>Sounds like a hunt for the pgpass file is recommended:<br><br><span><a target="_blank" href="http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html">http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html</a></span><br><br>Peter<br></div></div></div><br>


      </body></html>
--0-221948249-1238196799=:11913--