Re: [ADMIN] Logging in with postgres remotely

2009-03-30 Thread Tena Sakai
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

Re: [ADMIN] Logging in with postgres remotely

2009-03-30 Thread Newbie Poster
I am fairly sure my pg_hba file is correct. Here is what I have under IP4 connections: # IPv4 local connections: hostall all 127.0.0.1/32 md5 hostall all 10.0.0.0/8 md5 Is anything else required to access the database from a different ma

Re: [ADMIN] Logging in with postgres remotely

2009-03-29 Thread Flavio Henrique Araque Gurgel
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

Re: [ADMIN] Logging in with postgres remotely

2009-03-27 Thread Newbie Poster
, 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/