[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Changed in: postgresql-common (Debian) Status: New => Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
Unsubscribing sponsors for now; Brian is right. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. 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: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Changed in: resource-agents (Ubuntu) Assignee: Eric Desrochers (slashd) => Mario Splivalo (mariosplivalo) -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. 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: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Changed in: resource-agents (Ubuntu) Assignee: (unassigned) => 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 ** Changed in: resource-agents (Ubuntu) Status: New => In Progress -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. 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: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Also affects: resource-agents (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. 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: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Tags removed: sts-sponsor-slashd -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress Status in postgresql-common package in Debian: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
It looks like this is getting fixed in the resource agents in upstream: https://github.com/ClusterLabs/resource-agents/pull/1102 So we might wait a bit to see if upstream will accept this change. If so, it will be merged in Debian and I'll create a SRU against resource- agents package in ubuntu. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress Status in postgresql-common package in Debian: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
The Stable Release Update process requires that the bug have a information regarding its impact, a test case and regression potential in the bug description. For this to be considered by the SRU team that information will need to be added. https://wiki.ubuntu.com/StableReleaseUpdates#SRU_Bug_Template -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress Status in postgresql-common package in Debian: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Tags removed: sts-sponsor ** Tags added: sts-sponsor-slashd ** 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 -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress Status in postgresql-common package in Debian: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Changed in: postgresql-common (Debian) Status: Unknown => New -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress Status in postgresql-common package in Debian: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Bug watch added: Debian Bug tracker #890427 https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=890427 ** Also affects: postgresql-common (Debian) via https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=890427 Importance: Unknown Status: Unknown ** Tags added: sts-sponsor -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress Status in postgresql-common package in Debian: Unknown 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Patch added: "postgresql-common_184ubuntu1.2_artful.debdiff" https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1749283/+attachment/5055131/+files/postgresql-common_184ubuntu1.2_artful.debdiff -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Patch added: "postgresql-common_173ubuntu0.2_xenial.debdiff" https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1749283/+attachment/5055132/+files/postgresql-common_173ubuntu0.2_xenial.debdiff ** Changed in: postgresql-common (Ubuntu Xenial) Status: New => In Progress ** Changed in: postgresql-common (Ubuntu Artful) Status: New => In Progress ** Changed in: postgresql-common (Ubuntu Bionic) Status: New => In Progress -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
I have created a PPA where I built proposed fixes for this package: https://launchpad.net/~mariosplivalo/+archive/ubuntu/lp1749283 I am also attaching a debdiffs here. ** Patch added: "postgresql-common_190ubuntu1_bionic.debdiff" https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1749283/+attachment/5055130/+files/postgresql-common_190ubuntu1_bionic.debdiff -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: In Progress Status in postgresql-common source package in Xenial: In Progress Status in postgresql-common source package in Artful: In Progress Status in postgresql-common source package in Bionic: In Progress 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Changed in: postgresql-common (Ubuntu Xenial) Assignee: (unassigned) => Mario Splivalo (mariosplivalo) ** Changed in: postgresql-common (Ubuntu Artful) Assignee: (unassigned) => Mario Splivalo (mariosplivalo) ** Changed in: postgresql-common (Ubuntu Bionic) Assignee: (unassigned) => Mario Splivalo (mariosplivalo) -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: New Status in postgresql-common source package in Xenial: New Status in postgresql-common source package in Artful: New Status in postgresql-common source package in Bionic: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
** Also affects: postgresql-common (Ubuntu Artful) Importance: Undecided Status: New ** Also affects: postgresql-common (Ubuntu Bionic) Importance: Undecided Status: New ** Also affects: postgresql-common (Ubuntu Xenial) Importance: Undecided Status: New -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: New Status in postgresql-common source package in Xenial: New Status in postgresql-common source package in Artful: New Status in postgresql-common source package in Bionic: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1749283] Re: configured stats_temp_directory does not get created after reboot
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 #stats_temp_directory = 'pg_stat_tmp' -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1749283 Title: configured stats_temp_directory does not get created after reboot Status in postgresql-common package in Ubuntu: New Status in postgresql-common source package in Xenial: New Status in postgresql-common source package in Artful: New Status in postgresql-common source package in Bionic: New 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/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
