Re: pgaccess & Postgresql

[Ramin Motakef <ramin@motakef.de>]

Sebastian Canagaratna <scanagar@canax2.onu.edu> writes:

> Hi:
>    I am having problems with pgaccess and Postgresql. I am 
>    using potato. I can run with psql but when I type pgaccess
>    the window appears I fill in my name, database, password
>    etc I get the message connectDB() - connect failed. connection
>    refused. Is the postmaster running ( with -i ) at localhost and
>    accepting connection on TCPIP port 5432. I am running this locally
>    and according to the init files all users on local host should
>    be accepted. In fact the postmaster is not supposed to accept
>    any conections over the TCPIP. WHat is the problem?
> 
> Thanks.
> 
> Sebastian Canagaratna

pgaccess needs to be able to talk to the postmaster over tcp/ip.
enable it in /etc/postgresql/postmaster.init (PGALLOWTCPIP=yes).
Check /etc/postgresql/pg_hba.conf for restricting connections.

HTH, Ramin