From: Laurenz Albe <laurenz.albe@cybertec.at>
To: lejeczek <peljasz@yahoo.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: fails to start - pg_stat_tmp ?
Date: Fri, 10 Nov 2023 13:20:19 +0100
Message-ID: <2874e719d29908405c46ddd4273222aa3544afde.camel@cybertec.at> (raw)
In-Reply-To: <3c1964cc-ac89-4378-9b4f-841d8cb0fe01@yahoo.co.uk>
References: <3c1964cc-ac89-4378-9b4f-841d8cb0fe01.ref@yahoo.co.uk>
<3c1964cc-ac89-4378-9b4f-841d8cb0fe01@yahoo.co.uk>
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
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: laurenz.albe@cybertec.at, peljasz@yahoo.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: fails to start - pg_stat_tmp ?
In-Reply-To: <2874e719d29908405c46ddd4273222aa3544afde.camel@cybertec.at>
* 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