Package: postgresql Version: 7.4.7-6sarge2 Severity: normal Tags: patch
If you have PostgreSQL installed, but not started in any runlevel, then the do.maintenance script will always bail out, even if the server is in fact running (eg because it has been started manually). (Such a configuration might be used, for example, if you have to manually mount an encrypted /var/lib/postgres/data partition before the server can be started.) This results in VACUUM and ANALYZE not being run, causing gradual performance degradation and eventually could cause a transaction ID rollover. Given that do.maintenance already checks in /var/run/postgresql to ensure that the server is actually running, is there a need to perform an additional runlevel check? -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.11.10-p4-4g Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages postgresql depends on: ii adduser 3.63 Add and remove users and groups ii debconf [debconf 1.4.30.13 Debian configuration management sy ii debianutils 2.8.4 Miscellaneous utilities specific t ii dpkg 1.10.28 Package maintenance system for Deb ii libc6 2.3.2.ds1-22sarge3 GNU C Library: Shared libraries an ii libcomerr2 1.37-2sarge1 common error description library ii libkrb53 1.3.6-2sarge2 MIT Kerberos runtime libraries ii libpam0g 0.76-22 Pluggable Authentication Modules l ii libperl5.8 5.8.4-8sarge4 Shared Perl library ii libpq3 7.4.7-6sarge2 PostgreSQL C client library ii libreadline4 4.3-11 GNU readline and history libraries ii libssl0.9.7 0.9.7e-3sarge1 SSL shared libraries ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent ii postgresql-clien 7.4.7-6sarge2 front-end programs for PostgreSQL ii procps 1:3.2.1-2 The /proc file system utilities ii python2.3 2.3.5-3sarge1 An interactive high-level object-o ii ucf 1.17 Update Configuration File: preserv ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime -- debconf information: * postgresql/initdb/location: /var/lib/postgres/data postgresql/upgrade/preserve_location: $PGDATA/.. * postgresql/settings/day_month_order: European postgresql/upgrade/policy: true * postgresql/settings/locale: C postgresql/enable_lang: true * postgresql/purge_data_too: false postgresql/very_old_version_warning: true postgresql/upgrade/dump_location: $PGDATA/.. postgresql/convert-pg_hba.conf: true
--- do.maintenance.old 2006-06-19 11:29:28.000000000 +0100 +++ do.maintenance 2006-06-19 11:31:47.000000000 +0100 @@ -53,14 +53,6 @@ . /etc/postgresql/postgresql.env -/usr/sbin/invoke-rc.d --query postgresql start -if [ $? -ne 104 ] -then - [ -n "$verbose" ] && - echo "PostgreSQL is currently disabled by update-rc.d or file-rc" - exit 1 -fi - if [ ! -S /var/run/postgresql/.s.PGSQL.5432 ] then [ -n "$verbose" ] &&