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

[Windl, Ulrich]

But shouldn't the RA check for that (and act appropriately)?

-----Original Message-----
From: Users <users-bounces at clusterlabs.org> On Behalf Of Jehan-Guillaume de Rorthais via Users
Sent: Friday, November 10, 2023 1:13 PM
To: lejeczek via Users <users at clusterlabs.org>
Cc: Jehan-Guillaume de Rorthais <jgdr at dalibo.com>
Subject: [EXT] Re: [ClusterLabs] PAF / pgSQL fails after OS/system shutdown - FIX

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
_______________________________________________
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users

ClusterLabs home: https://www.clusterlabs.org/