Your message dated Fri, 01 Mar 2019 21:24:30 +0000
with message-id <[email protected]>
and subject line Bug#918784: fixed in postgresql-common 200
has caused the Debian Bug report #918784,
regarding postgresql-common: Tries to start nonexistent version
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 [email protected]
immediately.)
--
918784: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=918784
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-common
Version: 198
Severity: normal
I recently noticed that I had several PostgreSQL version installed in
parallel (9.5, 9.6, 10 and 11). Therefore I looked up the upgrade path
and upraded from 9.5 to 11. This went fine, thanks for the smooth
procedure.
I then removed the unneeded version 9.6 and 10 (I intend to remove 9.5
later). Now at every boot I see
[FAILED] Failed to start PostgreSQL Cluster 10-main.
See 'systemctl status [email protected]' for details.
• [email protected] - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/[email protected]; enabled-runtime;
vendor preset: enabled)
Active: failed (Result: protocol) since Wed 2019-01-09 10:40:30 CET; 4min
49s ago
Process: 603 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect
10-main start (code=exited, status=1/FAILURE)
Jan 09 10:40:29 samd systemd[1]: Starting PostgreSQL Cluster 10-main...
Jan 09 10:40:29 samd postgresql@10-main[603]: Error: start -D
/var/lib/postgresql/10/main -l /var/log/postgresql/postgresql-10-main.log -s -o
-c config_file="/etc/postgresql/10/main/postgresql.conf" exited with status 1:
Jan 09 10:40:29 samd postgresql@10-main[603]: Can't exec "": Datei oder
Verzeichnis nicht gefunden at /usr/bin/pg_ctlcluster line 211.
Jan 09 10:40:29 samd postgresql@10-main[603]: Error: could not exec start -D
/var/lib/postgresql/10/main -l /var/log/postgresql/postgresql-10-main.log -s -o
-c config_file="/etc/postgresql/10/main/postgresql.conf" : No such file or
direcJan 09 10:40:29 samd systemd[1]: [email protected]: Can't open
PID file /run/postgresql/10-main.pid (yet?) after start: No such file or
directory
Jan 09 10:40:29 samd systemd[1]: [email protected]: Failed with result
'protocol'.
Jan 09 10:40:30 samd systemd[1]: Failed to start PostgreSQL Cluster 10-main.
(Datei oder Verzeichnis nicht gefunden → File or directory not found)
Somehow the package system noticed that 9.6 no longer needs to be
started, but failed to do this for version 10.
-- System Information:
Debian Release: buster/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.19.13samd.01 (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) (ignored: LC_ALL
set to de_DE.UTF-8), LANGUAGE=de_DE.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set
to de_DE.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages postgresql-common depends on:
ii adduser 3.118
ii debconf [debconf-2.0] 1.5.69
ii lsb-base 10.2018112800
ii postgresql-client-common 198
ii procps 2:3.3.15-2
ii ssl-cert 1.0.39
ii ucf 3.0038+nmu1
Versions of packages postgresql-common recommends:
ii e2fsprogs 1.44.5-1
ii logrotate 3.14.0-4
Versions of packages postgresql-common suggests:
pn libjson-perl <none>
-- debconf information:
postgresql-common/catversion-bump:
* postgresql-common/ssl: true
* postgresql-common/obsolete-major:
--
Dr. Helge Kreutzmann [email protected]
Dipl.-Phys. http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
Help keep free software "libre": http://www.ffii.de/
signature.asc
Description: Digital signature
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 200
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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <[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: SHA256
Format: 1.8
Date: Fri, 01 Mar 2019 20:47:06 +0100
Source: postgresql-common
Binary: postgresql-common postgresql-client-common postgresql-server-dev-all
postgresql postgresql-client postgresql-doc postgresql-contrib postgresql-all
Architecture: source
Version: 200
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <[email protected]>
Changed-By: Christoph Berg <[email protected]>
Description:
postgresql - object-relational SQL database (supported version)
postgresql-all - metapackage depending on all PostgreSQL server packages
postgresql-client - front-end programs for PostgreSQL (supported version)
postgresql-client-common - manager for multiple PostgreSQL client versions
postgresql-common - PostgreSQL database-cluster manager
postgresql-contrib - additional facilities for PostgreSQL (supported version)
postgresql-doc - documentation for the PostgreSQL database management system
postgresql-server-dev-all - extension build tool for multiple PostgreSQL
versions
Closes: 653870 810615 839954 872660 891234 910991 916449 918784 920248
Changes:
postgresql-common (200) unstable; urgency=medium
.
* pg_createcluster: Don't refuse explicit -p argument even when port is
already in use. (Closes: #653870)
* pg_createcluster: Override suggested cluster start command in initdb.
(Closes: #872660)
* pg_upgradecluster, t/052_upgrade_encodings.t: pg_dumpall 11 retains the
database encoding, so switching encodings via dump-restore does not work
anymore.
* pg_upgradecluster: Deprecate 'replacement_sort_tuples' in version 11.
* pg_upgradecluster: Migrate postgresql.auto.conf to new cluster.
(Closes: #810615)
* pg_ctlcluster: Die early if logfile is not available. (Closes: #891234)
* pg_ctlcluster: Die early if pg_ctl cannot be found. (See: #918784)
* pg_ctlcluster: Document --skip-systemctl-redirect, and skip redirect if
--foreground is requested.
* pg_renamecluster: Notify systemd. (Closes: #839954)
* pg_renamecluster: Document that cluster_name is updated as well.
* pg_dropcluster: Delete tablespace directories. (Closes: #916449)
* pg_dropcluster: Silence warning if data_directory is already gone.
Spotted by Jean-Christophe Arnu, merci!
* get_cluster_port: Fall back to 5432 if port is not defined in config.
(Closes: #920248)
* read_cluster_conf_file: Use cluster_data_directory instead of hardcoding
/var/lib/postgresql.
* [email protected]: Add After=network.target to ensure the server is
stopped before networking goes down on shutdown. Thanks Elrond!
(Closes: #910991)
* [email protected]: Drop /var prefix from PIDFile, systemd complained
about legacy directory /var/run/postgresql.
* postgresql-generator: Don't attempt to auto-start removed versions.
(Closes: #918784)
Checksums-Sha1:
d6675402a5fe29fd14fb57c3d4539b7617f2d8f6 2309 postgresql-common_200.dsc
fe8db48a9d888ed6008ae803a77298430cf7ee5e 212312 postgresql-common_200.tar.xz
Checksums-Sha256:
f1328615b2b2b99cd0ac5d641887670f75b3b355a056e35ec2618fdf93ccc221 2309
postgresql-common_200.dsc
ccd6f45ce5674d1a0115be98f370e0016b96edba796584ebc46bc933e42c8761 212312
postgresql-common_200.tar.xz
Files:
88628166ef7ccb1b61a842159d1b799b 2309 database optional
postgresql-common_200.dsc
fa65f945b2cf4bf6a8c5a303014661e5 212312 database optional
postgresql-common_200.tar.xz
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlx5mrkACgkQTFprqxLS
p67U6RAAnoidZEhJJL+vvNhewfEXqseDJgY5NJ7vVsewdAg33kDxwnbXXf562Qet
kyPwvIycL8sJJ2d3THPV7oRTUtAgjhx+JUWmpY3FHran3Em9jQ0oJrw297xrhJSc
lsznchLV0xmJHnCFVVWX6pOX576BMVQbMFC094VclW6OXEZNauvBOaLYakqjU5Xr
wjfPCJxzTIOQkOWap8hrNGGLA49rapX7p9sZY7V8naaybk3zclv/MuEZ1wXRc2Cz
x+TIWG7ceLFFndAtITBC0xX/k0dVXGPWxQbJkr970soLPIvMTxNr3WbMFamKwn03
LTbsf2zhO82i15fuaPNApE8CbBVjmbR9wUzH8oTcZVKwJj8N9XWArPU7TGqw2au1
sY+rhWxLv6jSVqrN75iiNtFJ5usFBQAWAAPl4rG+elLgDNTpTKZ8iMNiH/hncwUM
JBpSP+rzRZH7Of7vV/F+R9soNlF8akQNdEm4VXOrygk/dZOW/7wgDb62b/wiPgwF
9NZ6cWMmtLXxBBptARM+XctVzHbB5ac2Vu9tBkOeu2UfQC8eOTtS2RKUJ223RA0e
Lh4TfgV1I+AqwCxd6dN9oJiv18dN5209HjnNNDxkyEdqPMOJ9cEVqIDbVnmsbIR+
5lsIjoV0S2eRf61oXpPnCbMz5pubdvx9dTM3C1+tnzFbgilX9mE=
=STnB
-----END PGP SIGNATURE-----
--- End Message ---
