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

connection error

From: "Nirav Parikh" <nirav(dot)p(at)workskillsprofessionals(dot)com(dot)au>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: connection error
Date: 2005-09-21 07:30:52
Message-ID: 221385EC3F18A44DB0925467A1D2395F34A336@exsrv3.workskillsprofessionals.com.au (view raw or flat)
Thread:
Lists: pgsql-admin
 
Hi, 
 
I build the new server running FC4. I am having problem connecting to Postgresql database from php. I get the following error message when I am trying to connect
 
"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........"
 
I can connect through our existing server to this Postgresql database. Its just not connecting locally. 
 
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 = '*' 
 
I dont know what else to check. 

Thanks in Advance. 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/2005
 
  

pgsql-admin by date

Next:From: Martin FandelDate: 2005-09-21 07:46:32
Subject: Re: connection error
Previous:From: Magnus HaganderDate: 2005-09-21 07:19:18
Subject: Re: postgresql cluster on SAN

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