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

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 (view raw or flat)
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

pgsql-novice by date

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

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