pgaccess - client wont access testdb - Mailing list pgsql-interfaces

From Eric Webber
Subject pgaccess - client wont access testdb
Date
Msg-id 200201281407.JAA13979@www20.ureach.com
Whole thread Raw
Responses Re: pgaccess - client wont access testdb  (Oliver Elphick <olly@lfix.co.uk>)
Re: pgaccess - client wont access testdb  ("Jules Alberts" <julesa@arbodienst-limburg.nl>)
List pgsql-interfaces
Just finished an install of postres7.1.3 on redhat, compiled
in tcl access etc.

created testdb from command line as user postgres
was able to access testdb with psql command line as postgres user

pgaccess X client comes up fine but when I try to open a database
I get the error:

"Error trying to connect to database 'testdb' on host localhost

PostgreSQL error message: Connection to database failed

connectDBStart() - connect() failed: Connection refused
IS the postmaster running (with -i) at 'localhost'
and accepting connections on TCP/IP port 5432?"


Why would I get this when psql works fine ?

What am I doing wrong ?  How would I check what port it is running 
on and whether is running with -i and at localhost ?

Isnt the fact psql works proof enough that pgacess should work
too in terms of connectivity ?

For username I give pgaccess the user name postgres and
no password.

regards,

Eric Sean Webber

________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag


pgsql-interfaces by date:

Previous
From: Andreas Kretzer
Date:
Subject: Re: Slow Connection
Next
From: Oliver Elphick
Date:
Subject: Re: pgaccess - client wont access testdb