group.of.nepali.translators team mailing list archive

[Mario Splivalo <mario.splivalo@xxxxxxxxxxxxx>]

** Bug watch added: Debian Bug tracker #890427
   https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=890427

** Also affects: postgresql-common (Debian) via
   https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=890427
   Importance: Unknown
       Status: Unknown

** Tags added: sts-sponsor

-- 
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1749283

Title:
  configured stats_temp_directory does not get created after reboot

Status in postgresql-common package in Ubuntu:
  In Progress
Status in postgresql-common source package in Xenial:
  In Progress
Status in postgresql-common source package in Artful:
  In Progress
Status in postgresql-common source package in Bionic:
  In Progress
Status in postgresql-common package in Debian:
  Unknown

Bug description:
  Default postgres installation in Ubuntu (and Debian) configures
  stats_temp_directory inside /var/run/postgresql:

  $ grep stats_temp /etc/postgresql/10/main/postgresql.conf 
  stats_temp_directory = '/var/run/postgresql/10-main.pg_stat_tmp'

  However, this directory is not created after reboot.

  In most cases this is not a problem as systemd starts postgres via
  pg_ctlcluster, a "multiversion/cluster aware pg_ctl wrapper", and
  pg_ctlcluster will create missing directories before starting
  postgres.

  But in cases where systemd is not starting postgres this is a problem.
  Specifically, when postgres is controlled by pacemaker (using postgres resource agent for pacemaker) it is started using pg_ctl wrapper. pg_ctl won't create missing directories and therefore postgres fails to start.

  The simplest solution for this issue is to have systemd recreate
  missing directories via /usr/lib/tmpfiles.d/postgresql.conf file.

  Currently only /var/run/postgresql and /var/log/postgresql are created
  using systemd-tmpfiles.

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