Thread: query related to pgsql

query related to pgsql

From
Abhishek Maurya
Date:
sir,
while connecting php with database created in postgres,we r facing one error
..errror is that its demanding a password of postgres..but while installing
or using postgres we hadnt gave any password.. so hw cn we solve this
problem..

Re: query related to pgsql

From
"Kevin Grittner"
Date:
Abhishek Maurya <abhi.cse.dit@gmail.com> wrote:

> while connecting php with database created in postgres,we r facing
> one error ..errror is that its demanding a password of
> postgres..but while installing or using postgres we hadnt gave any
> password.. so hw cn we solve this problem..

You haven't really given enough information to allow me to advise
you with much confidence.  In general, you might want to check the
documentation of the pg_hba.conf file.  If this doesn't do it for
you, please read the "Guide to reporting problems" page:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

If you repost, you should choose a more appropriate list, like
pgsql-admin or pgsql-general.

Oh, and messages are easier to read and understand if some attempt
is made at conventional spelling, capitalization, and punctuation.
I understand that many posters don't speak English as their first
language, but please do what you can.

-Kevin

Re: query related to pgsql

From
Geoffrey Pitman
Date:
Firstly, this doesn't seem like a bug at all. So, I think you're in the
wrong list. That said, here are some hints that might help you get started
through the troubleshooting necessary:

1) Are you able to connect to the server using the psql command line utility
(it's best to start there before moving on to layers of complexity)? [Do
this from the actual server machine--not from a remote machine to eliminate
other sources of error]

2) If not, is the PostgreSQL service started? (If the server is not started,
consult your OS documentation on how to start the service)

3) If the service is started: Is it listening on the default port or
another, or not listening at all? Check your configuration files if not.

4) If the service is started and listening, can you access it from another
system (WITHOUT USING PHP)?

5) If so, begin troubleshooting PHP. Is your web server actively serving PHP
(have you run a test document through it)?

6) If so, is the pgsql module loaded?

7) If so, are there any permissions errors or other confounding items in the
server setup?

That's as much as I can think of off the top of my head. I'm pretty new to
all of this myself as I'm self-taught over the past several months. You may
find more capable and knowledgeable assistance on another mailing list.
Maybe the ADMIN list?

I hope this helps,

Geoff


On Tue, Apr 20, 2010 at 9:48 AM, Kevin Grittner <Kevin.Grittner@wicourts.gov
> wrote:

> Abhishek Maurya <abhi.cse.dit@gmail.com> wrote:
>
> > while connecting php with database created in postgres,we r facing
> > one error ..errror is that its demanding a password of
> > postgres..but while installing or using postgres we hadnt gave any
> > password.. so hw cn we solve this problem..
>
> You haven't really given enough information to allow me to advise
> you with much confidence.  In general, you might want to check the
> documentation of the pg_hba.conf file.  If this doesn't do it for
> you, please read the "Guide to reporting problems" page:
>
> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
> If you repost, you should choose a more appropriate list, like
> pgsql-admin or pgsql-general.
>
> Oh, and messages are easier to read and understand if some attempt
> is made at conventional spelling, capitalization, and punctuation.
> I understand that many posters don't speak English as their first
> language, but please do what you can.
>
> -Kevin
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>