Hi,

I've upgraded to SuSE9.1 which installs PostgreSQL 7.4.2. I cannot seem
to connect to a local database using DBVisualizer, which worked fine
pre-7.4.2 (7.3.3 IIRC). I keep getting a variation of errors re
pg_hba.conf either missing or invalid; most recently

FATAL ERROR no pg_hba.conf entry for host "::1", user "username" ,
database "blahblah", SSL off

the entry is

host all username 127.0.0.1
255.255.255.255 trust

I'm using the jdbc drivers distributed on the SuSE cd's....

Any suggestions are appreciated...

Bob




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The ::1 suggests that you're trying to use IPv6 to connect. Try using an
explicit "127.0.0.1" in the connection parameters instead of "localhost"

Drew


Bob Jarman wrote:
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAqMHOgfzn5SevSpoRAtLgAJ9aUPDd7c1hWQxsLK+/ozhZbVPRBQCeIAgj
yL6baAQO6XdDd0l6Lv6QmgY=
=0T+A
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org