On Fri, 2004-07-23 at 13:58, [EMAIL PROTECTED] wrote: > I want to use pgadmin to set up some tables, rather than do all the > psql statements from the terminal. > > When I try to add a server, though, pgadmin fails to connect, and asks > whether the server is accepting TCP/IP connections on the default > port, and whether localhost is the correct servername. > > I assume that both of these ARE set to the defaults, because if I > simply type > > $ psql contacts > > I go right into psql, where I am allowed to make and alter tables.
In that case you are not using TCP/IP to localhost, but a Unix socket. Try "psql -h localhost contacts" to see the difference. Edit $PGDATA/pg_hba.conf to change the settings (and then signal the postmaster or restart it). -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "Be not deceived; God is not mocked; for whatsoever a man soweth, that shall he also reap." Galatians 6:7 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
