| Lists: | pgsql-novice |
|---|
| From: | Bob Jarman <rjarman(at)aug(dot)edu> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | 7.4.2 & DBVis |
| Date: | 2004-05-17 03:10:18 |
| Message-ID: | 40A82D1A.8010406@aug.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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
| From: | Andrew Hammond <ahammond(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Bob Jarman <rjarman(at)aug(dot)edu> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: 7.4.2 & DBVis |
| Date: | 2004-05-17 13:44:49 |
| Message-ID: | 40A8C1D1.6080300@ca.afilias.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
-----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-----