pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
connection error 2+ messages / 2 participants [nested] [flat]
* connection error @ 2005-09-21 07:30 Nirav Parikh <nirav.p@workskillsprofessionals.com.au> 0 siblings, 0 replies; 2+ messages in thread From: Nirav Parikh @ 2005-09-21 07:30 UTC (permalink / raw) To: 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 Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadNotebook.jpg (image/jpeg, 2.9K) download
view image
* Re: connection error @ 2005-09-21 07:46 Martin Fandel <martin.fandel@alphyra-evs.de> 0 siblings, 0 replies; 2+ messages in thread From: Martin Fandel @ 2005-09-21 07:46 UTC (permalink / raw) To: Nirav Parikh <nirav.p@workskillsprofessionals.com.au>; +Cc: pgsql-admin Hi, check "port = 5432" in postgresql.conf and have look to "netstat -anp | grep postmaster"... Best regards, Martin Am Mittwoch, den 21.09.2005, 15:30 +0800 schrieb Nirav Parikh: > > 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 > > Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadNotebook.jpg (image/jpeg, 2.9K) download
view image
end of thread, other threads:[~2005-09-21 07:46 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-09-21 07:30 connection error Nirav Parikh <nirav.p@workskillsprofessionals.com.au> 2005-09-21 07:46 Re: connection error Martin Fandel <martin.fandel@alphyra-evs.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox