Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 53DAD633370
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Mar 2009 05:16:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 61727-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Mar 2009 05:16:08 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mta.4linux.com.br (boca.4linux.com.br [200.212.122.137])
	by mail.postgresql.org (Postfix) with ESMTP id 70AB2633209
	for <pgsql-admin@postgresql.org>; Sun, 29 Mar 2009 05:16:08 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mta.4linux.com.br (Postfix) with ESMTP id 8CF29C85A;
	Sun, 29 Mar 2009 02:58:39 -0300 (BRT)
X-Virus-Scanned: amavisd-new at mta.4linux.com.br
Received: from mta.4linux.com.br ([127.0.0.1])
	by localhost (mta.4linux.com.br [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id ZO+y99w-ouxF; Sun, 29 Mar 2009 02:58:34 -0300 (BRT)
Received: from mail.4linux.com.br (unknown [192.168.0.11])
	by mta.4linux.com.br (Postfix) with ESMTP id B1125C847;
	Sun, 29 Mar 2009 02:58:34 -0300 (BRT)
Date: Sun, 29 Mar 2009 02:58:37 -0300 (BRT)
From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
To: Newbie Poster <newbie.poster@yahoo.com>
Cc: pgsql-admin@postgresql.org
Message-ID: <32212646.293281238306317487.JavaMail.root@mail.4linux.com.br>
In-Reply-To: <213541.11913.qm@web43403.mail.sp1.yahoo.com>
Subject: Re: Logging in with postgres remotely
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_11530_6039198.1238306317486"
X-Originating-IP: [189.120.19.157]
X-Mailer: Zimbra 5.0.13_GA_2791.UBUNTU6 (ZimbraWebClient - [unknown]
	(Linux)/5.0.13_GA_2791.UBUNTU6)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/243
X-Sequence-Number: 31743

------=_Part_11530_6039198.1238306317486
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Hi Newbie 

----- "Newbie Poster" <newbie.poster@yahoo.com> escreveu: 


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? 

Have you checked your pg_hba.conf file in your PostgreSQL server (if you have access to it)? 
Maybe it's not allowed to connect remotely as a regular user but postgres. 

Best regards 
Flavio 

------=_Part_11530_6039198.1238306317486
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>Hi Newbie<br><br>----- "Newbie Poster" &lt;newbie.poster@yahoo.com&gt; escreveu:
<br><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>&gt; <br>&gt; grant all privileges on database clients to user pgAdmin<br>&gt; <br>&gt; 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><br>Have you checked your pg_hba.conf file in your PostgreSQL server (if you have access to it)?<br>Maybe it's not allowed to connect remotely as a regular user but postgres.<br><br>Best regards<br>Flavio<br></div></body></html>
------=_Part_11530_6039198.1238306317486--