[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Starting Postgres with -i option



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 redhat com
> To unsubscribe: 
> http://www.redhat.com/mailman/listinfo/fedora-test-list
> 




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]