pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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) download view image

view thread (2+ messages)

Message-ID: <1127288792.20648.22.camel@fandelm.tc.de>
Permalink:  ../1127288792.20648.22.camel@fandelm.tc.de/
Also on:    postgresql.org/message-id/1127288792.20648.22.camel@fandelm.tc.de

 · 

reply

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