lsclusters claims clusters are not running, when they are under systemd

[Dimitri John Ledkov]

$ pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.4 main 5432 down postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
9.4 xnox 5433 down postgres /var/lib/postgresql/9.4/xnox /var/log/postgresql/postgresql-9.4-xnox.log

yet

$ sudo systemctl list-units 'postgresql*'
UNIT LOAD ACTIVE SUB DESCRIPTION
postgresql.service loaded active exited PostgreSQL RDBMS
[e-mail] loaded active running PostgreSQL Cluster 9.4-main
[e-mail] loaded active running PostgreSQL Cluster 9.4-xnox

ProblemType: Bug
DistroRelease: Ubuntu 15.04
Package: postgresql-common 166bzr1
ProcVersionSignature: Ubuntu 3.18.0-9.10-generic 3.18.2
Uname: Linux 3.18.0-9-generic x86_64
ApportVersion: 2.16.1-0ubuntu2
Architecture: amd64
CurrentDesktop: Unity
Date: Mon Feb 23 02:57:52 2015
InstallationDate: Installed on 2013-08-29 (542 days ago)
InstallationMedia: Ubuntu 13.10 "Saucy Salamander" - Alpha amd64 (20130829)
PackageArchitecture: all
SourcePackage: postgresql-common
UpgradeStatus: Upgraded to vivid on 2014-11-16 (98 days ago)

[Scott Moser (smoser)]

would appear to cause fallout of bug 1430025 also.

[Martin Pitt (pitti)]

That is indeed strange. Yesterday I fixed two bugs (bug 1429734 and https://launchpad.net/ubuntu/+source/postgresql-common/166bzr2) which both caused the 9.4-main cluster to not start after package installation. To make sure it's not that, can you re-try with latest vivid? (p-common should land within the hour now, it was stuck in -proposed for a while).

Otherwise, are these clusters *really* running? Check with "ps aux|grep post"? Can you please give me the output of "systemctl status -l [e-mail]", and "ls -la /var/run/postgresql/"?

[Scott Moser (smoser)]

fix-released

$ apt-cache policy postgresql
postgresql:
  Installed: (none)
  Candidate: 9.4+166bzr2
  Version table:
     9.4+166bzr2 0
        500 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main amd64 Packages

$ cat /$ cat /proc/cmdline
BOOT_IMAGE=/boot/vmlinuz-3.19.0-7-generic root=LABEL=cloudimg-rootfs ro init=/lib/systemd/systemd console=tty1 console=ttyS0

$ sudo apt-get install -qy postgresql
Reading package lists...
Building dependency tree...
Reading state information...
The following extra packages will be installed:
  libpq5 postgresql-9.4 postgresql-client-9.4 postgresql-client-common
  postgresql-common ssl-cert
Suggested packages:
  postgresql-doc oidentd ident-server locales-all postgresql-doc-9.4 openssl-blacklist
The following NEW packages will be installed:
  libpq5 postgresql postgresql-9.4 postgresql-client-9.4 postgresql-client-common
  postgresql-common ssl-cert
0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded.
Need to get 3,929 kB of archives.
After this operation, 16.3 MB of additional disk space will be used.
Get:1 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main libpq5 amd64 9.4.1-1 [76.4 kB]
Get:2 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main postgresql-client-common all 166bzr2 [26.9 kB]
Get:3 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main postgresql-client-9.4 amd64 9.4.1-1 [816 kB]
Get:4 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main ssl-cert all 1.0.35 [17.4 kB]
Get:5 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main postgresql-common all 166bzr2 [151 kB]
Get:6 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main postgresql-9.4 amd64 9.4.1-1 [2,837 kB]
Get:7 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/main postgresql all 9.4+166bzr2 [5,104 B]
Fetched 3,929 kB in 0s (30.7 MB/s)
Preconfiguring packages ...
Selecting previously unselected package libpq5:amd64.
(Reading database ... (Reading database ... 5%(Reading database ... 10%(Reading database ... 15%(Reading database ... 20%(Reading database ... 25%(Reading database ... 30%(Reading database ... 35%(Reading database ... 40%(Reading database ... 45%(Reading database ... 50%(Reading database ... 55%(Reading database ... 60%(Reading database ... 65%(Reading database ... 70%(Reading database ... 75%(Reading database ... 80%(Reading database ... 85%(Reading database ... 90%(Reading database ... 95%(Reading database ... 100%(Reading database ... 79484 files and directories currently installed.)
Preparing to unpack .../libpq5_9.4.1-1_amd64.deb ...
Unpacking libpq5:amd64 (9.4.1-1) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../postgresql-client-common_166bzr2_all.deb ...
Unpacking postgresql-client-common (166bzr2) ...
Selecting previously unselected package postgresql-client-9.4.
Preparing to unpack .../postgresql-client-9.4_9.4.1-1_amd64.deb ...
Unpacking postgresql-client-9.4 (9.4.1-1) ...
Selecting previously unselected package ssl-cert.
Preparing to unpack .../ssl-cert_1.0.35_all.deb ...
Unpacking ssl-cert (1.0.35) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_166bzr2_all.deb ...
...