Re: [GENERAL] connecting to a remote pq always require a password

2009-06-19 Thread Jasen Betts
On 2009-06-18, David Shen wrote: > Hi, > > I am trying to use the libpq to connect to my postgresql 8.3 server. > If I use "dbname = mydb", the connection made successfully because I > am using a socket connection. But if I use "host = 127.0.0.1 dbname = > mydb", the error message is "no password

Re: [GENERAL] connecting to a remote pq always require a password

2009-06-18 Thread Lennin Caro
--- On Thu, 6/18/09, David Shen wrote: > From: David Shen > Subject: [GENERAL] connecting to a remote pq always require a password > To: pgsql-general@postgresql.org > Date: Thursday, June 18, 2009, 12:11 PM > Hi, > > I am trying to use the libpq to connect to my po

Re: [GENERAL] connecting to a remote pq always require a password

2009-06-18 Thread John DeSoi
On Jun 18, 2009, at 8:11 AM, David Shen wrote: In the pg_hba.conf file, I even change the host access control to this: hostall all 127.0.0.1/32 trust but it still does not work. What I missed? Did you reload the configuration (or restart the sever) after making

[GENERAL] connecting to a remote pq always require a password

2009-06-18 Thread David Shen
Hi, I am trying to use the libpq to connect to my postgresql 8.3 server. If I use "dbname = mydb", the connection made successfully because I am using a socket connection. But if I use "host = 127.0.0.1 dbname = mydb", the error message is "no password supplied". In the pg_hba.conf file, I even c