Re: 7.4.2 & DBVis

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
Thread:
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-----

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-05-17 17:34:15 Re: !!URGENT!! Should I keep INDEX on the table?
Previous Message Philippe VERSCHOOTEN 2004-05-17 11:01:24 INSTALLING POSTGRESQL 7.4.2