View Single Post

   
  #2 (permalink)  
Old 05-07-2008, 11:17 AM
Marcelo Martins
 
Posts: n/a
Default Re: PQconnectdb question and md5 password

How do you have your pg_hba.conf file setup ?

If on the shell as the postgres user, you can login into the
"db_stats" database without a password being asked for than you should
not need one.
Try out:

postgres$> psql db_stats

and see if you can login without asking for a PW.. check your
pg_hba.conf first though.


On May 6, 2008, at 5:07 AM, Guy Deleeuw wrote:

> Hello,
>
> I don't know how can I pass a md5 password to the password field ?
> example :
> connInfo = "host=localhost port=5432 dbname=db_stats user=postgres
> password=secret";
> pConn = PQconnectdb(connInfo);
>
> I try to replace the string 'secret' by the content of /etc/shadow
> but without succès.
>
> Thanks in advance
>
> Guy
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin



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

Reply With Quote