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@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
