public inbox for [email protected]  
help / color / mirror / Atom feed
From: Christophe Pettus <[email protected]>
To: PetSerAl <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Guillaume Lelarge <[email protected]>
Cc: [email protected]
Subject: Re: pg_dump and not MVCC-safe commands
Date: Mon, 20 May 2024 08:53:58 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKygsHS2rKkzRFh-SygCjR-TGLhpbWxci4Ms5BxoJ9KJ5DXhxA@mail.gmail.com>
References: <CAKygsHQHhd4rzYcNCd8OJMH46saT1E+9+5MT2CgOCGgf_yaQAw@mail.gmail.com>
	<CAECtzeUQ3hJYPM6k6_XqZLq=DygHbQ3+5YQLrv-ngcht2rQjQg@mail.gmail.com>
	<CAKygsHRBRUhjGAQtqnbYPaXxJPvN2J49yS4ceee62iVG_jcuQQ@mail.gmail.com>
	<[email protected]>
	<CAKygsHS2rKkzRFh-SygCjR-TGLhpbWxci4Ms5BxoJ9KJ5DXhxA@mail.gmail.com>



> On May 20, 2024, at 08:49, PetSerAl <[email protected]> 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.





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], [email protected], [email protected], [email protected]
  Subject: Re: pg_dump and not MVCC-safe commands
  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