On 10/11/2023 13:13, Jehan-Guillaume de Rorthais wrote:
On Fri, 10 Nov 2023 12:27:24 +0100
lejeczek via Users <users@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.
_______________________________________________
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users
ClusterLabs home: https://www.clusterlabs.org/