| From: | jian xu <jamesxu(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | a question about Point-in-Time Recovery (PITR) |
| Date: | 2022-08-11 22:15:27 |
| Message-ID: | BL0PR02MB4561D19C498EDD1CF62962A0A1649@BL0PR02MB4561.namprd02.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I am creating an automation script which can do PITR restore. For example if users specify the timestamp, I can retore the db to that point. All backup files are on other place, the restore procedure includes
1. Download full backup file generated from pg_basebackup
2. Download all wal archive files generated since the full backup file to the timestamp users specified.
However, the problem is how I can read the begin and end transaction timestamp in each wal archive file?
Without knowing the transaction timestamp, I am not able know which wal archive file I need to download.
I tried pg_waldump, but it doesn’t have transaction timestamp.
Does anyone know the solution? Thanks!
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2022-08-12 05:08:20 | Re: a question about Point-in-Time Recovery (PITR) |
| Previous Message | Johannes Truschnigg | 2022-08-11 15:22:36 | Re: postgresql definitive list of network resources used/needed? |