Re: [INTERFACES] Pgaccess - Error trying to connect

"Don Oliver" <dayo_nanaimo@hotmail.com> writes:
> PostgreSQL is always on, and works fine from the command line. (A console in 
> X.)

If you mean that "psql" works, that's good, but by default psql tries to
connect via a Unix socket file, not via TCP/IP.  So TCP connection
problems won't necessarily show up.  If you use the -h option then psql
tries to use a TCP connection, which is what pgaccess always tries.
I'll bet if you do "psql -h localhost" you see the same failure as in
pgaccess.

> If I try to start pgaccess with: "pgaccess don", the main PgAccess window 
> comes up,
> (empty) but there is an error message box in front of it. The message is:

>      "Error trying to connect to database "don" on host localhost.
>       PostgreSQL error message: Connection to database failed:
>       Network is unreachable. is the postmaster running (with -i) at
>       'localhost' and accepting connections on TCP/IP port '5432'?"

The critical part of that message is the "Network is unreachable" part,
which is the kernel error message that pgaccess is getting when it tries
to connect.  That's a pretty darn bizarre error code to get for an
attempt to contact 'localhost'.  I think there's something screwy in
the networking configuration of your machine.  Dunno what exactly;
but it likely doesn't have anything directly to do with Postgres.
If you do, say, "telnet localhost 23", do you get a telnet login prompt
or an error?
        regards, tom lane