Your message dated Tue, 27 Jun 2006 03:02:06 -0700
with message-id <[EMAIL PROTECTED]>
and subject line Bug#180849: fixed in postgresql-common 56
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
Version: 7.3.2r-4
Severity: normal
Hi,
the postgresql start/stop script uses this file as a PID file for the
postmaster daemon:
/var/lib/postgres/data/postmaster.pid
According to Debian policy, PID files should be in /var/run/
There is another problem with the wrong location of this PID file: when the
machine crashes, postgresql does not restart automatically.
/etc/init.d/postgresql detects the presence of the PID file and does not start
postgresql. It has to be removed manually. If it where in /var/run/ another
init script would remove this file automatically.
Therefore I suggest that in /etc/init.d/postgresql
/sbin/start-stop-daemon --pidfile $PGDATA/postmaster.pid
should be replaced with:
/sbin/start-stop-daemon --pidfile /var/run/postmaster.pid
-- System Information:
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux irancy 2.4.20-k7 #2 Sun Dec 1 13:41:25 EST 2002 i686
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED]
Versions of packages postgresql depends on:
ii adduser 3.49 Add and remove users and groups
ii debconf 1.2.32 Debian configuration management sy
ii debianutils 2.4.1 Miscellaneous utilities specific t
ii libc6 2.3.1-14 GNU C Library: Shared libraries an
ii libcomerr1-kerbe 1.2.1-7 ComErr Libraries for Kerberos4 Fro
ii libkrb5-17-heimd 0.5.1-6 Libraries for Heimdal Kerberos
ii libpam0g 0.76-9 Pluggable Authentication Modules l
ii libpq3 7.3.2r-4 Shared library libpq.so.3 for Post
ii libreadline4 4.3-4 GNU readline and history libraries
ii libssl0.9.7 0.9.7a-1 SSL shared libraries
pi mailx 1:8.1.2-0.20020411cvs-5 A simple mail user agent.
ii postgresql-clien 7.3.2r-4 Front-end programs for PostgreSQL
ii python2.2 2.2.2-5 An interactive object-oriented scr
ii zlib1g 1:1.1.4-11 compression library - runtime
-- debconf information:
postgresql/enable_lang: true
postgresql/very_old_version_warning: true
postgresql/peer-to-ident: true
postgresql/missing_conf: true
* postgresql/settings/encoding: UNICODE
* postgresql/upgrade/preserve_location: /var/lib/postgres/preserve
* postgresql/settings/day_month_order: European
postgresql/convert-postmaster.init: true
* postgresql/upgrade/policy: true
postgresql/contains_POSTGRESHOME: true
* postgresql/upgrade/dump_location: /var/lib/postgres
postgresql/convert-pg_hba.conf: true
* postgresql/initdb/location: /var/lib/postgres/data
* postgresql/settings/locale: C
* postgresql/purge_data_too: true
* postgresql/settings/date_style: ISO
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 56
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:
postgresql-client-common_56_all.deb
to pool/main/p/postgresql-common/postgresql-client-common_56_all.deb
postgresql-common_56.dsc
to pool/main/p/postgresql-common/postgresql-common_56.dsc
postgresql-common_56.tar.gz
to pool/main/p/postgresql-common/postgresql-common_56.tar.gz
postgresql-common_56_all.deb
to pool/main/p/postgresql-common/postgresql-common_56_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-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 [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Mon, 26 Jun 2006 19:02:41 +0200
Source: postgresql-common
Binary: postgresql-client-common postgresql-common
Architecture: source all
Version: 56
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description:
postgresql-client-common - manager for multiple PostgreSQL client versions
postgresql-common - manager for PostgreSQL database clusters
Closes: 180849 184782 358152
Changes:
postgresql-common (56) unstable; urgency=low
.
* debian/init.d-functions, status(): Exit with code 3 if any cluster is
down, to get a bit closer to LSB specification (which does not
sufficiently specify the case of controlling multiple processes in one
init script). Thanks to Ross Boylan <[EMAIL PROTECTED]>!
Closes: #358152
* pg_ctlcluster:
- start: Create an external PID file /var/run/postgresql/
<version>-<cluster>.pid for 8.0+ versions (7.4 doesn't support this yet)
unless 'external_pid_file' is already set in postgresql.conf.
Closes: #180849, #184782
- stop: Remove this external pid file (this should be done by the
postmaster itself, but 8.1.4 does not).
* t/020_create_sql_remove.t: Check that starting a cluster creates a PID
file in /var/run/postgresql/, but doesn't if external_pid_file was set
explicitly.
* t/030_errors.t: Adapt to new PID file creation behaviour.
* t/030_errors.t: modprobe loop before setting up the test loopback device.
* debian/supported-versions: Add Ubuntu 6.10.
Files:
955b62e8b63fba46b748f91e5f18cdb6 604 misc optional postgresql-common_56.dsc
d20833ab19915a450b8a5eabe5e18cea 81001 misc optional
postgresql-common_56.tar.gz
9d33ad387caa9925cb35b3cf083c43b7 86176 misc optional
postgresql-common_56_all.deb
07ad0181ec413e9b706780915ca960d4 35572 misc optional
postgresql-client-common_56_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFEoP28DecnbV4Fd/IRAsJQAKCVyYLmulIpF4D+OzfpeSzpYWsQZQCeMV0D
z1QIyyveS5zDx5AEOXG4PtE=
=um85
-----END PGP SIGNATURE-----
--- End Message ---
