Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 980B4633FF4 for ; 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 ; 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 ; 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 Subject: Re: Logging in with postgres remotely To: PGSQL Admin 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 To: Newbie Poster 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" 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
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--