You have been subscribed to a public bug by Mario Splivalo (mariosplivalo):
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.
** Affects: postgresql-common (Ubuntu)
Importance: Undecided
Assignee: Mario Splivalo (mariosplivalo)
Status: In Progress
** Affects: postgresql-common (Ubuntu Xenial)
Importance: Undecided
Assignee: Mario Splivalo (mariosplivalo)
Status: In Progress
** Affects: postgresql-common (Ubuntu Artful)
Importance: Undecided
Assignee: Mario Splivalo (mariosplivalo)
Status: In Progress
** Affects: postgresql-common (Ubuntu Bionic)
Importance: Undecided
Assignee: Mario Splivalo (mariosplivalo)
Status: In Progress
--
configured stats_temp_directory does not get created after reboot
https://bugs.launchpad.net/bugs/1749283
You received this bug notification because you are a member of STS Sponsors,
which is subscribed to the bug report.
--
Mailing list: https://launchpad.net/~sts-sponsors
Post to : sts-sponsors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~sts-sponsors
More help : https://help.launchpad.net/ListHelp
