Message-ID: <39850646.77AF69E@mascari.com>
Date: Mon, 31 Jul 2000 00:53:26 -0400
From: Mike Mascari <mascarm@mascari.com>
Organization: Mascari Development Inc
MIME-Version: 1.0
To: David Lloyd-Jones <david.lloyd-jones@attcanada.ca>
CC: Red Pineseed <yue207@home.com>, pgsql-interfaces@postgresql.org
Subject: Re: PSQL Working, but PGAccess Not Connecting.
References: <200007301621.SAA02908@beertje.william.bogus>
	<000601bffa64$a38bb960$46647bd8@WORKGROUP>
	<1655.964993215@sss.pgh.pa.us>
	<000701bffa74$88159790$406c7bd8@WORKGROUP>
	<7628.964996485@sss.pgh.pa.us> <3984DC50.BF5B2D2D@home.com>
	<004801bffaa6$3ff63b40$34627bd8@WORKGROUP>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

David Lloyd-Jones wrote:
> 
> I did try the loopback, as I mentioned in a note to Tom (perhaps off-line,
> sorry.)
> Agreed, his explanation makes sense, and I'm looking for the right place to
> put the -i.
> 
> Anybody know the innards of that /etc/rc.d/init.d/postgresql start
> batchfile?

The older RPMS started the postmaster without the -i for security
reasons. However, the newer ones do start it up with TCP/IP
support enabled by default. Which rpms are you using? You should
look for a line like:

su -l postgres -c '/usr/bin/postmaster -o -F -i -S
-D/var/lib/pgsql'

The -o -F flag combination turns off fsync. The -i switch will
enable the TCP/IP connection. -S says to start up in silent mode.
-D specifies the location of the where the data/base hierarchy is
stored. If I recall the older RPMS correctly, they will have a
line like:

su -l postgres -c '/usr/bin/postmaster -S -D/var/lib/pgsql'

So all you'll have to do is change it as it appears above with
the -i switch (and I also recommend the -o -F pair as well). 

Hope that helps,

Mike Mascari

P.S.: If you are using the older RPMS with an older version of
PostgreSQL (6.x), I highly recommend upgrading. Major bugs fixes
and enhancements were made between the 6.x series and 7.x.

Good Luck!