Re: pgadmin problem
От | Oliver Elphick |
---|---|
Тема | Re: pgadmin problem |
Дата | |
Msg-id | 1090666428.13866.8.camel@linda обсуждение исходный текст |
Ответ на | pgadmin problem (mmd@teledavis.com) |
Список | pgsql-general |
On Fri, 2004-07-23 at 13:58, mmd@teledavis.com 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 olly@lfix.co.uk 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
В списке pgsql-general по дате отправления: