From: David Lloyd-Jones <david.lloyd-jones@attcanada.ca>
To: pgsql-interfaces@postgresql.org
To: Oliver Elphick <olly@lfix.co.uk>
Subject: Re: PSQL Working, but PGAccess Not Connecting.
Date: Mon, 31 Jul 2000 02:28:30 -0400
Message-ID: <002a01bffab9$4bcd6930$77647bd8@WORKGROUP> (raw)
References: <200007310553.e6V5r5A23948@linda.lfix.co.uk>
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
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: david.lloyd-jones@attcanada.ca, olly@lfix.co.uk
Subject: Re: PSQL Working, but PGAccess Not Connecting.
In-Reply-To: <002a01bffab9$4bcd6930$77647bd8@WORKGROUP>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox