With the default install it is obviously systemd managed.
There the config defaults to:
$ grep stats_temp /etc/postgresql/10/main/postgresql.conf
stats_temp_directory = '/var/run/postgresql/10-main.pg_stat_tmp'
and later the same with version bumped
$ grep stats_temp /etc/postgresql/11/main/postgresql.conf
stats_temp_directory = '/var/run/postgresql/11-main.pg_stat_tmp'
Adn as identified before each cluster is started through pg_ctlcluster as part
of a templated service at /lib/systemd/system/postgresql@.service.
See /usr/share/doc/postgresql-common/README.systemd for more.
The above was mostly for myself to context switch in what was said on
this bug before.
@Dmitrii - with "systemd is not used to manage postgres lifetime" you
meant the heartbeat setup discussed here right? Or are there other cases
affected? Because then the fix in resource would obviously not help that
much - yet OTOH it is meant to be used through systemd, not sure how
much of a pgsql bug it would be then.
@Dmitrii - Since I don't know when/if Mario will respond I created you a PPA
(Bionic+Xenial) to try. Feel free to test that and let me know if that would
help your case.
=>
https://launchpad.net/~paelzer/+archive/ubuntu/bug-1749283-resource-agent-to-start-pgsql
@Dmitrii - Finally if you would convert "easily reproducible when
systemd is not used to manage postgres lifetime" into a small set of
commands I'd appreciate that (maybe you have that already around?).
P.S. to be ahead I also have added MPs for the (rather trivial) change
to be reviewable.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1749283
Title:
configured stats_temp_directory does not get created after reboot
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1749283/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
