| Lists: | pgsql-jdbc |
|---|
| From: | Holger Klawitter <lists(at)klawitter(dot)de> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Name Lookup Weirdness |
| Date: | 2004-11-05 13:42:32 |
| Message-ID: | 200411051442.40153.lists@klawitter.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
-----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-----
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Holger Klawitter <lists(at)klawitter(dot)de> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Name Lookup Weirdness |
| Date: | 2004-11-05 15:56:25 |
| Message-ID: | 26522.1099670185@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Holger Klawitter <lists(at)klawitter(dot)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
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Holger Klawitter <lists(at)klawitter(dot)de> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Name Lookup Weirdness |
| Date: | 2004-11-05 20:30:26 |
| Message-ID: | Pine.BSO.4.56.0411051529280.28172@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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