Re: Set a blank password for a db user - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Set a blank password for a db user
Date
Msg-id 20051128224333.GG78939@pervasive.com
Whole thread Raw
In response to Set a blank password for a db user  ("Rembrandt" <nedeus@gmail.com>)
List pgsql-general
Read up on pg_hba.conf:
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
You might not need to use password authentication.

Short of that, have a look at
http://www.postgresql.org/docs/current/static/libpq-pgpass.html

On Thu, Nov 24, 2005 at 12:37:57AM -0800, Rembrandt wrote:
> Hi,
>
> I'm new to postgresql and i have an easy question to ask. I have
> installed postgresql 8.1 on windows 2000 and i want to use it with my
> app developed with php 5 + apache 2.
> All works well but i need to know if this is possible :
> I use pgAdminIII as administration tool an i need to create a
> restriceted grants db user that haven't a password set so i can connect
> from php using this statement :
>
> pg_connect ("dbname=dbname user=username password=")
>
> As i saw, if i leave the password blank for the user "username" (inside
> the pgAdmin) i cant connect to db from php pages. Instead, if i set a
> password for the user and use this statement :
>
> pg_connect ("dbname=dbname user=username password=aaa")
>
> the connection is established ....
>
> Is there a manner to avoid this ?
>
> Thanks in advance,
> Claudio
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: dumping data to version control using pg_dump?
Next
From: Phong & Ronni Bounmixay
Date:
Subject: Re: sub select as a data column