On 2009-06-18, David Shen <davidshen84@xxxxxxxxxxxxxx> 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 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? postgres doesn't know who you are! specify a user in the connection string. you can use "ident sameuser" over TCP connections but it is no more secure than the originating host. (it works via RFC1413) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
