On Tue, Jul 10, 2001 at 08:26:56PM -0400, Xue-Feng Yang wrote:
> Can anyone help me on the following problem?
>
> $psql -h localhost
>
> psql: PQconnectPoll() -- connect() failed: Connection
> refused
> Is the postmaster running (with -i) at
> 'localhost'
> and accepting connections on TCP/IP port '5432'?
1. Is the postmaster process running? Check using 'ps'.
2. Is the postmaster not listening on TCP? Check using 'netstat -lnp'.
Example of what you should see:
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN
31693/postmaster
unix 0 [ ACC ] STREAM LISTENING 68763 31693/postmaster
/var/run/postgresql/.s.PGSQL.5432
--
Henry House
OpenPGP key available from http://romana.hajhouse.org/hajhouse.asc
PGP signature
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
