Search Postgresql Archives

Re: connecting to a remote pq always require a password

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





--- On Thu, 6/18/09, David Shen <davidshen84@xxxxxxxxxxxxxx> wrote:

> From: David Shen <davidshen84@xxxxxxxxxxxxxx>
> Subject:  connecting to a remote pq always require a password
> To: pgsql-general@xxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxx)
> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux