Date: Wed, 27 Aug 2003 07:38:53 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: "Alejandro Vargas M." <avargas@sgocostarica.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: pgaccess problem....
Message-ID: <20030827123853.GC25066@wolff.to>
Mail-Followup-To: "Alejandro Vargas M." <avargas@sgocostarica.com>,
	pgsql-interfaces@postgresql.org
References: <1061930129.2171.14.camel@pdc.sgocostarica.priv>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1061930129.2171.14.camel@pdc.sgocostarica.priv>
User-Agent: Mutt/1.5.4i

On Tue, Aug 26, 2003 at 16:35:31 -0400,
  "Alejandro Vargas M." <avargas@sgocostarica.com> wrote:
> I have problems with pgaccess.
> 
> I configured the postgresql.conf with tcpip_socket = true and port =
> 5432.
> 
> After that I configured pg_hba.conf
> 
> host all all 127.0.0.1 255.255.255.255 trust
> 
> I restart the postgresql service and started perfect.
> 
> I open the connection, then It opens very well at localhost, opens the
> database, but, when I try to see the tables, it's like their not exists.
> I don't know, what's wrong. I can see them at psql, but in pgaccess, I
> can't.

Are you running pgaccess from the local host?
Are you connecting to the loopback address (127.0.0.1) and not an external IP?

psql probably is conecting using domain sockets instead of using a network
connection, which could explain why it works and pgaccess doesn't.