On Tue, May 4, 2010 at 11:43 PM, Akul Gupta <akulgupta2...@gmail.com> wrote:
> sir, i m facing a problem.
> While conneting through pgsql from PHP, it asks for a password.
> While i have not given any password at the time of installation.
> So, please tell me the solution.
> Reply as soon as possible.
> I am waiting.
>

The best you can do is to edit pg_hba.conf and add a line like this:

local       all        all                                               trust

connect to pgsql as postgres user and execute ALTER ROLE
user_you're_connecting_to_in_app  PASSWORD 'yourpassword';

then add to pg_hba.conf a line like this:

host       dbname username                   ip_web_server/32           md5


-- 
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL

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

Reply via email to