Received: from amer-mta02.csc.com (amer-mta02.csc.com [20.137.2.248])
	by postgresql.org (Postfix) with ESMTP id 781CD475ACB
	for <pgsql-interfaces@postgresql.org>;
	Mon, 29 Jul 2002 18:41:19 -0400 (EDT)
Received: from amer-mta02.csc.com (localhost [127.0.0.1])
	by amer-mta02.csc.com (Switch-2.2.2/Switch-2.2.0) with ESMTP id
	g6TMh0R25366; Mon, 29 Jul 2002 18:43:00 -0400 (EDT)
Received: from csc.com (va-fch31.csc.com [20.6.39.231])
	by amer-mta02.csc.com (Switch-2.2.2/Switch-2.2.0) with ESMTP id
	g6TMgxR25318; Mon, 29 Jul 2002 18:42:59 -0400 (EDT)
Subject: Re: PGACCESS connection failure?
To: Preston Lord <webmaster@t2.net>
Cc: pgsql-interfaces@postgresql.org
X-Mailer: Lotus Notes Release 5.0.6a  January 17, 2001
Message-ID: <OF9F8F598E.C22F3290-ON85256C05.007BAB94@com>
From: "William West" <wwest@csc.com>
Date: Mon, 29 Jul 2002 18:38:32 -0400
X-MIMETrack: Serialize by Router on VA-FCH31/SRV/CSC(Release 5.0.8 |June 18,
	2001) at 07/29/2002 06:47:17 PM
MIME-Version: 1.0
Content-type: text/plain; charset=us-ascii
X-Archive-Number: 200207/134
X-Sequence-Number: 2943


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