fails to start - pg_stat_tmp ?

Поиск
Список
Период
Сортировка
От lejeczek
Тема fails to start - pg_stat_tmp ?
Дата
Msg-id 3c1964cc-ac89-4378-9b4f-841d8cb0fe01@yahoo.co.uk
обсуждение исходный текст
Ответы Re: fails to start - pg_stat_tmp ?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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@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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: B Liu
Дата:
Сообщение: Re: pgagent-pg16 could not start: Error 1053
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: fails to start - pg_stat_tmp ?