| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Abdullah Ergin <abdullaherginwork(at)gmail(dot)com>, 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 19:05:19 |
| Message-ID: | 6df759efadaf406cf72ee4440204b25aa4ca407f.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, 2023-11-13 at 21:00 +0300, Abdullah Ergin wrote:
> 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
>
> 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'
Use the absolute path for "pgbackrest".
Did you install pgBackRest on the standby?
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abdullah Ergin | 2023-11-13 19:42:08 | Re: BUG #18179: Cluster History Error |
| Previous Message | Abdullah Ergin | 2023-11-13 18:00:17 | Re: BUG #18179: Cluster History Error |