| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: a question about Point-in-Time Recovery (PITR) |
| Date: | 2022-08-12 05:08:20 |
| Message-ID: | 0834f1ba-c66f-5c5a-c55a-f02fde5e20c7@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 8/11/22 17:15, jian xu wrote:
>
> 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!
>
If you run Linux, then pgBackRest is (almost certainly) what you want.
Download it from https://pgbackrest.org/ or get it from your distro's
https://www.postgresql.org/download/ repository.
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart Watson | 2022-08-15 14:24:41 | logical replication help |
| Previous Message | jian xu | 2022-08-11 22:15:27 | a question about Point-in-Time Recovery (PITR) |