Can not connect remotely

From: arya6000 <arya6000(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can not connect remotely
Date: 2010-04-09 17:08:38
Message-ID: 28195027.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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?

Best Regards!
--
View this message in context: http://old.nabble.com/Can-not-connect-remotely-tp28195027p28195027.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2010-04-09 17:18:10 Re: Can not connect remotely
Previous Message Ivan Voras 2010-04-09 16:41:37 Re: Upcoming hot standby replication question