Received: from tor-smtp2.netcom.ca (tor-smtp2.netcom.ca [207.181.101.101]) by hub.org (8.10.1/8.10.1) with ESMTP id e6V6RMB65805 for ; Mon, 31 Jul 2000 02:27:23 -0400 (EDT) Received: from widgette (trt-on55-119.netcom.ca [216.123.100.119]) by tor-smtp2.netcom.ca (8.8.7-s-4/8.8.7) with SMTP id CAA29105; Mon, 31 Jul 2000 02:27:15 -0400 (EDT) Message-ID: <002a01bffab9$4bcd6930$77647bd8@WORKGROUP> From: "David Lloyd-Jones" To: , "Oliver Elphick" References: <200007310553.e6V5r5A23948@linda.lfix.co.uk> Subject: Re: PSQL Working, but PGAccess Not Connecting. Date: Mon, 31 Jul 2000 02:28:30 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200007/215 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" To: Sent: Monday, July 31, 2000 1:53 AM Subject: Re: [INTERFACES] PSQL Working, but PGAccess Not Connecting. > Tom Lane wrote: > >"David Lloyd-Jones" 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 > > >