From: Martin Fandel <martin.fandel@alphyra-evs.de>
To: Nirav Parikh <nirav.p@workskillsprofessionals.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: connection error
Date: Wed, 21 Sep 2005 09:46:32 +0200
Message-ID: <1127288792.20648.22.camel@fandelm.tc.de> (raw)
In-Reply-To: <221385EC3F18A44DB0925467A1D2395F34A336@exsrv3.workskillsprofes>
References: <221385EC3F18A44DB0925467A1D2395F34A336@exsrv3.workskillsprofes>
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:Notebook.jpg (image/jpeg, 2.9K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: martin.fandel@alphyra-evs.de, nirav.p@workskillsprofessionals.com.au
Subject: Re: connection error
In-Reply-To: <1127288792.20648.22.camel@fandelm.tc.de>
References: <221385EC3F18A44DB0925467A1D2395F34A336@exsrv3.workskillsprofes> <1127288792.20648.22.camel@fandelm.tc.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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