From: Henry House <hajhouse@houseag.com>
To: Xue-Feng Yang <just4look@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: newbie question
Date: Tue, 10 Jul 2001 18:50:25 -0700
Message-ID: <20010710185025.A10435@houseag.com> (raw)
In-Reply-To: <20010711002656.99933.qmail@web14604.mail.yahoo.com>
References: <20010711002656.99933.qmail@web14604.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hajhouse@houseag.com, just4look@yahoo.com
Subject: Re: newbie question
In-Reply-To: <20010710185025.A10435@houseag.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox