| 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: | Whole Thread | Raw Message | 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.
| 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 |