Re: PSQL Working, but PGAccess Not Connecting.

Oliver:

Bingo!

Gratefully,

-dlj.

PS: More generally, I'd still like to know what to do with the script
"postgresql start" which is in subdirectory /etc/rc.d/init.d/ of RH 6.2.
There are lines that look somewhat like Mike Mascari's suggestions, but
nothing right on. Lamar Owen, are you out there somewhere?

-d.

----- Original Message -----
From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Monday, July 31, 2000 1:53 AM
Subject: Re: [INTERFACES] PSQL Working, but PGAccess Not Connecting.

> Tom Lane wrote:
> >"David Lloyd-Jones" <david(dot)lloyd-jones(at)attcanada(dot)ca> writes:
> >> than one can read them) but I don't see how this adds up: I'm not on
a
> >> network, and PSQL, which is a front end to PostgreSQL, just like
PGAccess
> >is
> >> supposed to be, is running fine.
> >
> >By default, psql connects via a Unix-socket path, not by TCP. PGAccess
> >is written differently and always tries to connect by TCP. If you try
> >to start psql with "-h localhost" or some such, it will try TCP and
> >fail in the same way ...
>
> If you leave blank the host field of pgaccess's connection dialog, it will
> use UNIX sockets instead of TCP/IP.
>
> --
> Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight http://www.lfix.co.uk/oliver
> PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
> ========================================
> "Have not I commanded thee? Be strong and of a good
> courage; be not afraid, neither be thou dismayed; for
> the LORD thy God is with thee whithersoever thou
> goest." Joshua 1:9
>
>
>