Ran into similar symptoms, found that most utilities
(psql, for example) on the localhost use the Unix
Domain and work fine, but pgaccess uses TCP/IP.
My pg_hba.conf had a host statement to allow
TCP/IP, but postmaster did not have '-i' to enable
TCP/IP. I needed both to use pgaccess.
<webmaster To: pgsql-interfaces(at)postgresql(dot)org
Sent by: Subject: [INTERFACES] PGACCESS connection failure?
I love the look of the pgaccess gui BUT
upon trying to connect to my postgres server I get
Error trying to connect to database 'dbname' 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 prt 5432?
I am also running unix odbc and DataManager for unixodbc without any
trouble. I run SuSE Linux 8 Pro ... any help is appreciated.
Double T Computer Services
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
pgsql-interfaces by date
|Next:||From: Iavor Raytchev||Date: 2002-07-29 22:50:12|
|Subject: Re: PGACCESS connection failure?|
|Previous:||From: Cliff Wells||Date: 2002-07-29 22:23:30|
|Subject: ECPG and dynamic SQL|