Обсуждение: 7.4.2 & DBVis
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
-----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: | 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 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-----