dev-db/postgresql/files/pg_autovacuum.init-8.0.5


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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.5,v 1.1 2005/12/25 11:32:46 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
}