Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id AAA40925
	for <pgsql-interfaces@hub.org>; Mon, 2 Aug 1999 00:34:06 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id AAA29874;
	Mon, 2 Aug 1999 00:33:12 -0400 (EDT)
To: rodneyr@embratel.com.br
cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Opening database with PGACCESS 
In-reply-to: Your message of Sun, 1 Aug 1999 21:41:33 -0300
	<032567C1.0003CBDA.00@ntrjo008.nt.embratel.com.br>
Date: Mon, 02 Aug 1999 00:33:12 -0400
Message-ID: <29872.933568392@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

rodneyr@embratel.com.br writes:
> When I try to open my database (mydb) with the pgaccess, I receive the
> following message:
> "Error connecting database. Connection to database failed
> connectDB() failed: Is the postmaster running and accepting
> TCP/IP (with -i) connections at 'localhost' on port '5432'"

> The postmaster is running and I can connect to mydb using "psql":
>> psql mydb

psql defaults to connecting via Unix sockets.  If you make it connect
via TCP (by saying "psql -h localhost mydb") I'll bet it fails too.
Most likely, your pg_hba.conf is set up to allow Unix socket connections
but not TCP connections, not even from localhost.

			regards, tom lane