Re: BUG #18179: Cluster History Error

Поиск
Список
Период
Сортировка
От Abdullah Ergin
Тема Re: BUG #18179: Cluster History Error
Дата
Msg-id CAJZxWEPQ6FixVPsChpxzKt5Lr+nzqzL-vOrZXdGCX+LptvPZwg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18179: Cluster History Error  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: BUG #18179: Cluster History Error  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-bugs
The log of the error I encountered is as follows:

```
● postgresql@13-mydb.service - PostgreSQL Cluster 13-mydb
   Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
   Active: failed (Result: protocol) since Thu 2023-11-09 17:01:44 +03; 1min 32s ago
  Process: 767207 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 13-mydb start (code=exited, status=1/FAILURE)
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: sh: 1: pgbackrest: not found
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 17:01:44.700 +03 [767228] FATAL: could not restore file "00000004.history" from archive: command not found
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 17:01:44.703 +03 [767227] LOG: startup process (PID 767228) exited with exit code 1
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 17:01:44.703 +03 [767227] LOG: aborting startup due to startup process failure
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 17:01:44.745 +03 [767227] LOG: database system is shut down
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: pg_ctl: could not start server
 Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: Examine the log output.
 Nov 09 17:01:44 se-prd-db02 systemd[1]: postgresql@13-mydb.service: Can't open PID file /run/postgresql/13-mydb.pid (yet?) after start: Operation not permitted
 Nov 09 17:01:44 se-prd-db02 systemd[1]: postgresql@13-mydb.service: Failed with result 'protocol'.
 Nov 09 17:01:44 se-prd-db02 systemd[1]: Failed to start PostgreSQL Cluster 13-mydb.
```

Based on this, I checked the `postgresql.auto.conf` on my master server, and the restore information found there is as follows:

```
# Recovery settings generated by pgBackRest restore on 2021-09-29 01:04:40
restore_command = 'pgbackrest --stanza=mydb_stanza archive-get %f "%p'
```

The archive command information in `postgresql.conf` is as follows:

```
# - Archiving -
archive_mode = on
archive_command = 'pgbackrest --stanza=mydb_stanza archive-push %p'
```
Thank you.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18193: CVE-2019-9193
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: BUG #18179: Cluster History Error