Re: 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