Re: pgadmin problem

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