From: | Abdullah Ergin <abdullaherginwork(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #18179: Cluster History Error |
Date: | 2023-11-13 18:00:17 |
Message-ID: | CAJZxWEPQ6FixVPsChpxzKt5Lr+nzqzL-vOrZXdGCX+LptvPZwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The log of the error I encountered is as follows:
```
● postgresql(at)13-mydb(dot)service - PostgreSQL Cluster 13-mydb
Loaded: loaded (/lib/systemd/system/postgresql(at)(dot)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(at)13-mydb[767207]: sh: 1: pgbackrest:
not found
Nov 09 17:01:44 se-prd-db02 postgresql(at)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(at)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(at)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(at)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(at)13-mydb[767207]: pg_ctl: could not
start server
Nov 09 17:01:44 se-prd-db02 postgresql(at)13-mydb[767207]: Examine the log
output.
Nov 09 17:01:44 se-prd-db02 systemd[1]: postgresql(at)13-mydb(dot)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(at)13-mydb(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-11-13 19:05:19 | Re: BUG #18179: Cluster History Error |
Previous Message | David G. Johnston | 2023-11-13 15:30:18 | Re: BUG #18193: CVE-2019-9193 |