public inbox for [email protected]  

help / color / mirror / Atom feed

From: raphi <[email protected]>
To: [email protected]
Subject: Re: Simulate a PITR in postgresql 16
Date: Tue, 1 Jul 2025 06:35:37 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaBNufPWAhkNXHBHy2hySOKhPPcYy1sZi=ZHFp-D9j-o5g@mail.gmail.com>
References: <CAB_Px=yO5y-6NcZjyDxLUGb4m6VX=-UXhSiuB7eLXp10eRfdQw@mail.gmail.com>
	<CANzqJaBNufPWAhkNXHBHy2hySOKhPPcYy1sZi=ZHFp-D9j-o5g@mail.gmail.com>



Am 30.06.2025 um 21:45 schrieb Ron Johnson:
> Using PgBackRest might be more convenient, since it handles everything 
> you need, is multithreaded, never removes too many wal files, 
> compresses files if you want and also encrypts them if you want.
>
I agree, with pgBackRest it's basically: pgbackrest --stanza=demo 
--delta --type=time "--target=2025-05-05 15:37:03.157376+00" 
--target-action=promote restore

and you are done. It will also restore configure files and you can also 
selectively restore only one DB in the cluster if you want to speed up 
things. Works very well with S3 too and is very easy to integrate in an 
ansible playbook to have a generic way to do PITRs.

Check out the official user guide: https://pgbackrest.org/user-guide.html

have fun
raphi

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Simulate a PITR in postgresql 16
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox