| From: | jian xu <jamesxu(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | question about database recover proceduers |
| Date: | 2021-01-04 17:54:47 |
| Message-ID: | BL0PR02MB456116E56AE7851683FB1FBBA1D20@BL0PR02MB4561.namprd02.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
my pg version is 11, I use pg_basebackup+wal archive files to backup the database. I tried to restore the db to the latest wal archive file.
I restored the pg_basebackup file first, restored wal archive files to the archive folder, and created the recovery.conf file, which only has the "restore_command" in it.
when I started up the pg service, it didn't recover any wal archive files from archive folder with restore_command.
may I know how pg determines which next wal archive file needs to be fetched from archive folder?
how to troubleshooting the recover procedure, and how to check if restore_command is called?
thanks,
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian xu | 2021-01-04 19:10:15 | Re: question about database recover proceduers |
| Previous Message | Amine Tengilimoglu | 2021-01-04 10:19:45 | pg_rewind restore_command issue in PG12 |