Re: Can not connect remotely

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can not connect remotely
Date: 2010-04-09 21:03:19
Message-ID: 20100409210319.GT5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 09, 2010 at 10:08:38AM -0700, arya6000 wrote:
> Connection refused. Check that the hostname and port are correct and that
> the postmaster is accepting TCP/IP connections.

Running the following on your server:

netstat -tnl

will tell you if PG is actually listening on the port you expect. If
it's there as expected, then you need to look at your firewall/VPS
config to see whether the traffic is making its way through correctly.

--
Sam http://samason.me.uk/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2010-04-09 22:01:34 psql's \d display of unique index vs. constraint
Previous Message Greg Smith 2010-04-09 18:05:38 Re: Upcoming hot standby replication question