From: William West <wwest@csc.com>
To: Preston Lord <webmaster@t2.net>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PGACCESS connection failure?
Date: Mon, 29 Jul 2002 18:38:32 -0400
Message-ID: <OF9F8F598E.C22F3290-ON85256C05.007BAB94@com> (raw)
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.
Preston Lord
<webmaster To: pgsql-interfaces@postgresql.org
@t2.net> cc:
Sent by: Subject: [INTERFACES] PGACCESS connection failure?
pgsql-interfa
ces-owner
07/29/2002
01:05 PM
Hi List!
I love the look of the pgaccess gui BUT
upon trying to connect to my postgres server I get
the error:
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.
--
Regards
Preston Lord
Programmer/Developer
Network Specialist
_______________
General Manager
Double T Computer Services
Sask, Canada
1.306.773.2054
http://www.t2.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: wwest@csc.com, webmaster@t2.net
Subject: Re: PGACCESS connection failure?
In-Reply-To: <OF9F8F598E.C22F3290-ON85256C05.007BAB94@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox