Re: pgaccess problem.... - Mailing list pgsql-interfaces

From Bruno Wolff III
Subject Re: pgaccess problem....
Date
Msg-id 20030827123853.GC25066@wolff.to
Whole thread Raw
In response to pgaccess problem....  ("Alejandro Vargas M." <avargas@sgocostarica.com>)
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: "Alejandro Vargas M."
Date:
Subject: pgaccess problem....
Next
From: Christian Valverde
Date:
Subject: making my own libraries