Starting Postgres with -i option
Lamar Owen
lowen at pari.edu
Tue Feb 24 13:24:01 UTC 2004
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
More information about the test
mailing list