From: | Henry House <hajhouse(at)houseag(dot)com> |
---|---|
To: | Xue-Feng Yang <just4look(at)yahoo(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: newbie question |
Date: | 2001-07-11 01:50:25 |
Message-ID: | 20010710185025.A10435@houseag.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Xue-Feng Yang | 2001-07-11 03:24:26 | Re: newbie question |
Previous Message | Grant | 2001-07-11 01:05:47 | Re: newbie question |