Skip site navigation (1) Skip section navigation (2)

Pgsql-PHP connection problem

From: "Nirav Parikh" <nirav(dot)p(at)workskillsprofessionals(dot)com(dot)au>
To: <pgsql-php(at)postgresql(dot)org>
Subject: Pgsql-PHP connection problem
Date: 2005-09-28 01:10:07
Message-ID: 221385EC3F18A44DB0925467A1D2395F34A621@exsrv3.workskillsprofessionals.com.au (view raw or flat)
Thread:
Lists: pgsql-php
Hi Everyone,
 
I have setup new server running on Fedora Core 4. I am having problem connecting Php to Postgresql database. Now I also got couple of old server running same thing. I can connect through one of the existing server to this Postgresql database on new server. But Can't connect locally. 
 
This is the error message I get
 
"DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -24 [message] => DB Error: connect failed [userinfo] => [nativecode=Warning: pg_pconnect() [function.pg-pconnect]: Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? in /usr/share/pear/DB/pgsql.php on line 124] ** pgsql........"
 

File settings:
 
Pg_hba.conf file settings:
 
local  all    all                                                                              trust
host   all    all             127.0.0.1             255.255.255.255           trust

 
postgresql.conf file settings: 
 
listen_addresses = '*' 
port='5432'
 

Does anyone know how to resolve this? 
 
Thanks in advance.
 
Regards,
 
Nirav
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.8/113 - Release Date: 27/09/2005
 

Responses

pgsql-php by date

Next:From: John DeSoiDate: 2005-09-28 02:16:15
Subject: Re: Pgsql-PHP connection problem
Previous:From: John DeSoiDate: 2005-09-24 13:17:20
Subject: Re: pg_fetch_object

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group