Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and not MVCC-safe commands - Mailing list pgsql-general

From Ron Johnson
Subject Re: pg_dump and not MVCC-safe commands
Date
Msg-id CANzqJaBK-2fTYR06rtE3-3fkOcJQYJ0vgAwZD+nFO-95UbjxCg@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump and not MVCC-safe commands  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view
On Mon, May 20, 2024 at 11:54 AM Christophe Pettus <xof@thebuild.com> wrote:


> 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.
 
Single-threaded, and thus dreadfully slow.  I'll stick with PgBackRest.

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: pg_dump and not MVCC-safe commands
Next
From: Laurenz Albe
Date:
Subject: Re: How to update upper-bound of tstzrange ?