Starting Postgres with -i option
mike
mike at bristolreccc.co.uk
Tue Feb 24 14:49:35 UTC 2004
On Tue, 2004-02-24 at 08:24 -0500, Lamar Owen wrote:
> 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.
> --
tried that as well
# This file is read on postmaster startup and when the postmaster
# receives a SIGHUP. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
# - Connection Settings -
tcpip_socket = true
max_connections = 100
# note: increasing max_connections costs about 500 bytes of
shared
# memory per connection slot, in addition to costs from
shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connections = 2
doesn't seem to be read
> Lamar Owen
> Director of Information Technology
> Pisgah Astronomical Research Institute
> 1 PARI Drive
> Rosman, NC 28772
> (828)862-5554
> www.pari.edu
>
>
>
> --
> fedora-test-list mailing list
> fedora-test-list at redhat.com
> To unsubscribe:
> http://www.redhat.com/mailman/listinfo/fedora-test-list
>
More information about the fedora-test-list
mailing list