'-i option' with Runlevel script (RPM version)

On Tue, Oct 15, 2002 at 09:20:00AM +0200, Gabriele Bartolini wrote:

Hi guys,

I have read the archive, looking for posts which could help me solve
this case. It is not a problem, as long as I can make it work, but it is
a thing that ... I'd love to be solved in a more clean way.

I want to start up the postmaster process with the '-i' option, but
the runlevel script which comes with the RPM, doesn't include it. The
only way I could do to accomplish this, was to modify this script.

Yep, look in the postmaster.conf, I think it's called tcpip_socket = 1

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

On Tuesday 15 October 2002 03:20 am, Gabriele Bartolini wrote:

I have read the archive, looking for posts which could help me solve
this case. It is not a problem, as long as I can make it work, but it is
a thing that ... I'd love to be solved in a more clean way.

I want to start up the postmaster process with the '-i' option, but
the runlevel script which comes with the RPM, doesn't include it. The
only way I could do to accomplish this, was to modify this script.

Well, first, welcome to PostgreSQL. You will find that this is a really
industrial-strength database, with features that meet the needs of an
Internet-connected, or Intranet-connected, database server.

One of those features is the ability to be a totally local database server,
not accessible to the outside. As of PostgreSQL 6.3, the default behavior of
the postmaster was changed to not open a TCP/IP socket by default. This is,
in my opinion, a very good thing for security. Up until the 7.0 version of
the RPMset, I had the '-i' in the initscript in /etc/rc.d/init.d. At 7.1 I
decided to remove the -i for security reasons, as well as the fact that it
became very easy to enable TCP/IP socket listening in the file
/var/lib/pgsql/data/postgresql.conf.

Unfortunately many people became very confused by this, and the question 'Why
isn't -i the default' or 'How do I get the -i behavior' has been very
frequently asked since then.

So the topic is dealt with thoroughly in the README.rpm-dist documentation
file distributed with the postgresql RPM. To find this file, run the
following command:
rpm -ql postgresql | grep README
and it will show up in the listing. Then use less, or your favorite file
reader, to read this file.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Is the tcpip_socket option available to all versions? I had the same
problem Gabriele did and someone suggested adding the option to
postmaster.conf but it didnt work. I was already too frustrated at the
time to persue the matter further, I simply edited the script.

thanks

-b

It's definitely been there for awhile, I'd say maybe since the 7.0.x
versions. However, the option doesn't go in the postmaster.conf, it's in
the postgresql.conf

Robert Treat