fails to start - pg_stat_tmp ?

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.

Responses

Browse pgsql-admin by date

  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