Horton

Re: pg_dump and not MVCC-safe commands

Christophe Pettus <xof@thebuild.com>

View thread View on postgr.es
From: Christophe Pettus <xof@thebuild.com>
To: PetSerAl <petseral@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Guillaume Lelarge <guillaume@lelarge.info>, pgsql-general@lists.postgresql.org
Date: 2024-05-20T15:53:58Z
Lists: pgsql-general 

> On May 20, 2024, at 08:49, PetSerAl <petseral@gmail.com> 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.