Starting Postgres with -i option

[Lamar Owen]

On Tuesday 24 February 2004 08:05 am, mike wrote:
> In FC2 how do you get the init scripts to start postgres with -i enabled

> I have tried editing postmaster.opts (int script overwrites it)
> Editing the startup line in /etc/rc.d/init.d/postgresql - postgres fails
> to start

Edit /var/lib/pgsql/data/postgresql.conf and change the line reading 
'tcpip_socket' to both uncomment it and set it to true.  This is a FAQ; see 
the README.rpm-dist in the documentation directory for postgresql (under 
/usr/share/doc).

Rationale: PostgreSQL is more secure with tcpip_socket listening off; the 
PostgreSQL developers long ago (6.3) selected that as the default.  It is 
easy enough to change with the GUC (postgresql.conf) file, since about 7.0.
-- 
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu