← Back to team overview

desktop-packages team mailing list archive

[Bug 1424509] Re: lsclusters claims clusters are not running, when they are under systemd

 

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 ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (166bzr2) ...
Selecting previously unselected package postgresql-9.4.
Preparing to unpack .../postgresql-9.4_9.4.1-1_amd64.deb ...
Unpacking postgresql-9.4 (9.4.1-1) ...
Selecting previously unselected package postgresql.
Preparing to unpack .../postgresql_9.4+166bzr2_all.deb ...
Unpacking postgresql (9.4+166bzr2) ...
Processing triggers for man-db (2.7.0.2-5) ...
Processing triggers for ureadahead (0.100.0-19) ...
Setting up libpq5:amd64 (9.4.1-1) ...
Setting up postgresql-client-common (166bzr2) ...
Setting up postgresql-client-9.4 (9.4.1-1) ...
update-alternatives: using /usr/share/postgresql/9.4/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up ssl-cert (1.0.35) ...
Setting up postgresql-common (166bzr2) ...
Adding user postgres to group ssl-cert

Creating config file /etc/postgresql-common/createcluster.conf with new
version

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Setting up postgresql-9.4 (9.4.1-1) ...
Creating new cluster 9.4/main ...
  config /etc/postgresql/9.4/main
  data   /var/lib/postgresql/9.4/main
  locale en_US.UTF-8
Flags of /var/lib/postgresql/9.4/main set as -------------e-C
  port   5432
update-alternatives: using /usr/share/postgresql/9.4/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
Setting up postgresql (9.4+166bzr2) ...
Processing triggers for libc-bin (2.19-15ubuntu2) ...
Processing triggers for ureadahead (0.100.0-19) ...
$ sudo pg_lsclusters
Ver Cluster Port Status Owner    Data directory               Log file
9.4 main    5432 online postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log


** Changed in: postgresql-common (Ubuntu)
       Status: Incomplete => Fix Released

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-common in Ubuntu.
https://bugs.launchpad.net/bugs/1424509

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

Status in postgresql-common package in Ubuntu:
  Fix Released

Bug description:
  $ 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
  postgresql@9.4-main.service loaded active running PostgreSQL Cluster 9.4-main
  postgresql@9.4-xnox.service 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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1424509/+subscriptions


References