| From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | Jonathan Schreiter <jonathanschreiter(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgresql jdbc connect via hostname instead of just ip |
| Date: | 2005-12-04 21:07:55 |
| Message-ID: | m2r78sa7v8.fsf@Douglas-McNaughts-Powerbook.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jonathan Schreiter <jonathanschreiter(at)yahoo(dot)com> writes:
> The only way I can connect to the database via JDBC
> seems to be by IP address (both locally and on another
> system allowed by the pg_hba.conf file).
>
> jdbc:postgresql://theipaddressofdatabaseserver/mydatabase
>
> I'd like to be able to connect to the database this
> way using a DNS name / computer host name. The
> specific error I recieve is on the lines of no route
> to host.
This implies that the IP address in DNS or /etc/hosts is different
from the IP address you're using in the URL. It's almost certainly
not a Postgres misconfiguration. What happens when you do
telnet server.host.name 5432
on the JDBC client machine?
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Havasvölgyi Ottó | 2005-12-05 00:37:44 | Creating then dropping primary key constraint |
| Previous Message | Jonathan Schreiter | 2005-12-04 18:34:30 | postgresql jdbc connect via hostname instead of just ip |