OpenPKG CVS Repository
http://cvs.openpkg.org/
____________________________________________________________________________
Server: cvs.openpkg.org Name: Ralf S. Engelschall
Root: /v/openpkg/cvs Email: [EMAIL PROTECTED]
Module: openpkg-src Date: 05-Sep-2007 21:47:42
Branch: HEAD Handle: 2007090520474100
Modified files:
openpkg-src/postgresql postgresql.spec
Log:
prepare pg_hba.conf already at the source; adjust postgresql.conf for
automatic VACUUM operations by default
Summary:
Revision Changes Path
1.241 +17 -14 openpkg-src/postgresql/postgresql.spec
____________________________________________________________________________
patch -p0 <<'@@ .'
Index: openpkg-src/postgresql/postgresql.spec
============================================================================
$ cvs diff -u -r1.240 -r1.241 postgresql.spec
--- openpkg-src/postgresql/postgresql.spec 14 May 2007 17:49:25 -0000
1.240
+++ openpkg-src/postgresql/postgresql.spec 5 Sep 2007 19:47:41 -0000
1.241
@@ -47,7 +47,7 @@
Group: Database
License: GPL
Version: %{V_postgresql}
-Release: 20070514
+Release: 20070905
# package options
%option with_server yes
@@ -535,6 +535,22 @@
) || exit $?
%endif
+ # adjust default configuration for hourly auto-vacuum operation
+ %{l_shtool} subst \
+ -e 's;^# *\(stats_start_collector *=\) *[^#]*\(#.*\);\1 on \2;' \
+ -e 's;^# *\(stats_row_level *=\) *[^#]*\(#.*\);\1 on \2;' \
+ -e 's;^# *\(autovacuum *=\) *[^#]*\(#.*\);\1 on \2;' \
+ -e 's;^# *\(autovacuum_naptime *=\) *[^#]*\(#.*\);\1 1h \2;' \
+ $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/postgresql.conf.sample
+
+ # adjust default configuration for local access policy
+ ( echo ""
+ echo "# OpenPKG PostgreSQL default access policy"
+ echo "local all all md5"
+ echo "host all all 127.0.0.1 255.255.255.255 md5"
+ echo ""
+ ) >>$RPM_BUILD_ROOT%{l_prefix}/share/postgresql/pg_hba.conf.sample
+
# post-adjust pgcluster configuration filenames
%if "%{with_pgcluster}" == "yes"
cp $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/pgreplicate.conf.sample \
@@ -650,19 +666,6 @@
$RPM_INSTALL_PREFIX/lib/openpkg/shtool prop \
-p "Creating initial PostgreSQL DB in
$RPM_INSTALL_PREFIX/var/postgresql/db"
- # adjust initial authentication configuration
- cp $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf \
- $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf.old
- ( cat $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf.old |\
- sed -e 's;^\([^#]\);# \1;' -e 's;^$;#;'
- echo ""
- echo "# OpenPKG PostgreSQL default access policy"
- echo "local all all md5"
- echo "host all all 127.0.0.1 255.255.255.255 md5"
- echo ""
- ) >$RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf
- rm -f $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf.old
-
# display information about next steps
( echo "An initial PostgreSQL DB was created with the two standard"
echo "databases 'template0' and 'template1'. The owner of both"
@@ .
______________________________________________________________________
OpenPKG http://openpkg.org
CVS Repository Commit List openpkg-cvs@openpkg.org
