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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
