Lists: | pgsql-bugs |
---|
From: | Akul Gupta <akulgupta2008(at)gmail(dot)com> |
---|---|
To: | bugs(at)postgresql(dot)org |
Subject: | question |
Date: | 2010-05-05 04:43:13 |
Message-ID: | k2j8614b2451005042143hfe37c6c8p90a5b03646ba11c0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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
From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | Akul Gupta <akulgupta2008(at)gmail(dot)com> |
Cc: | bugs(at)postgresql(dot)org |
Subject: | Re: question |
Date: | 2010-05-05 14:14:27 |
Message-ID: | z2r8cf965d31005050714q183690aene718d6af8938a637@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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(at)gmail(dot)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
>
>
From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Akul Gupta <akulgupta2008(at)gmail(dot)com> |
Cc: | bugs(at)postgresql(dot)org |
Subject: | Re: question |
Date: | 2010-05-05 14:23:45 |
Message-ID: | l2n3073cc9b1005050723n155f157ega2e9bb5b6549b386@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On Tue, May 4, 2010 at 11:43 PM, Akul Gupta <akulgupta2008(at)gmail(dot)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