I have been trying to set up my first database using
postgresql-7.3.4-11 on Red Hat Fedora Core 1 Linux.
I setup database and I can access it from prompt
I downloaded and installed pgaccess-0_99_0_20040219.tgz
to make my life easier, but when I try to access
database I get the following message

Error trying to connect to database 'RabStudies' on local host.
PostgreSQL error message: Connection to database failed could not
connect to server: Connectionrefused Is the server running on host
localhost and accepting TCP/IP connections on port 5432?

I don't have any clue what is wrong and how to fix it, so any
suggestions will be appreciated.

Michal

On Fri, 02 Apr 2004 08:59:52 -0800, Michal wrote:

You need to make changes to the pg_hba.conf configuration file to allow
local and/or host access.

I am a Mandrake 9.2 user and for the Mandrake package the
configuration file is located at /var/lib/pgsql/data. I uncommented out
the local and host type access using the default settings (you may wish
to customize them). If you want remote access, you'll have to enable the
tcpip_socket setting in the postgresql.conf file.

I have to say that none of the gui front-ends available for PostgreSQL
have been satisfactory.