Search Postgresql Archives

Re: php + postgresql pg_connect problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Huxton wrote:
John Taber wrote:

I am having trouble connecting php(5.1.1) and postgresql(8.1) running on
Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and
a database (tempdb).  If I run psql -l it shows the database "tempdb"
with the username "tempuser".  But I get the following error using
pg_connect:

Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: Ident authentication failed for user
"tempuser" in /var/www/db_connect.php on line 14


You are using "ident" authentication in your pg_hba.conf file. You probably don't want this. Start with trust if you are connecting locally, then turn passwords on once you are happy you can connect.

Thks for directing me to the pg_hda file - I have made the changes - But I may have a bigger problem (postmaster). I tried to restart postmaster and found that I don't have a pg_ctl program or script in my /usr/bin There is a pg_ctlcluster. Is that new and replaces pg_ctl ? Any reason pg_ctl could be missing (am I missing a package ?). While on this subject, is there a way to ensure postmaster is started on boot - I see postgres scripts in the /etc/rd.d folder - is that enough? I have the Douglas postgresql book to follow details (but haven't read it all) thks.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux