From: Lamar Owen <lamar.owen@wgcr.org>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: David Lloyd-Jones <david.lloyd-jones@attcanada.ca>
Cc: pgsql-interfaces@postgresql.org, Oliver Elphick <olly@lfix.co.uk>
Subject: Re: PSQL Working, but PGAccess Not Connecting.
Date: Mon, 31 Jul 2000 14:54:44 -0400
Message-ID: <3985CB73.F8716221@wgcr.org> (raw)
References: <200007310553.e6V5r5A23948@linda.lfix.co.uk>
<002a01bffab9$4bcd6930$77647bd8@WORKGROUP>
<3985941D.DBD94A92@alumni.caltech.edu>
<004d01bffb0c$203162b0$6d6b7bd8@WORKGROUP>
<3985AA0F.337454B0@alumni.caltech.edu>
Thomas Lockhart wrote:
> > Do I want to add a "-i" somewhere inside it?
> Sure, if it isn't there already. I haven't looked at the script
> recently, but I recall that the predecessor had some commented-out lines
> to illustrate where this kind of thing should occur.
> Perhaps the "-i" is disabled by default to enhance out-of-the-box
> network security?
[I'm going to reply to this one rather than all the previous ones.
Sorry for the delay in responding, but I just got back from a 'working'
vacation, and had alot of front-burner items to handle before I could
get on my notebook. And, last night I was going to get online, but a
thunderstorm outbreak prevented me....]
David, if you're running 6.5.3 that came with RH 6.2, there should
already be a '-i' on the postmaster startup line in
/etc/rc.d/init.d/postgresql. If, however, you're running 7.0.2, the
whole startup has changed. Look in
/var/lib/pgsql/data/postmaster.opts.default (IIRC) for a '-i' -- the
7.0.2 RPM's start postmaster through pgctl.
If you not running 7.0.2, you really should investigate upgrading.
AOLserver's performance takes a leap against 7 versus 6.5, for some
reason that I've not been able to fathom.
As to the network unreachable errors, you have a network configuration
problem somewhere that is causing your machine to not work with TCP/IP,
for some reason.
The default startup in the RPM's has been, since 6.5.2 or so, to enable
the -i -- and the reason -i wasn't enabled before wasn't so much
security as it was the fact the no one bothered to add -i to the startup
file after PostgreSQL 6.3 changed the default to require -i for TCP/IP
connections.
Also, if you have Apache installed, AOLserver will have serious trouble
binding port 80 (even if Apache is not running).
HTH
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
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: lamar.owen@wgcr.org, lockhart@alumni.caltech.edu, david.lloyd-jones@attcanada.ca, olly@lfix.co.uk
Subject: Re: PSQL Working, but PGAccess Not Connecting.
In-Reply-To: <3985CB73.F8716221@wgcr.org>
* 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