Adam L. Klein wrote:
I've just installed pgadmin3 from http://www.pgadmin.org/. I'm
running postgreSQL on FC-1 with all the latest updates. I have
created a few small tables (as the postgres user). I can query, add,
delete, etc. records... but when I start pgadmin3, I get an error:
~ An error has occurred:
Error connecting to the server: could not connect to server:
Connection refused
~ Is the server running on host "192.168.0.3" and accepting
~ TCP/IP connections on port 5432?
(I've also tried localhost, 127.0.0.1 and the hostname I've assigned
to the local machine). No matter what, I get this error (with the
hostname different). I haven't done any config on postgreSQL and the
default config file specifies port 5432. Any ideas? I'd appreciate
any insight as a frontend would make learning postgreSQL a bit easier.
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 Pilcher i.pilcher@xxxxxxxxxxx
========================================================================
