Package: postgresql
Version: 7.4.7-6sarge1
Severity: minor
In postmaster.conf, the POSTGRES_HOME is determined by getting
the user postgres' homedir. One would assume when setting the correct
homedir for user postmaster, it will also use this for underlying
directorys. This is not the case for POSTGRES_DATA.
-- start copy/paste --
POSTGRES_HOME=`getent passwd postgres | awk -F: '{print $6}' | head -1`
if [ -z "$POSTGRES_HOME" ]
then
POSTGRES_HOME=/var/lib/postgres
fi
# Where to find the PostgreSQL database files, including those that
# define PostgresSQL users and permissions.
POSTGRES_DATA="/var/lib/postgres/data"
-- end copy/paste --
I would expect something here like:
POSTGRES_DATA="$POSTGRES_HOME/data"
This way you could upgrade postgres and if the config is overwritten or
something, the config still works. Now if you upgrade and overwrite the
config, it breaks.
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.13.2-sara1
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
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-22 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-8 Shared Perl library
ii libpq3 7.4.7-6sarge1 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-6sarge1 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: US
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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
