Thread: question
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. --------------Akul gupta
How did you install PostgreSQL? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com> On Wed, May 5, 2010 at 10:13 AM, Akul Gupta <akulgupta2008@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. > > --------------Akul gupta > >
On Tue, May 4, 2010 at 11:43 PM, Akul Gupta <akulgupta2008@gmail.com> wrote: > sir, i m facing a problem. > While conneting through pgsql from PHP,=C2=A0it 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 tr= ust 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 --=20 Jaime Casanova www.2ndQuadrant.com Soporte y capacitaci=C3=B3n de PostgreSQL