connection refused problem

From: Phil Glatz <phil(at)glatz(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: connection refused problem
Date: 2002-05-30 17:17:38
Message-ID: 5.1.0.14.2.20020530101129.00af8378@flawless.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I bringing up PostgreSQL 7.1.3 on a Free BSD 4.5 system, installed from
ports, using defaults. I copied the sample versions of pg_hba.conf and
postgresql.conf to new files, removing the .sample part.

This command works fine:
psql -U pgsql database

but if I specify a hostname:
psql -U pgsql -h localhost cn

I get:
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running (with -i) at 'localhost'
and accepting connections on TCP/IP port 5432?

I have local hosts defined in /etc/hosts, and in /tmp I see:
srwxrwxrwx 1 pgsql wheel 0 May 30 10:15 .s.PGSQL.5432=
-rw------- 1 pgsql wheel 28 May 30 10:15 .s.PGSQL.5432.lock

Sorry for such an obviously dumb question, I didn't see anything in the FAQ
other than "add the -i flag to postmaster", but I didn't see how to do
that. The core line in my startup script is:

'[ -d ${PGDATA} ] && exec /usr/local/bin/pg_ctl start -s -w -l ~pgsql/errlog'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Sugawara 2002-05-30 17:18:20 Re: Cannot build JDBC driver in 7.1.3.
Previous Message McCaffity, Ray (Contractor) 2002-05-30 17:01:58 Re: erros when making examples in /src/test/examples