Connecting to PostgreSQL server

From: Daniel Weitzenfeld <dweitzenfeld(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Connecting to PostgreSQL server
Date: 2011-06-30 02:07:35
Message-ID: BANLkTi=dgRnpzYPF9h1mPA1uKDns-Dmi2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John Meredith 2011-06-30 07:32:04 Re: Connecting to PostgreSQL server
Previous Message Jean-Yves F. Barbier 2011-06-29 16:00:36 Re: Locking out a user after several failed login attempts