--- On Thu, 6/18/09, David Shen <davidshe...@googlemail.com> wrote:

> From: David Shen <davidshe...@googlemail.com>
> 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 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 change the host access
> control to this:
> host    all     
>    all     
>    127.0.0.1/32       
>   trust
> 
> but it still does not work. What I missed?
> 
> 
> -- 
> Best Regards,
> David Shen
> 
> -- 
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> 

waht is the ip number of the host machien and the remote machine to try connect

you can pass a password to the string conection

"host=>127.0.0.1 dbname=>mydb user=>myuser password=>mypassword"

maybe the problem is the net direction 127.0.0.x check this 






-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to