Can not connect remotely

On Fri, Apr 9, 2010 at 1:08 PM, arya6000 <arya6000@gmail.com> wrote:

Hello

I have spent hours trying to make this work, but its still not working. I
tried to connect using my Java program and using pgAdmin III. Postgre is
hosted on a Debian 5 64 bit vps and here are the changes I made.

I edited postgresql.conf
and changed

listen_addresses = 'local'

to

listen_addresses = '*'

After that I edited pg_hba.conf and added the following line at the end of
the file

host all all 0.0.0.0/0 md5

and I restarted postgresql by using

Quote:
/etc/init.d/postgresql-8.3 restart

but I always get the following error

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

Any idea how I can fix my problem?

Do you have a firewall running?

--Scott

On Fri, 9 Apr 2010 10:08:38 -0700 (PDT)
arya6000 <arya6000@gmail.com> wrote:

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

Are you sure that your firewall is allowing connections to port
5432/tcp?

Best regards

Rodrigo Gonzalez

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/