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 [email protected] -----Original Message----- From: [email protected] on behalf of Newbie Poster Sent: Mon 3/30/2009 4:05 PM To: PGSQL Admin Subject: Re: [ADMIN] Logging in with postgres remotely 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 <[email protected]> To: Newbie Poster <[email protected]> Cc: [email protected] Sent: Saturday, March 28, 2009 10:58:37 PM Subject: Re: Logging in with postgres remotely Hi Newbie ----- "Newbie Poster" <[email protected]> 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
