On Mon, May 20, 2024 at 11:54 AM Christophe Pettus <xof@xxxxxxxxxxxx> wrote:
> On May 20, 2024, at 08:49, PetSerAl <petseral@xxxxxxxxx> wrote:
> Basically, you need application cooperation to make
> consistent live database backup.
If it is critical that you have a completely consistent backup as of a particular point in time, and you are not concerned about restoring to a different processor architecture, pg_basebackup is a superior solution to pg_dump.
Single-threaded, and thus dreadfully slow. I'll stick with PgBackRest.