configured stats_temp_directory does not get created after reboot
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-common (Debian) |
Fix Released
|
Unknown
|
|||
postgresql-common (Ubuntu) |
Won't Fix
|
Medium
|
Mario Splivalo | ||
Xenial |
Won't Fix
|
Medium
|
Mario Splivalo | ||
Bionic |
Won't Fix
|
Medium
|
Mario Splivalo | ||
resource-agents (Ubuntu) |
Fix Released
|
Medium
|
Mario Splivalo | ||
Xenial |
Invalid
|
Undecided
|
Unassigned | ||
Bionic |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Default postgres installation in Ubuntu (and Debian) configures stats_temp_
$ grep stats_temp /etc/postgresql
stats_temp_
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/
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/
Currently only /var/run/postgresql and /var/log/postgresql are created using systemd-tmpfiles.
Related branches
- Andreas Hasenack: Approve
- Canonical Server: Pending requested
- git-ubuntu developers: Pending requested
-
Diff: 106 lines (+84/-0)3 files modifieddebian/changelog (+7/-0)
debian/patches/lp-1749283-pgsql-stats_temp_directory.patch (+76/-0)
debian/patches/series (+1/-0)
- Andreas Hasenack: Approve
- Canonical Server: Pending requested
- Canonical Server packageset reviewers: Pending requested
-
Diff: 106 lines (+84/-0)3 files modifieddebian/changelog (+7/-0)
debian/patches/lp-1749283-pgsql-stats_temp_directory.patch (+76/-0)
debian/patches/series (+1/-0)
Changed in postgresql-common (Ubuntu Xenial): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in postgresql-common (Ubuntu Artful): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in postgresql-common (Ubuntu Bionic): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
tags: | added: sts-sponsor |
Changed in postgresql-common (Debian): | |
status: | Unknown → New |
tags: |
added: sts-sponsor-slashd removed: sts-sponsor |
Changed in postgresql-common (Ubuntu Xenial): | |
importance: | Undecided → Medium |
Changed in postgresql-common (Ubuntu Artful): | |
importance: | Undecided → Medium |
Changed in postgresql-common (Ubuntu Bionic): | |
importance: | Undecided → Medium |
tags: | removed: sts-sponsor-slashd |
Changed in resource-agents (Ubuntu): | |
assignee: | nobody → Eric Desrochers (slashd) |
Changed in postgresql-common (Ubuntu): | |
status: | In Progress → Won't Fix |
Changed in postgresql-common (Ubuntu Xenial): | |
status: | In Progress → Won't Fix |
Changed in postgresql-common (Ubuntu Artful): | |
status: | In Progress → Won't Fix |
Changed in postgresql-common (Ubuntu Bionic): | |
status: | In Progress → Won't Fix |
Changed in resource-agents (Ubuntu): | |
importance: | Undecided → Medium |
status: | New → In Progress |
Changed in resource-agents (Ubuntu): | |
assignee: | Eric Desrochers (slashd) → Mario Splivalo (mariosplivalo) |
Changed in postgresql-common (Debian): | |
status: | New → Fix Released |
tags: | added: cpe-onsite |
Changed in resource-agents (Ubuntu): | |
status: | In Progress → Fix Released |
Changed in resource-agents (Ubuntu Xenial): | |
status: | New → Confirmed |
Changed in resource-agents (Ubuntu Bionic): | |
status: | New → Confirmed |
no longer affects: | postgresql-common (Ubuntu Artful) |
no longer affects: | resource-agents (Ubuntu Artful) |
This does not affect trusty as in trusty stats_temp_ directory is not configured:
ubuntu@pg-tru:~$ grep stats_temp /etc/postgresql /9.3/main/ postgresql. conf temp_directory = 'pg_stat_tmp'
#stats_