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

[lejeczek]

On 10/11/2023 13:13, Jehan-Guillaume de Rorthais wrote:
> 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
Then there must be something else at play here with Ubuntus, 
for none of the nodes has any extra/additional configs for 
those paths & I'm sure that those were not created manually.
Perhpaphs pgSQL created these on it's own outside of 
HA-cluster. Also, one node has the path missing but the 
other two  have & between those two only - how it seems to 
me -  the master PG actually put any data there and if that 
is the case - does the existence of the path alone guarantee 
anything, is the question.