From: | lejeczek <peljasz(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | fails to start - pg_stat_tmp ? |
Date: | 2023-11-10 10:33:31 |
Message-ID: | 3c1964cc-ac89-4378-9b4f-841d8cb0fe01@yahoo.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)drwszelaki_discourse FATAL: the database
system is starting up
2023-11-10 10:18:45.545 UTC [54863]
drwszelakiadmmdisc(at)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-11-10 12:20:19 | Re: fails to start - pg_stat_tmp ? |
Previous Message | B Liu | 2023-11-10 08:43:21 | Re: pgagent-pg16 could not start: Error 1053 |