pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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:

Notebook.jpg (image/jpeg, 2.9K) download view image
^ permalink raw reply [nested|flat] 2+ messages in thread

* 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:

Notebook.jpg (image/jpeg, 2.9K) download view image
^ permalink raw reply [nested|flat] 2+ messages in thread


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