Обсуждение: Can not connect remotely
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.
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
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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/