Re: Can't connect pgadmin III to postgreSQL db

["Adam L. Klein" <alklein integraonline com>]

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

Ian Pilcher wrote:

| I take it that you've used psql to do everything so far?  If so, you're
| probably connecting via a UNIX socket (the default), rather than a
| network socket.  To confirm that this is the problem, try the
| following:
|
|   psql -U postgres template1
|   [enter the password, if prompted]
|
| This should work.
|
|   psql -h localhost -U postgres template1
|   [enter the password, if prompted]
|
| If this fails, my suspicions are confirmed.  First, you need to edit
| /var/lib/pgsql/data/postgresql.conf and set "tcpip_socket = true".  You
| may also need to edit /var/lib/pgsql/data/pg_hba.conf, if you want to
| allow connections to any address other than 127.0.0.1.  (Doing this
| without turning on password-based authentication would probably be a
| bad idea.)
|
Ian,

You were right on!  Thanks so much.  Question - is there somewhere
obvious that I should have seen or been able to find this information?

Adam Klein
- --

Adam L. Klein
<alklein integraonline com>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAFJW2ddENTvuDvPsRAimmAJ4taT/4LoEUg7/82hHPLDDP892N0ACfSGOG
vr61EcP6BRF8nJdYB8Nh8PM=
=nIms
-----END PGP SIGNATURE-----