Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group