Thanks for the help - it was a dns resolving issue after all as you described. Jonathan --- Douglas McNaught <doug@xxxxxxxxxxxx> wrote: > Jonathan Schreiter <jonathanschreiter@xxxxxxxxx> > 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 >
