** Changed in: postgresql-common (Debian) Status: New => Fix Released
-- 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: Won't Fix Status in resource-agents package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: Won't Fix Status in resource-agents source package in Xenial: New Status in postgresql-common source package in Artful: Won't Fix Status in resource-agents source package in Artful: New Status in postgresql-common source package in Bionic: Won't Fix Status in resource-agents source package in Bionic: New Status in postgresql-common package in Debian: Fix Released 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 _______________________________________________ Mailing list: https://launchpad.net/~group.of.nepali.translators Post to : group.of.nepali.translators@lists.launchpad.net Unsubscribe : https://launchpad.net/~group.of.nepali.translators More help : https://help.launchpad.net/ListHelp