Postgres Pro
Downloads
Home   >   mailing lists

Thread: Name Lookup Weirdness

Name Lookup Weirdness

From
Holger Klawitter
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there,

I have made a very weird observation with JDBC. After a major machine upgrade
postgres 7.3.4 no longer accepts JDBC connection requests *of a certain
kind*:

jdbc:postgresql://my.host.name/dbname    works
jdbc:postgresql://127.0.0.1/dbname       works
jdbc:postgresql://localhost/dbname       does not work?!
jdbc:postgresql:dbname                   does not work

psql dbname                         works
psql -h localhost dbname            works

It seems to be independant of the JVM (tried 1.4.2 and 1.5.0) the postgres
binary (and config) itself did not change over the upgrade. Everything else
on that machine as been pretty much turned upside down. (Linux 2.2 -> Linux
2.6, et al ;-) I tried postgresql.jar of 7.3.2 and 7.3.4.

I know how to circumvent the problem (and I'll go 8.0 on that machine quite
soon as well), but I would like to know if anyone else has seen such a
thing...

Mit freundlichem Gruß / With kind regards
    Holger Klawitter
- --
lists <at> klawitter <dot> de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFBi4NP1Xdt0HKSwgYRAt7JAKCYaboztyYu6wWQZEwS+pRzmeWeQwCfaw8R
24FzFMy1uF3cZ+Rr/Ro4rnA=
=uPwa
-----END PGP SIGNATURE-----

Re: Name Lookup Weirdness

From
Tom Lane
Date:
Holger Klawitter <lists@klawitter.de> writes:
> I have made a very weird observation with JDBC. After a major machine upgrade
> postgres 7.3.4 no longer accepts JDBC connection requests *of a certain
> kind*:

> jdbc:postgresql://my.host.name/dbname    works
> jdbc:postgresql://127.0.0.1/dbname       works
> jdbc:postgresql://localhost/dbname       does not work?!
> jdbc:postgresql:dbname                   does not work

Something broken about your DNS configuration?  Although it's not
obvious why "psql -h localhost dbname" wouldn't be affected too...

            regards, tom lane

Re: Name Lookup Weirdness

From
Kris Jurka
Date:

On Fri, 5 Nov 2004, Holger Klawitter wrote:

> jdbc:postgresql://my.host.name/dbname    works
> jdbc:postgresql://127.0.0.1/dbname       works
> jdbc:postgresql://localhost/dbname       does not work?!
> jdbc:postgresql:dbname                   does not work

Possibly localhost resolves to an IPv6 address now?

> psql dbname                         works
> psql -h localhost dbname            works

Doesn't explain why this would work though.

Kris Jurka