Connection Refused Error - Mailing list pgsql-general

From JohnD
Subject Connection Refused Error
Date
Msg-id 49B5A235.1010002@johndubchak.com
Whole thread Raw
Responses Re: Connection Refused Error  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Connection Refused Error  (Adrian Klaver <aklaver@comcast.net>)
Re: Connection Refused Error  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Hi,

I have two "identical" servers running CentOS 5.2 with PostgreSQL 8.3.5
installed on both.  Prior to a reboot this morning, I was able to
connect, remotely, to both of them and doing telnet <serve-rname> 5432
brought up a prompt for them as well.

However, I am now in the unfortunate situation of not being able to
connect remotely to one particular server and cannot for the life of me
figure out why  I am getting a connection refused:

Connection refused. Check that the hostname and port are correct and
that the postmaster is accepting TCP/IP connections.

I can ssh into the server and do a psql <db-name> from the
/var/lib/pgsql command prompt, as user postgres.  But, when I try to use
a different user (psql -U user -p <db-name>), from the same prompt, I get:

psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/tmp/.s.PGSQL.0"?

When I look into the /tmp directory for the domain socket, I see:

srwxrwxrwx  1 postgres postgres       0 Mar  9 17:44 .s.PGSQL.5432
-rw-------  1 postgres postgres      25 Mar  9 17:44 .s.PGSQL.5432.lock

Also, here is the relevant piece of my pg_hba.conf file:

local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         192.168.0.0/16        md5
host    all         all         172.16.0.0/16     password  # for a
VMWare instance

# IPv6 local connections:
host    all         all         ::1/128               trust

And, lastly, I use the following script as the postgres user to start
PostgreSQL from the command prompt, manually:

#!/bin/bash

ARGV=$1
PG_HOME=/var/lib/pgsql
PG_WORK_DIR=$PG_HOME/data

if [ "$1" = "start" ]
then
    pg_ctl -D $PG_WORK_DIR -l logfile start
elif [ "$1" = "stop" ]
then
    pg_ctl -D $PG_WORK_DIR stop
fi

Nothing, that I am aware of, has changed on this server that would
prevent the remote connection.  I have both SELinux and iptables
disabled (off by default) since this is inside a firewall on a home
network and is not available to the outside world.

Any idea why I am no longer able to connect?

Thanks for any and all help.

John


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: intermittant performance problem
Next
From: Tom Lane
Date:
Subject: Re: Connection Refused Error