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