Re: can't connect to postmaster from other machine - Mailing list pgsql-novice

[in reply to folken@mac.com, 07/02/2002]

> psql: PQconnectPoll() -- connect() failed: Operation timed out
>          Is the postmaster running (with -i) at '192.168.0.21'
>          and accepting connections on TCP/IP port 5432?

There are two ways to talk to postmaster:
a) via a UNIX socket (on the local machine)
b) via TCP-IP (local or via the network)

By default, postmaster does not listen on a TCP port. If the network is
okay and you can ping 192.168.0.21 successfully, chances are that
postmaster does not have a TCP port open, so it is not listening to
queries from the network.

Edit postgresql.conf on your database server machine, scroll down to where
it says "Connection Parameters". Is the value "tcpip_socket" set to true?
If it's set to false, change that and restart postmaster.

If it IS set to true, there is something else going on. If so, please
reply!

good luck,
walter

--
 Walter Hop <walter@binity.com>
 Updated contact information: http://www.binity.com/~walter/