From newbie.poster@yahoo.com Fri Mar  27 22:45:11 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id A0F58635074
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Mar 2009 19:45:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 04922-02-5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Mar 2009 19:45:01 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n76.bullet.mail.sp1.yahoo.com (n76.bullet.mail.sp1.yahoo.com
	[98.136.44.48])
	by mail.postgresql.org (Postfix) with SMTP id E1556633D4E
	for <pgsql-admin@postgresql.org>; Fri, 27 Mar 2009 19:44:56 -0300 (ADT)
Received: from [216.252.122.217] by n76.bullet.mail.sp1.yahoo.com with NNFMP;
	27 Mar 2009 22:44:53 -0000
Received: from [69.147.65.163] by t2.bullet.sp1.yahoo.com with NNFMP;
	27 Mar 2009 22:44:53 -0000
Received: from [127.0.0.1] by omp408.mail.sp1.yahoo.com with NNFMP;
	27 Mar 2009 22:44:53 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 418640.47430.bm@omp408.mail.sp1.yahoo.com
Received: (qmail 48985 invoked by uid 60001); 27 Mar 2009 22:44:53 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1238193893; bh=/ivQBqb5gPZvwI5GGzanROm93KCnNkm5VC/0pSqh3+E=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=RspasXluKPuaanrannG6R1+RPGrGzmATJQvxlyachQVK7x1W+D55MPtA1LLzuFcc61xIVX5CcYKibLexVMonvZ93EeELEjKgDjSRAIutW1B9MDYsH34yHpB2d1Pc2zAZt9WtaKjjS79LsV/Gj6Y2f5ToU4GxpX4GEbBntAxReiQ=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=3jeuJDnJRwWcDBhDdOaz2eAw/uNZXAD7fI38bUdvukxHpIY0px1bwkrt8t5toAN9HEVR6T3nEb4ZUgOQ78hxEsjlxNnL0b49n2urmjj/iSiVExaearveWpV/vW0Ka07XvhdJ/FauLPYli94aL0lDEXK+o1o2l1F4DBrJI17OQZM=;
Message-ID: <218848.40985.qm@web43403.mail.sp1.yahoo.com>
X-YMail-OSG: 
 7Hl5bGsVM1nqLnOdoCJ9Uiw80oROF.e4c2ajrWWnvX2o43JtGssTjLAwrgE1FqUy5ZXDzaEGApmjv2x5JNm33xfVlK5sst5N4yPb6vex4qw60N0p0oozJUEisG76tqhaiCvc28NCv5OW1bolvvlEpg4XZPaI1BNpgP6ryAW_me4plwohSWknz5DhGIymKjIhTG3LlCQid8gvQHy9oeA-
Received: from [216.254.18.193] by web43403.mail.sp1.yahoo.com via HTTP;
	Fri, 27 Mar 2009 15:44:53 PDT
X-Mailer: YahooMailRC/1277.32 YahooMailWebService/0.7.289.1
Date: Fri, 27 Mar 2009 15:44:53 -0700 (PDT)
From: Newbie Poster <newbie.poster@yahoo.com>
Subject: Logging in with postgres remotely
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1233996833-1238193893=:40985"
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/241
X-Sequence-Number: 31741


--0-1233996833-1238193893=:40985
Content-Type: text/plain; charset=us-ascii

I am trying to connect to a postgres database ona remote server using pgAdmin III, and the user postgres.  According to some instructions I found in the mailing list archives, I reset the password of the postgres user, which is required before one can use that username to connect to a remote database. I am still getting the same error, however, which is:

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

Any pointers?  Thanks!



      
--0-1233996833-1238193893=:40985
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>I am trying to connect to a postgres database ona remote server using pgAdmin III, and the user postgres.&nbsp; According to some instructions I found in the mailing list archives, I reset the password of the postgres user, which is required before one can use that username to connect to a remote database. I am still getting the same error, however, which is:<br><br>&nbsp;Error connecting to the server: FATAL:&nbsp; password authentication failed for user "postgres"<br><br>Any pointers?&nbsp; Thanks!<br></div></div><br>

      </body></html>
--0-1233996833-1238193893=:40985--




From newbie.poster@yahoo.com Fri Mar  27 23:33:27 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 0797B635A4E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Mar 2009 20:33:27 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 15847-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Mar 2009 20:33:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n70.bullet.mail.sp1.yahoo.com (n70.bullet.mail.sp1.yahoo.com
	[98.136.44.38])
	by mail.postgresql.org (Postfix) with SMTP id 5F3A6635A2B
	for <pgsql-admin@postgresql.org>; Fri, 27 Mar 2009 20:33:22 -0300 (ADT)
Received: from [216.252.122.216] by n70.bullet.mail.sp1.yahoo.com with NNFMP;
	27 Mar 2009 23:33:20 -0000
Received: from [69.147.65.165] by t1.bullet.sp1.yahoo.com with NNFMP;
	27 Mar 2009 23:33:20 -0000
Received: from [127.0.0.1] by omp500.mail.sp1.yahoo.com with NNFMP;
	27 Mar 2009 23:33:20 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 341105.37957.bm@omp500.mail.sp1.yahoo.com
Received: (qmail 13438 invoked by uid 60001); 27 Mar 2009 23:33:20 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1238196800; bh=GUK7LXqxImqBWkJiTZVlAtc9fQPkHMLMm9HcHc1lh1I=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=yTe/P3yujEoE3lA5qRzpr87PuepAGYAfNvASg/WEd6naF3L9m+julZr85lC5LNqQxKQTiB0nvGAWdChmKCHBufrHc+1JyGiOrUUNppVkchBDCDJ3DN9cV6DwwNSx++9eK1507oIbP8pwoUj0zj0Jx5FfNi/sD2Rt3Ynsm6LneBs=
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>
X-YMail-OSG: 
 l_TjTT4VM1l_7UZFu0L7HcGlztaFt0aTdFM4soBk1kn1CGp39i65wka18eROibiJ_4S_d9HOPcn6EYLvUyVbUGREh7HU9jiLa7DTulxas2000Rqsf5MHPKyjcMPgIU16xMyc1KAZv1bhaUQ01TIUZbLsULvT1gDslXigz2Kkyws249ma2FKvgBeY6iy1AJ.jsT.Y2qSc83FEmDhQ9TJiNYCUsiL_z12wD_EHNFAsunCbtxpj
Received: from [216.254.18.193] by web43403.mail.sp1.yahoo.com via HTTP;
	Fri, 27 Mar 2009 16:33:19 PDT
X-Mailer: YahooMailRC/1277.32 YahooMailWebService/0.7.289.1
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"
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/242
X-Sequence-Number: 31742


--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--




From flavio@4linux.com.br Sun Mar  29 08:16:11 2009
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--



From newbie.poster@yahoo.com Mon Mar  30 23:12:23 2009
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 980B4633FF4
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 30 Mar 2009 20:12:23 -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 31966-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 30 Mar 2009 20:12:21 -0300 (ADT)
X-Greylist: delayed 00:06:31.360219 by SQLgrey-1.7.6
Received: from n64.bullet.mail.sp1.yahoo.com (n64.bullet.mail.sp1.yahoo.com
	[98.136.44.189])
	by mail.postgresql.org (Postfix) with SMTP id EECCD63322A
	for <pgsql-admin@postgresql.org>; Mon, 30 Mar 2009 20:12:20 -0300 (ADT)
Received: from [69.147.84.145] by n64.bullet.mail.sp1.yahoo.com with NNFMP;
	30 Mar 2009 23:05:46 -0000
Received: from [69.147.65.166] by t8.bullet.mail.sp1.yahoo.com with NNFMP;
	30 Mar 2009 23:05:46 -0000
Received: from [127.0.0.1] by omp501.mail.sp1.yahoo.com with NNFMP;
	30 Mar 2009 23:05:46 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 883079.46310.bm@omp501.mail.sp1.yahoo.com
Received: (qmail 25602 invoked by uid 60001); 30 Mar 2009 23:05:46 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1238454346; bh=rwjQqA4jNN9zwQ3VWumLFn0yXIKWDTLCWl90IZ0t/fo=;
	h=Message-ID:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=cTrSZoP3+tSe6xabsv4WAHhluXBlCxgSKTGRE/qTZS6VCN70E4/kwC9IUmhQA9sH8bvThtwRx7biNZBPOMUMu4BOFCfegRZSkBfyyr+0NejDXuMlHBF1aPfvRY+anYY/NJg0NZH50w7Fhk52IGYY4LvexVt+OPG/aQ/ufC442+E=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=dKwN3b5jufjXOH/LYh9tfZp5wJF7vxBUIp+Zay+oHE57XVF4BbnEFcULNw3rDSB0xwk44VKL1meqUP3bWpWme1VfFekm9mlMc4++AKW/q5vIGdVNKGZ0hdSIXnXEs5IZHBz63vGSPk9Km2dDcfPuouXa074yBLHdnBIkYHXGLkM=;
Message-ID: <668514.21038.qm@web43409.mail.sp1.yahoo.com>
Received: from [216.254.18.193] by web43409.mail.sp1.yahoo.com via HTTP;
	Mon, 30 Mar 2009 16:05:46 PDT
X-Mailer: YahooMailRC/1277.32 YahooMailWebService/0.7.289.1
References: <32212646.293281238306317487.JavaMail.root@mail.4linux.com.br>
Date: Mon, 30 Mar 2009 16:05:46 -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: <32212646.293281238306317487.JavaMail.root@mail.4linux.com.br>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1120819060-1238454346=:21038"
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/252
X-Sequence-Number: 31752


--0-1120819060-1238454346=:21038
Content-Type: text/plain; charset=us-ascii

I am fairly sure my pg_hba file is correct.  Here is what I have under IP4 connections:

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         10.0.0.0/8          md5

Is anything else required to access the database from a different machine running pgAdmin3?




________________________________
From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
To: Newbie Poster <newbie.poster@yahoo.com>
Cc: pgsql-admin@postgresql.org
Sent: Saturday, March 28, 2009 10:58:37 PM
Subject: Re: Logging in with postgres remotely


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



      
--0-1120819060-1238454346=:21038
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>I am fairly sure my pg_hba file is correct.&nbsp; Here is what I have under IP4 connections:<br><br># IPv4 local connections:<br>host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.0.0.1/32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; md5<br>host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.0.0.0/8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; md5<br><br>Is anything else required to access the database from a different machine running pgAdmin3?<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size:
 12pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Flavio Henrique Araque Gurgel &lt;flavio@4linux.com.br&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;">Cc:</span></b> pgsql-admin@postgresql.org<br><b><span style="font-weight: bold;">Sent:</span></b> Saturday, March 28, 2009 10:58:37 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: Logging in with postgres remotely<br></font><br>
<style type="text/css">p {margin:0;}</style><div style="font-family: Times New Roman; font-size: 12pt; color: rgb(0, 0, 0);">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></div></div></div><br>



      </body></html>
--0-1120819060-1238454346=:21038--




From tsakai@gallo.ucsf.edu Tue Mar  31 00:43:47 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 4F358634046
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 30 Mar 2009 21:43:47 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 93070-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 30 Mar 2009 21:43:36 -0300 (ADT)
Received: from mx1.hub.org (mx1.hub.org [200.46.208.106])
	by mail.postgresql.org (Postfix) with ESMTP id 4510D633CB8
	for <pgsql-admin@postgresql.org>; Mon, 30 Mar 2009 21:43:44 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail12.egcrc.net (mail12.egcrc.net [63.193.204.12])
	by mx1.hub.org (Postfix) with ESMTP id B1821125A2A1
	for <pgsql-admin@postgresql.org>; Mon, 30 Mar 2009 21:43:39 -0300 (ADT)
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C9B199.B7D81B39"
Subject: Re: Logging in with postgres remotely
Date: Mon, 30 Mar 2009 17:43:32 -0700
Message-ID: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84A5B@egcrc-ex01.egcrc.org>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [ADMIN] Logging in with postgres remotely
Thread-Index: AcmxjUQFqEdW2aLgTw6L1qcdEELMxAACq/gS
References: <32212646.293281238306317487.JavaMail.root@mail.4linux.com.br>
	<668514.21038.qm@web43409.mail.sp1.yahoo.com>
From: "Tena Sakai" <tsakai@gallo.ucsf.edu>
To: "Newbie Poster" <newbie.poster@yahoo.com>,
	"PGSQL Admin" <pgsql-admin@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.049 tagged_above=0 required=5 tests=AWL=0.048,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/253
X-Sequence-Number: 31753

This is a multi-part message in MIME format.

------_=_NextPart_001_01C9B199.B7D81B39
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

Let me see if I understand your situation.

a) you have a postgresql running on a host --let's for
   the sake of concreteness, call this machine apple.
b) you want to connect via pgAdmin3 which runs on
   a workstation, call this workstation orange.
c) when you supply a password to pgAdmin3, the postgresql
   on machine apple rejects you.

If any of this is wrong, let me know.

d) on machine apple, do you have .pgpass file?  If so,
   is the permission on this file correct?
e) to pgAdmin3, what password are you giving?  Apple's
   or Orange's?

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Newbie Poster
Sent: Mon 3/30/2009 4:05 PM
To: PGSQL Admin
Subject: Re: [ADMIN] Logging in with postgres remotely
=20
I am fairly sure my pg_hba file is correct.  Here is what I have under =
IP4 connections:

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         10.0.0.0/8          md5

Is anything else required to access the database from a different =
machine running pgAdmin3?




________________________________
From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
To: Newbie Poster <newbie.poster@yahoo.com>
Cc: pgsql-admin@postgresql.org
Sent: Saturday, March 28, 2009 10:58:37 PM
Subject: Re: Logging in with postgres remotely


Hi Newbie

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

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:
>=20
> grant all privileges on database clients to user pgAdmin
>=20
> 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



     =20


------_=_NextPart_001_01C9B199.B7D81B39
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7654.12">
<TITLE>RE: [ADMIN] Logging in with postgres remotely</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=3D2>Hi,<BR>
<BR>
Let me see if I understand your situation.<BR>
<BR>
a) you have a postgresql running on a host --let's for<BR>
&nbsp;&nbsp; the sake of concreteness, call this machine apple.<BR>
b) you want to connect via pgAdmin3 which runs on<BR>
&nbsp;&nbsp; a workstation, call this workstation orange.<BR>
c) when you supply a password to pgAdmin3, the postgresql<BR>
&nbsp;&nbsp; on machine apple rejects you.<BR>
<BR>
If any of this is wrong, let me know.<BR>
<BR>
d) on machine apple, do you have .pgpass file?&nbsp; If so,<BR>
&nbsp;&nbsp; is the permission on this file correct?<BR>
e) to pgAdmin3, what password are you giving?&nbsp; Apple's<BR>
&nbsp;&nbsp; or Orange's?<BR>
<BR>
Regards,<BR>
<BR>
Tena Sakai<BR>
tsakai@gallo.ucsf.edu<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: pgsql-admin-owner@postgresql.org on behalf of Newbie Poster<BR>
Sent: Mon 3/30/2009 4:05 PM<BR>
To: PGSQL Admin<BR>
Subject: Re: [ADMIN] Logging in with postgres remotely<BR>
<BR>
I am fairly sure my pg_hba file is correct.&nbsp; Here is what I have =
under IP4 connections:<BR>
<BR>
# IPv4 local connections:<BR>
host&nbsp;&nbsp;&nbsp; =
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
127.0.0.1/32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
md5<BR>
host&nbsp;&nbsp;&nbsp; =
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
10.0.0.0/8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; md5<BR>
<BR>
Is anything else required to access the database from a different =
machine running pgAdmin3?<BR>
<BR>
<BR>
<BR>
<BR>
________________________________<BR>
From: Flavio Henrique Araque Gurgel &lt;flavio@4linux.com.br&gt;<BR>
To: Newbie Poster &lt;newbie.poster@yahoo.com&gt;<BR>
Cc: pgsql-admin@postgresql.org<BR>
Sent: Saturday, March 28, 2009 10:58:37 PM<BR>
Subject: Re: Logging in with postgres remotely<BR>
<BR>
<BR>
Hi Newbie<BR>
<BR>
----- &quot;Newbie Poster&quot; &lt;newbie.poster@yahoo.com&gt; =
escreveu:<BR>
<BR>
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>
<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>
<BR>
<BR>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>
<BR>
</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C9B199.B7D81B39--