Re: connecting to a remote pq always require a password

--- On Thu, 6/18/09, David Shen <davidshen84(at)googlemail(dot)com> wrote:

> From: David Shen <davidshen84(at)googlemail(dot)com>
> Subject: [GENERAL] connecting to a remote pq always require a password
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)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