From: Mike Mascari <mascarm@mascari.com>
To: David Lloyd-Jones <david.lloyd-jones@attcanada.ca>
Cc: Red Pineseed <yue207@home.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PSQL Working, but PGAccess Not Connecting.
Date: Mon, 31 Jul 2000 00:53:26 -0400
Message-ID: <39850646.77AF69E@mascari.com> (raw)
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>
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!
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: mascarm@mascari.com, david.lloyd-jones@attcanada.ca, yue207@home.com
Subject: Re: PSQL Working, but PGAccess Not Connecting.
In-Reply-To: <39850646.77AF69E@mascari.com>
* 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