From: | John Taber <jtaber(at)johntaber(dot)net> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: php + postgresql pg_connect problem |
Date: | 2005-12-13 23:53:11 |
Message-ID: | 439F5EE7.2050408@johntaber.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Maclean | 2005-12-14 00:16:28 | User entry of parameters in queries/views. |
Previous Message | Daniel Hertz | 2005-12-13 23:01:39 | Multi-row update w. plpgsql function |