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