-----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@xxxxxxxxxxxxxxxxx>
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFAFJW2ddENTvuDvPsRAimmAJ4taT/4LoEUg7/82hHPLDDP892N0ACfSGOG vr61EcP6BRF8nJdYB8Nh8PM= =nIms -----END PGP SIGNATURE-----
