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@lfix.co.uk>
To: <pgsql-interfaces@postgresql.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.lloyd-jones@attcanada.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.Elphick@lfix.co.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
>
>
>