Your message dated Fri, 18 Nov 2005 00:07:58 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Bug#338492: postgresql: POSTGRES_DATA ignores POSTGRES_HOME in
postmaster.conf
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 10 Nov 2005 16:07:49 +0000
>From [EMAIL PROTECTED] Thu Nov 10 08:07:49 2005
Return-path: <[EMAIL PROTECTED]>
Received: from mta.sara.nl ([145.100.16.144])
by spohr.debian.org with esmtp (Exim 4.50)
id 1EaExp-0000P1-I5
for [EMAIL PROTECTED]; Thu, 10 Nov 2005 08:07:49 -0800
Received: from install.irc.sara.nl (ns.rc.sara.nl [145.100.29.211])
by mta.sara.nl (8.12.10+Sun/8.12.10) with ESMTP id jAAG7HNx023965
for <[EMAIL PROTECTED]>; Thu, 10 Nov 2005 17:07:17 +0100 (MET)
Received: from ganglia.irc.sara.nl (ganglia.irc.sara.nl [192.168.16.7])
by install.irc.sara.nl (Postfix) with ESMTP id 482ABA0062B
for <[EMAIL PROTECTED]>; Thu, 10 Nov 2005 17:07:17 +0100 (CET)
Received: by ganglia.irc.sara.nl (Postfix, from userid 10006)
id 3C5DFA0009F; Thu, 10 Nov 2005 17:07:17 +0100 (CET)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Ramon Bastiaans <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: postgresql: POSTGRES_DATA ignores POSTGRES_HOME in postmaster.conf
X-Mailer: reportbug 3.8
Date: Thu, 10 Nov 2005 17:07:17 +0100
Message-Id: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
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
---------------------------------------
Received: (at 338492-done) by bugs.debian.org; 17 Nov 2005 23:08:28 +0000
>From [EMAIL PROTECTED] Thu Nov 17 15:08:28 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de ([213.9.79.162])
by spohr.debian.org with esmtp (Exim 4.50)
id 1Ecsrk-0003s1-Ae
for [EMAIL PROTECTED]; Thu, 17 Nov 2005 15:08:28 -0800
Received: from localhost.localdomain (unknown [195.227.105.180])
(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
(Client CN "Martin Pitt (workstation)", Issuer "piware CA" (verified
OK))
by box79162.elkhouse.de (Postfix) with ESMTP id 8BBE719659A
for <[EMAIL PROTECTED]>; Fri, 18 Nov 2005 00:07:57 +0100 (CET)
Received: by localhost.localdomain (Postfix, from userid 1000)
id 6CE2BCDD0; Fri, 18 Nov 2005 00:07:58 +0100 (CET)
Date: Fri, 18 Nov 2005 00:07:58 +0100
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Bug#338492: postgresql: POSTGRES_DATA ignores POSTGRES_HOME in
postmaster.conf
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="qlTNgmc+xy1dBmNv"
Content-Disposition: inline
In-Reply-To: <[EMAIL PROTECTED]>
User-Agent: Mutt/1.5.11
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-9.4 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER,
HAS_PACKAGE,RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_SORBS,RCVD_IN_SORBS_WEB
autolearn=ham version=2.60-bugs.debian.org_2005_01_02
--qlTNgmc+xy1dBmNv
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Package: postgresql-common
Version: 1
Hi Ramon!
Ramon Bastiaans [2005-11-10 17:07 +0100]:
> 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.
This is more a design question and not a real bug. I agree that your
proposal is a bit more elegant, however, this will not be changed in
the stable Sarge release.
unstable and Etch have a completely different PostgreSQL architecture
now, where all these POSTGRES_* variables are entirely obsolete, so I
close the bug in testing/unstable.
Thanks,
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
In a world without walls and fences, who needs Windows and Gates?
--qlTNgmc+xy1dBmNv
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
iD8DBQFDfQ1ODecnbV4Fd/IRAraVAJ0XT8fC8hi/7XNMA9RUSjKGtEARjwCfbsVn
/EYaTRnnRR/f3wZ1mEJtICc=
=KPVq
-----END PGP SIGNATURE-----
--qlTNgmc+xy1dBmNv--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
