Thread: pg_connect problem

pg_connect problem

From
"Edric Bulalacao"
Date:

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!

 

This is the code I’m trying to run:

$connection = pg_connect("host=localhost dbname=address user=address password=address");

 

This is my pg_hba.conf

local  all      all             password

 

This is the output of “netstat –an | grep 5432”

unix  2      [ ACC ]     STREAM     LISTENING     27649  /tmp/.s.PGSQL.5432

 

I’m able to do “psql –u address” and supply and username and password as any Unix user defined in the system.

 

 

Can anyone tell me what I’m doing wrong?  Thanks.

 

Re: pg_connect problem

From
nzegarra@kolareal.net
Date:
in your pg_hba.conf must set a line with the follow:


local all all 127.0.0.1 255.255.255.255 trust
local all all IP.OF.YOUR.MACHINE YOUR.GATEWAY trust

and in your postgresql.conf must set the port = 5432 without the comment
restart the postgresql and it must work

Regards


Nilson

> 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!
>
> This is the code I’m trying to run:
> $connection = pg_connect("host=localhost dbname=address user=address
> password=address");
>
> This is my pg_hba.conf
> local  all      all             password
>
> This is the output of “netstat –an | grep 5432”
> unix  2      [ ACC ]     STREAM     LISTENING     27649
> /tmp/.s.PGSQL.5432
>
> I’m able to do “psql –u address” and supply and username and password as
> any
> Unix user defined in the system.
>
>
> Can anyone tell me what I’m doing wrong?  Thanks.
>
>


Re: pg_connect problem

From
Robby Russell
Date:
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@commandprompt.com]
> 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@commandprompt.com | Telephone: (503) 222.2783