From: Bruno Wolff III <bruno@wolff.to>
To: Alejandro Vargas M. <avargas@sgocostarica.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: pgaccess problem....
Date: Wed, 27 Aug 2003 07:38:53 -0500
Message-ID: <20030827123853.GC25066@wolff.to> (raw)
In-Reply-To: <1061930129.2171.14.camel@pdc.sgocostarica.priv>
References: <1061930129.2171.14.camel@pdc.sgocostarica.priv>
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.
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: bruno@wolff.to, avargas@sgocostarica.com
Subject: Re: pgaccess problem....
In-Reply-To: <20030827123853.GC25066@wolff.to>
* 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