Skip site navigation (1) Skip section navigation (2)

Re: connection refused problem

From: Darren Ferguson <darren(at)crystalballinc(dot)com>
To: Phil Glatz <phil(at)glatz(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: connection refused problem
Date: 2002-05-30 18:05:04
Message-ID: Pine.LNX.4.10.10205301403320.10025-100000@thread.crystalballinc.com (view raw or flat)
Thread:
Lists: pgsql-general
Modify the pg_ctl script and it should run the postmaster.
What you do is add the -i flag there. Alternatively you can add
to pg_hba.conf file i think it is TCP = yes. I am not sure but you can
check the documentation about that one but the -i flag on postmaster
definately works

HTH

Darren Ferguson

On Thu, 30 May 2002, Phil Glatz wrote:

> 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'
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 


In response to

Responses

pgsql-general by date

Next:From: Antai NingDate: 2002-05-30 18:11:09
Subject: The application dies when insertion fails.
Previous:From: Steve WolfeDate: 2002-05-30 17:50:53
Subject: Re: Scaling with memory & disk planning (was Re: Non-linear Performance)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group