Your message dated Fri, 21 Sep 2012 19:47:04 +0000
with message-id <e1tf9bo-0004w0...@franck.debian.org>
and subject line Bug#686060: fixed in postgresql-common 113+squeeze1
has caused the Debian Bug report #686060,
regarding postgresql-common: Critical data-loss bug in pg_wrapper init scripts
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 this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
686060: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=686060
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: postgresql-common
Version: 114
Severity: critical
Justification: causes serious data loss
The Debian packages for PostgreSQL are subject to a potentially critical data
loss
bug because of an unsafe procedure for restarting PostgreSQL.
It is VITAL that pg_wrapper NEVER unlink the postmaster.pid file. The postmaster
will do that its self if it finds the pid to be stale, but only after performing
some checks to make sure there are no backends still running and to ensure that
there's no other postmaster running against the database.
This is a critical data loss bug and should be back patched to older versions.
I quote Tom Lane (key PostgreSQL dev):
[The] forced unlink on the postmaster.pid file [...] (a) is entirely
unnecessary, and (b) defeats the safety interlock against starting a
new postmaster before all the old backends have flushed out.
See:
http://archives.postgresql.org/pgsql-general/2012-07/msg00475.php
and the context:
http://archives.postgresql.org/pgsql-general/2012-07/msg00350.php
http://dba.stackexchange.com/questions/20959/recover-postgresql-database-from-wal-errors-on-startup/20961#comment34356_20961
-- System Information:
Debian Release: squeeze/sid
APT prefers natty-updates
APT policy: (500, 'natty-updates'), (500, 'natty-security'), (500, 'natty')
Architecture: i386 (i686)
Kernel: Linux 2.6.38-13-generic (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages postgresql-common depends on:
ii adduser 3.112+nmu1ubuntu5 add and remove users and groups
ii debconf [debconf-2.0] 1.5.36ubuntu4 Debian configuration management sy
ii lsb-base 4.0-0ubuntu11 Linux Standard Base 4.0 init scrip
ii postgresql-client-comm 114 manager for multiple PostgreSQL cl
ii procps 1:3.2.8-10ubuntu3 /proc file system utilities
ii ssl-cert 1.0.28 simple debconf wrapper for OpenSSL
postgresql-common recommends no packages.
postgresql-common suggests no packages.
-- debconf information:
postgresql-common/obsolete-major:
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 113+squeeze1
We believe that the bug you reported is fixed in the latest version of
postgresql-common, which is due to be installed in the Debian FTP archive.
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 686...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <m...@debian.org> (supplier of updated postgresql-common 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 ftpmas...@debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Fri, 21 Sep 2012 17:13:33 +0200
Source: postgresql-common
Binary: postgresql-common postgresql-client-common postgresql-server-dev-all
Architecture: source all
Version: 113+squeeze1
Distribution: stable
Urgency: high
Maintainer: Debian PostgreSQL Maintainers
<pkg-postgresql-pub...@lists.alioth.debian.org>
Changed-By: Christoph Berg <m...@debian.org>
Description:
postgresql-client-common - manager for multiple PostgreSQL client versions
postgresql-common - PostgreSQL database-cluster manager
postgresql-server-dev-all - extension build tool for multiple PostgreSQL
versions
Closes: 686060
Changes:
postgresql-common (113+squeeze1) stable; urgency=high
.
[ Martin Pitt ]
* pg_ctlcluster: Do not remove the PID file after SIGKILLing the
postmaster in the "last-ditch effort to shut down" in --force mode. This
is a potentially dangerous thing to do when trying to start a second
postmaster in parallel while the first one is still being shut down.
(see http://archives.postgresql.org/pgsql-general/2012-07/msg00475.php)
Cherry-picked from version 133 (bzr r1181). (Closes: #686060)
.
[ Christoph Berg ]
* Update Vcs URLs and Maintainer fields for group maintenance.
Checksums-Sha1:
fd0ff1b1b6eeb9046b715c1d82b53ddba588f7d7 1808
postgresql-common_113+squeeze1.dsc
503cf4b9f8c523f398edf9600575dc01bf4f6606 128196
postgresql-common_113+squeeze1.tar.gz
160d3da22f105a5f4099163198746de75f507862 126462
postgresql-common_113+squeeze1_all.deb
97e6e8901fea67969839a2dc6e9d3d382063de5a 55216
postgresql-client-common_113+squeeze1_all.deb
5607855fe83742be18226a7efb8d756d8a6474d5 40780
postgresql-server-dev-all_113+squeeze1_all.deb
Checksums-Sha256:
a95f1a19330852eb175d7845470fc7b98ac446d377284e2680c34055f3071fa7 1808
postgresql-common_113+squeeze1.dsc
5e5a7337cd63d8c93c5e01c4864d2498a514309ca537b1e0d5c2b37a9f80ec89 128196
postgresql-common_113+squeeze1.tar.gz
33a642720b7578f11cc52ff15702fbe5d54de5a2619d162858a8e15061c0678a 126462
postgresql-common_113+squeeze1_all.deb
37976390a364b85aa06f2fa42ce8c5578e8b594715cbeaf7fe1c9fc60fb1d5f6 55216
postgresql-client-common_113+squeeze1_all.deb
27980fd7f0eabf0bb9e2d54f303620d49c3466cafc5f8bf03625c089d1e30969 40780
postgresql-server-dev-all_113+squeeze1_all.deb
Files:
e802cca32d486abcd541f6c41593294e 1808 database optional
postgresql-common_113+squeeze1.dsc
b05e15c86360f93f4052bef2a4be081e 128196 database optional
postgresql-common_113+squeeze1.tar.gz
93a225c5baf658225445d83450e2a25b 126462 database optional
postgresql-common_113+squeeze1_all.deb
0ab3258a60a0370a8f8df7537d38e845 55216 database optional
postgresql-client-common_113+squeeze1_all.deb
0b0505a2810b1e179058813986cba705 40780 database optional
postgresql-server-dev-all_113+squeeze1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBCAAGBQJQXIW+AAoJEExaa6sS0qeu8KgP/iH0Ysd0H7VKubxC8wPk4E5f
tSD+zw78PydfjhyV8R4pXL51OaaZrjoQQR08vRQVpY4VD6LwuyLyQbMSZQlLricI
VcDp25Nd66HDbEIb5jlLFUonbeVGo1tfYE+kduXeRDADEi6jhaHxSAqnwIbCG0ZC
U8D8iHYUCPIv2UAnBMperkO5/1R/4del4QjeeBNUCnnWR2i77AgNSQFknAorDY2B
E7nmFMMBIDKCYCjvySZrK4H2J8flMeesBVG4bVwVITnJQm0p0gqXcbSUqYxR0jhq
75yYaQbE4RxghKrl0zIXdFT0BR4HA+3bf4+viS8fsvBOPgYKNC1DyAhv6k/p6+xz
WyDClHrAXhNi0eq9CmphIxtXd7Ddo7C4Ns6ReyulKLHq781LRL3y1nsEN6O66lqF
8FAMKD6XChiu5RC791KcHcQDSyfmYExY6mTVscHva61CUFlAPScMBy8LkJaaDlYX
+4DINY1f27OjJ3tHsM+FjhpWzPcCEGtjMbtPGM6iwS8IsSBVUi5x1tV++iIx0f3l
WhcLQ5AidLq8Eom4UQEcxl0FC6jbkaWNhyEC8UNWRC4u1ObAihnfAPvkuAyWCsUk
x0CLPpKO2P9c7ACRjYEAvEqLg900ae13lVN3M9B2FhwBsm++r1EZc4tHm5IbTIdB
VH1c1Cl4BS3ufzr02ljV
=LcMe
-----END PGP SIGNATURE-----
--- End Message ---
