Postgres Pro
Downloads
Home   >   mailing lists

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

From Christophe Pettus
Subject Re: pg_dump and not MVCC-safe commands
Date
Msg-id DD46659C-6F79-465A-BD94-C69AEA49622C@thebuild.com
Whole thread Raw
In response to Re: pg_dump and not MVCC-safe commands  (PetSerAl <petseral@gmail.com>)
Responses Re: pg_dump and not MVCC-safe commands
List pgsql-general
Tree view 

> 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
concernedabout restoring to a different processor architecture, pg_basebackup is a superior solution to pg_dump.

pgsql-general by date:

Previous
From: PetSerAl
Date:
Subject: Re: pg_dump and not MVCC-safe commands
Next
From: Ron Johnson
Date:
Subject: Re: pg_dump and not MVCC-safe commands