Re: PQconnectdb question and md5 password - Mailing list pgsql-admin

From Marcelo Martins
Subject Re: PQconnectdb question and md5 password
Date
Msg-id 7A9FA81F-5F0F-4CD0-B42A-AE9CB7B3C941@zeroaccess.org
Whole thread Raw
In response to PQconnectdb question and md5 password  (Guy Deleeuw <G.De_Leeuw@eurofer.be>)
Responses Re: PQconnectdb question and md5 password  (Guy Deleeuw <G.De_Leeuw@eurofer.be>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Guy Deleeuw
Date:
Subject: PQconnectdb question and md5 password
Next
From: Marcelo Martins
Date:
Subject: Re: PQconnectdb question and md5 password