Your message dated Mon, 13 Feb 2006 10:47:06 -0800
with message-id <[EMAIL PROTECTED]>
and subject line Bug#340166: fixed in postgresql 7.5.16
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)

--- Begin Message ---
Package: postgresql-7.4
Version: 1:7.4.8-17
Severity: normal

Hi, 

Some time ago, I "crossgraded" the Postgresql 7.4 installation to the
new postgresql-common and postgresql-7.4 packaging.

In the earlier postgresql instalations, one could define environment
variables in postgresql.env or postmaster.conf which then were exported
to the postmaster, and we could use it as LOCATION when creating new
databases in other locations.

I happen to have such legacy databases, and recently wanted to drop one
of them, and got the following error message:

dropdb: database removal failed: ERROR:  postmaster environment variable
"PGDATAEXTERN" not found

Not only that the environment variable setting was not migrated, I also
did not find the right place to reinstantiate this setting.

All the init scripts seem to be generic for the different postgresql
versions, and the postmaster itsself is a binary...

So I'm stuck with either dropping the whole cluster (and thus having to
migrate about 50 gig into a new cluster without stopping production
environment), or having an empty zombie-database lingering around which
confuses users.

Thanks,
Markus

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14.1
Locale: LANG=C, [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages postgresql-7.4 depends on:
ii  libc6                         2.3.5-6    GNU C Library: Shared libraries an
ii  libcomerr2                    1.38-2     common error description library
ii  libkrb53                      1.3.6-5    MIT Kerberos runtime libraries
ii  libpam0g                      0.79-3     Pluggable Authentication Modules l
ii  libpq3                        1:7.4.8-17 PostgreSQL C client library
ii  libreadline5                  5.0-11     GNU readline and history libraries
ii  libssl0.9.7                   0.9.7g-5   SSL shared libraries
ii  postgresql-client-7.4         1:7.4.8-17 front-end programs for PostgreSQL 
ii  postgresql-common             32         manager for PostgreSQL database cl
ii  zlib1g                        1:1.2.3-4  compression library - runtime

postgresql-7.4 recommends no packages.

-- no debconf information


--- End Message ---
--- Begin Message ---
Source: postgresql
Source-Version: 7.5.16

We believe that the bug you reported is fixed in the latest version of
postgresql, which is due to be installed in the Debian FTP archive:

postgresql-client_7.5.16_all.deb
  to pool/main/p/postgresql/postgresql-client_7.5.16_all.deb
postgresql-contrib_7.5.16_all.deb
  to pool/main/p/postgresql/postgresql-contrib_7.5.16_all.deb
postgresql-dev_7.5.16_all.deb
  to pool/main/p/postgresql/postgresql-dev_7.5.16_all.deb
postgresql-doc_7.5.16_all.deb
  to pool/main/p/postgresql/postgresql-doc_7.5.16_all.deb
postgresql_7.5.16.dsc
  to pool/main/p/postgresql/postgresql_7.5.16.dsc
postgresql_7.5.16.tar.gz
  to pool/main/p/postgresql/postgresql_7.5.16.tar.gz
postgresql_7.5.16_all.deb
  to pool/main/p/postgresql/postgresql_7.5.16_all.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Martin Pitt <[EMAIL PROTECTED]> (supplier of updated postgresql package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sat, 11 Feb 2006 13:17:35 +0100
Source: postgresql
Binary: postgresql-client postgresql-doc postgresql-dev postgresql 
postgresql-contrib
Architecture: source all
Version: 7.5.16
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description: 
 postgresql - object-relational SQL database management system (transitional)
 postgresql-client - front-end programs for PostgreSQL (transitional package)
 postgresql-contrib - additional facilities for PostgreSQL (transitional 
package)
 postgresql-dev - development files for libpq (transitional package)
 postgresql-doc - documentation for the PostgreSQL RDBMS (transitional package)
Closes: 340166
Changes: 
 postgresql (7.5.16) unstable; urgency=low
 .
   * Bump Standards-Version.
   * Start cluster after library path adaption in postgresql.conf, not before.
   * Migrate custom settings in postgresql.env and postmaster.conf to the new
     environment file. Closes: #340166
   * debian/control: Bump postgresql-common dependency to 40, which supports
     environment file handling.
   * test-psql-transition: Use set +e after the actual transition to be able to
     examine status even after failures.
   * Create a fake postgresql.conf in preinst and remove it in postinst again,
     now that psotgresql-common actually checks for the existance of it to
     decide whether to create a cluster.
Files: 
 a017dcdb7a232ffa6a8a405a4b42230c 575 misc optional postgresql_7.5.16.dsc
 b50a00071a14d50123180131e9c2414f 6443 misc optional postgresql_7.5.16.tar.gz
 c925c746511532fdbf4ddb815587e4f9 6252 misc optional postgresql_7.5.16_all.deb
 7040ed2b1fa34788a45d0bc22aa15861 3986 misc optional 
postgresql-client_7.5.16_all.deb
 8085e76de3b7af9c5cc0764e72efd1f2 3906 doc optional 
postgresql-doc_7.5.16_all.deb
 9201cbf716f987ece6de0279505b1eb6 3874 misc optional 
postgresql-contrib_7.5.16_all.deb
 816f69058a508f32c6f2ec01dfb0f33e 3824 libdevel optional 
postgresql-dev_7.5.16_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFD8NFEDecnbV4Fd/IRAokKAKDhf00lrhxu/W3kRyqfuM1BvlTuywCfZic3
zMh4UjGfPXigsdNcQny0W5A=
=vLcD
-----END PGP SIGNATURE-----


--- End Message ---

Reply via email to