summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMasatomo Nakano <nakano@gentoo.org>2004-12-22 17:00:06 +0000
committerMasatomo Nakano <nakano@gentoo.org>2004-12-22 17:00:06 +0000
commitcee2aa5136509eee2f7774e301298005714b4773 (patch)
treea3a06e39846cfcbf47f17631b7366dbffa5b75f3 /dev-db/postgresql/files
parentVersion bump; now depends on dev-libs/boost. (Manifest recommit) (diff)
downloadgentoo-2-cee2aa5136509eee2f7774e301298005714b4773.tar.gz
gentoo-2-cee2aa5136509eee2f7774e301298005714b4773.tar.bz2
gentoo-2-cee2aa5136509eee2f7774e301298005714b4773.zip
*** empty log message ***
Diffstat (limited to 'dev-db/postgresql/files')
-rw-r--r--dev-db/postgresql/files/digest-postgresql-8.0.0_rc23
-rw-r--r--dev-db/postgresql/files/pg_autovacuum.conf-8.0.0_rc214
-rw-r--r--dev-db/postgresql/files/pg_autovacuum.init-8.0.0_rc251
-rw-r--r--dev-db/postgresql/files/postgresql-8.0.0_rc2-gentoo.patch18
4 files changed, 86 insertions, 0 deletions
diff --git a/dev-db/postgresql/files/digest-postgresql-8.0.0_rc2 b/dev-db/postgresql/files/digest-postgresql-8.0.0_rc2
new file mode 100644
index 000000000000..2d4518acff94
--- /dev/null
+++ b/dev-db/postgresql/files/digest-postgresql-8.0.0_rc2
@@ -0,0 +1,3 @@
+MD5 beb5502f56295e2e91c992e3b499238e postgresql-base-8.0.0rc2.tar.bz2 7717596
+MD5 89b966fbd4be0e488ff965a26e590f31 postgresql-opt-8.0.0rc2.tar.bz2 133108
+MD5 8f3cc5225a2c19978060af7a10d08841 postgresql-docs-8.0.0rc2.tar.bz2 2162692
diff --git a/dev-db/postgresql/files/pg_autovacuum.conf-8.0.0_rc2 b/dev-db/postgresql/files/pg_autovacuum.conf-8.0.0_rc2
new file mode 100644
index 000000000000..f342ebfd2a47
--- /dev/null
+++ b/dev-db/postgresql/files/pg_autovacuum.conf-8.0.0_rc2
@@ -0,0 +1,14 @@
+# The PostgreSQL user is:
+PGUSER=postgres
+
+# LOG file is:
+PG_AUTOVACUUM_LOG=/var/lib/postgresql/data/pg_autovacuum.log
+
+# See the pg_autovacuum documentation for the details of how these
+# parameters affect pg_autovacuum's aggressiveness.
+
+VACUUM_BASE=1000
+VACUUM_SCALE=2
+
+SLEEP_BASE=300
+SLEEP_SCALE=2
diff --git a/dev-db/postgresql/files/pg_autovacuum.init-8.0.0_rc2 b/dev-db/postgresql/files/pg_autovacuum.init-8.0.0_rc2
new file mode 100644
index 000000000000..24d6ed7e1789
--- /dev/null
+++ b/dev-db/postgresql/files/pg_autovacuum.init-8.0.0_rc2
@@ -0,0 +1,51 @@
+#!/sbin/runscript
+# Copyright 1999-2004 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/files/pg_autovacuum.init-8.0.0_rc2,v 1.1 2004/12/22 17:00:06 nakano Exp $
+
+depend() {
+ need postgresql logger
+}
+
+start() {
+ ebegin "Starting pg_autovacuum"
+ echo ""
+ echo -n "Waiting max. 10 sec. for postgresql to start "
+ CONTINUE=0
+ TOO_LONG=0
+ while [ "$CONTINUE" -eq 0 ] && [ $TOO_LONG -lt 10 ]
+ do
+ psql -U $PGUSER -d template1 -c "SELECT 1" 1> /dev/null 2> /dev/null
+ if [ "$?" -eq 0 ]
+ then
+ CONTINUE=1
+ else
+ echo -n "."
+ TOO_LONG=`expr $TOO_LONG + 1`
+ sleep 1
+ fi
+ done
+ start-stop-daemon -o --chuid $PGUSER --start --quiet --exec /usr/bin/pg_autovacuum -- -D -v $VACUUM_BASE -V $VACUUM_SCALE -s $SLEEP_BASE -S $SLEEP_SCALE -L $PG_AUTOVACUUM_LOG
+
+ sleep 1
+ pidof /usr/bin/pg_autovacuum > /dev/null
+ if [ $? -eq 0 ]; then
+ eend 0
+ else
+ eerror ""
+ eerror "Please see log file: $PG_AUTOVACUUM_LOG"
+ eerror "You may need to add following lines in /var/lib/postgresql/data/postgresql.conf and restart PostgreSQL."
+ eerror " stats_start_collector = true"
+ eerror " stats_row_level = true"
+
+ eerror "Please read ___DOCDIR___/contrib/README.pg_autovacuum for details."
+ eend 1
+ fi
+}
+
+stop() {
+ ebegin "Stopping pg_autovacuum"
+ start-stop-daemon --stop --quiet --exec /usr/bin/pg_autovacuum
+ result=$?
+ eend $result
+}
diff --git a/dev-db/postgresql/files/postgresql-8.0.0_rc2-gentoo.patch b/dev-db/postgresql/files/postgresql-8.0.0_rc2-gentoo.patch
new file mode 100644
index 000000000000..7a400380ff89
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-8.0.0_rc2-gentoo.patch
@@ -0,0 +1,18 @@
+diff -Naru postgresql-8.0.0rc2.org/src/bin/initdb/initdb.c postgresql-8.0.0rc2/src/bin/initdb/initdb.c
+--- postgresql-8.0.0rc2.org/src/bin/initdb/initdb.c 2004-11-29 03:05:03.000000000 +0000
++++ postgresql-8.0.0rc2/src/bin/initdb/initdb.c 2004-12-04 18:02:43.757485824 +0000
+@@ -2617,13 +2617,7 @@
+ get_parent_directory(bin_dir);
+
+ printf(_("\nSuccess. You can now start the database server using:\n\n"
+- " %s%s%s%spostmaster -D %s%s%s\n"
+- "or\n"
+- " %s%s%s%spg_ctl -D %s%s%s -l logfile start\n\n"),
+- QUOTE_PATH, bin_dir, QUOTE_PATH, (strlen(bin_dir) > 0) ? DIR_SEP : "",
+- QUOTE_PATH, pg_data_native, QUOTE_PATH,
+- QUOTE_PATH, bin_dir, QUOTE_PATH, (strlen(bin_dir) > 0) ? DIR_SEP : "",
+- QUOTE_PATH, pg_data_native, QUOTE_PATH);
++ "/etc/init.d/postgresql start\n\n"));
+
+ return 0;
+ }