Thread: connecting To PostgreSQL - Getting Error

connecting To PostgreSQL - Getting Error

From
Riyaz@umapinc.com
Date:

Hello All,
    I am running Postgresql on a linux Qube and trying to connect to it using PHP. But it is giving me the following error:

Warning: Unable to connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port '5583'? in /home/groups/smarttools/web/testpg2.php on line 21

I don't think I am using Unix sockets as I can connect to the database on psql monitor without -i option and without specifying the port number.

Any tips on solving this?

Also in what files are connectDB - - connect() functions stored?

Thanks,
Riyaz.

Re: connecting To PostgreSQL - Getting Error

From
Dan Wilson
Date:
That port is not standard.  Are you sure that is the correct port to connect
with?  Also, make sure you are using the tcpip_socket.  Check your
postgresql.conf file and uncomment and turn on the tcpip_socket option.

Your other option is to just connect using the local socket (which is more
secure anyway).  You can do this by just leaving of the host option in your
connection string.

-Dan

Quoting Riyaz@umapinc.com:

> Hello All,
>     I am running Postgresql on a linux Qube and trying to connect to it
> using PHP. But it is giving me the following error:
>
> Warning: Unable to connect to PostgreSQL server: connectDB() -- connect()
> failed:
> Connection refused Is the postmaster running (with -i) at 'localhost' and
> accepting connections on TCP/IP port '5583'? in
> /home/groups/smarttools/web/testpg2.php on line 21
>
> I don't think I am using Unix sockets as I can connect to the database on
> psql monitor without -i option and without specifying the port number.
>
> Any tips on solving this?
>
> Also in what files are connectDB - - connect() functions stored?
>
> Thanks,
> Riyaz.