Thanks for the clarification Mario!
Now things fit together.
I'll mark the resource agent tasks invalid here per these comments to make sure
no one is confused again.
TL;DR:
- not fixed in postgresql-common
- only fixed in resouce-agent for Xenial/Bionic via SRU in bug 1762492
** Changed in: resource-agents (Ubuntu Xenial)
Status: Confirmed => Invalid
** Changed in: resource-agents (Ubuntu Bionic)
Status: Confirmed => Invalid
--
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:
Fix Released
Status in postgresql-common source package in Xenial:
Won't Fix
Status in resource-agents source package in Xenial:
Invalid
Status in postgresql-common source package in Bionic:
Won't Fix
Status in resource-agents source package in Bionic:
Invalid
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 : [email protected]
Unsubscribe : https://launchpad.net/~group.of.nepali.translators
More help : https://help.launchpad.net/ListHelp
