Your message dated Fri, 29 Jul 2005 08:21:04 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Bug#320402: postgresql: postmaster.pid file not deleted at
boot; crash means no restart
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; 29 Jul 2005 04:54:37 +0000
>From [EMAIL PROTECTED] Thu Jul 28 21:54:37 2005
Return-path: <[EMAIL PROTECTED]>
Received: from shakotay.alphanet.ch [80.83.46.147] (postfix)
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1DyMtJ-00010P-00; Thu, 28 Jul 2005 21:54:37 -0700
Received: by shakotay.alphanet.ch (Postfix, from userid 1000)
id 5E7B4370011; Fri, 29 Jul 2005 06:54:35 +0200 (CEST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Marc SCHAEFER <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: postgresql: postmaster.pid file not deleted at boot; crash means no
restart
X-Mailer: reportbug 3.8
Date: Fri, 29 Jul 2005 06:54:35 +0200
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
If your machine restarts in an uncontrolled way, /var/run is deleted,
but /var/lib/postgres/data/postmaster.pid is not. PostgreSQL will refuse
to start at the next boot even if it could recover from its journal.
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.4.27
Locale: LANG=C, LC_CTYPE=fr_CH (charmap=ISO-8859-1)
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-3 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-3 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/upgrade/preserve_location: /var/lib/postgres/preserve
* postgresql/settings/day_month_order: European
* postgresql/upgrade/policy: true
postgresql/enable_lang: true
postgresql/very_old_version_warning: true
* postgresql/upgrade/dump_location: /var/lib/postgres/
postgresql/convert-pg_hba.conf: true
postgresql/initdb/location: /var/lib/postgres/data
* postgresql/settings/locale: fr_CH.iso88591
* postgresql/purge_data_too: false
---------------------------------------
Received: (at 320402-done) by bugs.debian.org; 29 Jul 2005 06:21:37 +0000
>From [EMAIL PROTECTED] Thu Jul 28 23:21:35 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de [213.9.79.162]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1DyOFT-0006em-00; Thu, 28 Jul 2005 23:21:35 -0700
Received: by box79162.elkhouse.de (Postfix, from userid 1000)
id 1F14B16B16B; Fri, 29 Jul 2005 08:21:04 +0200 (CEST)
Date: Fri, 29 Jul 2005 08:21:04 +0200
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Bug#320402: postgresql: postmaster.pid file not deleted at boot;
crash means no restart
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="JYK4vJDZwFMowpUq"
Content-Disposition: inline
In-Reply-To: <[EMAIL PROTECTED]>
User-Agent: Mutt/1.5.9i
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=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
--JYK4vJDZwFMowpUq
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Version: 7.5.8
Hi Marc!
Marc SCHAEFER [2005-07-29 6:54 +0200]:
> Package: postgresql
> Version: 7.4.7-6sarge1
> Severity: minor
>=20
> If your machine restarts in an uncontrolled way, /var/run is deleted,
> but /var/lib/postgres/data/postmaster.pid is not. PostgreSQL will refuse
> to start at the next boot even if it could recover from its journal.
This has been fixed in sid in
postgresql-common (18) unstable; urgency=3Dlow
[...]
* pg_ctlcluster: Pass the default socket directory to the postmaster,
otherwise it will always be /tmp if unix_socket_directory is not spec=
ified
in postgresql.conf. Closes: #314537
[...]
Unfortunately our shiny new BTS version tracking system doesn't
support "this bug has been fixed in another package", so I mark this
bug as fixed in the transition package "postgresql".
Thanks for your report,
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian Developer http://www.debian.org
--JYK4vJDZwFMowpUq
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFC6crPDecnbV4Fd/IRAut8AKDvX04aBzxArRjAATb4kdyDS7o9iQCgpN6G
PhS3fy/XD89mv16wvCUOpz4=
=sslm
-----END PGP SIGNATURE-----
--JYK4vJDZwFMowpUq--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
