From: lejeczek <peljasz@yahoo.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: fails to start - pg_stat_tmp ?
Date: Fri, 10 Nov 2023 18:33:23 +0100
Message-ID: <6fc34508-2b22-488e-a908-047039b549d6@yahoo.co.uk> (raw)
In-Reply-To: <2874e719d29908405c46ddd4273222aa3544afde.camel@cybertec.at>
References: <3c1964cc-ac89-4378-9b4f-841d8cb0fe01.ref@yahoo.co.uk>
<3c1964cc-ac89-4378-9b4f-841d8cb0fe01@yahoo.co.uk>
<2874e719d29908405c46ddd4273222aa3544afde.camel@cybertec.at>
On 10/11/2023 13:20, Laurenz Albe wrote:
> On Fri, 2023-11-10 at 11:33 +0100, lejeczek wrote:
>> I have simple cluster managed by a popular toolset, I believe, and I get a standby/slave node which
>> after it was shutdown, rebooted, is unable to start, not by the that cluster-manager nor manually.
> Thatks for telling us all the detail...
>
>> FATAL: could not open directory "/var/run/postgresql/14-paf.pg_stat_tmp": No such file or directory
>> LOG: startup process (PID 54860) exited with exit code 1
>>
>> Indeed that dir, that path does not exist on the node - from what I can see, among the nodes
>> comprising the cluster this path exists only on the _master_ node.
> Looks like somebody randomly deleted directories on that machine.
>
> Create it again, and make sure it belongs to the postgres user and
> nobody else has write access.
>
> Yours,
> Laurenz Albe
>
>
Indeed something removes at/after reboot the path, last bit
of with stats - I started fiddling with _systemd_ tmpfiles
which I thought was the culprit but it seems systemd neither
creates nor cleans it.
I also have bucardo - cleaned it up, did not help nor after
I completely removed bucardo
pg_ctlcluster start - does work, with this wrapper path gets
created and server starts
OS journal boot logs do not mention this path neither.
It's a true sticky-wicket for me right now - to add, other
two virtually identical nodes seem free from this issue.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peljasz@yahoo.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: fails to start - pg_stat_tmp ?
In-Reply-To: <6fc34508-2b22-488e-a908-047039b549d6@yahoo.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox