[ClusterLabs] PAF / pgSQL fails after OS/system shutdown - FIX

[Jehan-Guillaume de Rorthais]

On Fri, 10 Nov 2023 12:27:24 +0100
lejeczek via Users <users at clusterlabs.org> wrote:
...
> >  
> to share my "fix" for it - perhaps it was introduced by 
> OS/packages (Ubuntu 22) updates - ? - as oppose to resource 
> agent itself.
> 
> As the logs point out - pg_stat_tmp - is missing and from 
> what I see it's only the master, within a cluster, doing 
> those stats.
> That appeared, I use the word for I did not put it into 
> configs, on all nodes.
> fix = to not use _pg_stat_tmp_ directive/option at all.

Of course you can use "pg_stat_tmp", just make sure the temp folder exists:

  cat <<EOF > /etc/tmpfiles.d/postgresql-part.conf
  # Directory for PostgreSQL temp stat files
  d /var/run/postgresql/14-paf.pg_stat_tmp 0700 postgres postgres - -
  EOF

To take this file in consideration immediately without rebooting the server,
run the following command:

  systemd-tmpfiles --create /etc/tmpfiles.d/postgresql-part.conf