Re: pgaccess

On Wed, 2002-02-27 at 22:34, Eduardo Jos Hernndez Cisneros wrote:
> Hi, I am a new user of PostgreSQL and  a new user of RedHat Linux 7.2. I
> installed PostgreSQL 7.2 (http://people.redhat.com/teg/pg/) I would like to
> use "pgaccess" to manipulate my databases, but when I run:
>
> %pgaccess atpcdb
>
> I got this error:
>
> Error trying to connect to database 'atpcdb' on host localhost.
> PostgreSQL error message: Connection to database failed
> Could not connect to server: Connection refused
> Is the server running on host localhost and accepting TCP/IP connections on
> port 5432?
>
> I suppose that I need to add -i option to the database server (postmaster)

Not unless you _want_to enable TCP/IP access.  If you have nothing at
all in the host field in pgaccess' connect dialog, it will use Unix
sockets instead.  If you have "localhost" it uses TCP/IP on the loopback
interface.

> but in the scrip file: /etc/init.d/postgresql I do not know where to add it.
> Is it right? How can I resolve this?

Add

 tcpip_socket = yes

in postgresql.conf, or use "-o -i" as an option to pg_ctl (if that is
what is used in the init.d script).

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Give, and it will be given to you. A good measure,
      pressed down, taken together and running over,
      will be poured into your lap. For with the same
      measure that you use, it will be measured to
      you."         Luke 6:38