Connecting to PostgreSQL server - Mailing list pgsql-novice

From Daniel Weitzenfeld
Subject Connecting to PostgreSQL server
Date
Msg-id BANLkTi=dgRnpzYPF9h1mPA1uKDns-Dmi2A@mail.gmail.com
Whole thread Raw
Responses Re: Connecting to PostgreSQL server  (John Meredith <meredijo@gmail.com>)
Re: Connecting to PostgreSQL server  (Michael Wood <esiotrot@gmail.com>)
List pgsql-novice
Hi,
I have a remote server with PostgreSQL on it.
When I try to connect via python/pygresql, I get:

pg.InternalError: could not connect to server: Connection refused
    Is the server running on host "##.##.##.###" and accepting
    TCP/IP connections on port 5432?
 
Where I've blanked out my server's ip address for obvious reasons.

I ssh'd to my server and did this to iptables:

iptables -A INPUT -p tcp --dport 5432 -j ACCEPT

restarted iptables, but still no dice.

Any advice?

Thanks in advance!
-Daniel

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: Locking out a user after several failed login attempts
Next
From: John Meredith
Date:
Subject: Re: Connecting to PostgreSQL server