Re: BUG #18179: Cluster History Error
| От | Abdullah Ergin |
|---|---|
| Тема | Re: BUG #18179: Cluster History Error |
| Дата | |
| Msg-id | CAJZxWEOoMC00ZEG8zoJhY1dRgdviOhC+fSh2tTFQctcCbM4VfQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #18179: Cluster History Error (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: BUG #18179: Cluster History Error
|
| Список | pgsql-bugs |
Elbette, işte İngilizce çevirisi:
---
I'm relatively new to database expertise, are you referring to the absolute path as follows:
postgresql.auto.conf;
#Recovery settings generated by pgBackRest restore on 2021-09-29 01:04:40
restore_command = '/usr/bin/pgbackrest --stanza=mydb_stanza archive-get %f "%p"'
postgresql.conf;
# - Archiving -
archive_mode = on
archive_command = '/usr/bin/pgbackrest --stanza=mydb_stanza archive-push %p'
Will this operation affect my other clusters since I will perform it on the master server?
Thanks
---
I'm relatively new to database expertise, are you referring to the absolute path as follows:
postgresql.auto.conf;
#Recovery settings generated by pgBackRest restore on 2021-09-29 01:04:40
restore_command = '/usr/bin/pgbackrest --stanza=mydb_stanza archive-get %f "%p"'
postgresql.conf;
# - Archiving -
archive_mode = on
archive_command = '/usr/bin/pgbackrest --stanza=mydb_stanza archive-push %p'
Will this operation affect my other clusters since I will perform it on the master server?
Thanks
Laurenz Albe <laurenz.albe@cybertec.at>, 13 Kas 2023 Pzt, 22:05 tarihinde şunu yazdı:
On Mon, 2023-11-13 at 21:00 +0300, Abdullah Ergin wrote:
> 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
>
> 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
В списке pgsql-bugs по дате отправления: