Edric Bulalacao wrote:
Thank you for the quick reply. Looks like all the lines in my
postgresql.conf file are all commented out.
I will uncomment the tcpip_socket and port lines lines to see if it works:
No problem. I've run into this on several occasions when I'm setting up
a new server and forget to make that one minor little change. It's a
good default security setting, however it adds one extra little step for
us. heh
-Robby
# Connection Parameters
#
#tcpip_socket = true
#ssl = false
#max_connections = 32
#superuser_reserved_connections = 2
#port = 5432
#hostname_lookup = false
#show_source_port = false
-----Original Message-----
From: Robby Russell [mailto:rrussell@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, September 03, 2003 10:48 AM
To: Edric Bulalacao
Subject: Re: [PHP] pg_connect problem
Edric Bulalacao wrote:
I'm a PHP/PostGRE newbie. I'm getting this error:
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
localhost and accepting TCP/IP connections on port 5432? . in
/export/home/tsc/a/delete-action.phtml on line 156
Couldn't make a connection!
Can anyone tell me what I'm doing wrong? Thanks.
Look at your postgres.conf file.
Is TCP/IP on?
tcpip_socket = true
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
rrussell@xxxxxxxxxxxxxxxxx | Telephone: (503) 222.2783