From: lejeczek <peljasz@yahoo.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: fails to start - pg_stat_tmp ?
Date: Fri, 10 Nov 2023 11:33:31 +0100
Message-ID: <3c1964cc-ac89-4378-9b4f-841d8cb0fe01@yahoo.co.uk> (raw)
References: <3c1964cc-ac89-4378-9b4f-841d8cb0fe01.ref@yahoo.co.uk>
Hi guys.
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.
I get:
...
2023-11-10 10:18:45.491 UTC [54858] LOG: starting
PostgreSQL 14.9 (Ubuntu 14.9-0ubuntu0.22.04.1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2023-11-10 10:18:45.491 UTC [54858] LOG: listening on IPv4
address "0.0.0.0", port 5433
2023-11-10 10:18:45.491 UTC [54858] LOG: listening on IPv6
address "::", port 5433
2023-11-10 10:18:45.495 UTC [54858] LOG: listening on Unix
socket "/var/run/postgresql/.s.PGSQL.5433"
2023-11-10 10:18:45.505 UTC [54860] LOG: database system
was interrupted while in recovery at log time 2023-11-10
09:53:18 UTC
2023-11-10 10:18:45.505 UTC [54860] HINT: If this has
occurred more than once some data might be corrupted and you
might need to choose an earlier recovery target.
2023-11-10 10:18:45.540 UTC [54862]
drwszelakiadmmdisc@drwszelaki_discourse FATAL: the database
system is starting up
2023-11-10 10:18:45.545 UTC [54863]
drwszelakiadmmdisc@drwszelaki_discourse FATAL: the database
system is starting up
2023-11-10 10:18:45.795 UTC [54860] LOG: entering standby mode
2023-11-10 10:18:45.799 UTC [54860] FATAL: could not open
directory "/var/run/postgresql/14-paf.pg_stat_tmp": No such
file or directory
2023-11-10 10:18:45.800 UTC [54858] LOG: startup process
(PID 54860) exited with exit code 1
2023-11-10 10:18:45.800 UTC [54858] LOG: aborting startup
due to startup process failure
2023-11-10 10:18:45.802 UTC [54858] LOG: database system is
shut down
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.
What would that specific errors be suggesting or meaning -
do I have something mis-configured, perhaps the toolset
itself does not deal with "mere" reboot well, or at all.
Toolset is HA/pcs(pacemaker) cluster tools.
many thanks, L.
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: <3c1964cc-ac89-4378-9b4f-841d8cb0fe01@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