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(dot)Elphick(at)lfix(dot)co(dot)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