From: Stephen Frost <sfrost@snowman.net>
To: Thorsten Schöning <tschoening@am-soft.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Does pg_start_backup changes how Postgres writes data?
Date: Mon, 8 Jul 2019 10:52:26 -0400
Message-ID: <20190708145226.GZ29202@tamriel.snowman.net> (raw)
In-Reply-To: <171339952.20190708105025@am-soft.de>
References: <171339952.20190708105025@am-soft.de>
Greetings,
* Thorsten Schöning (tschoening@am-soft.de) wrote:
> From what I understand from reading the docs and multiple other
> sources, I have a different opinion: The only thing pg_start_backup
> changes regarding writes in the data directory of Postgres is that a
> checkpoint is done as part of starting the backup, even if no
> checkpoint would be needed currently otherwise. After that is done,
Magnus' already replied to most of this, but I wanted to point out that
you can control if pg_start_backup forces an immediate checkpoint or if
it waits for the checkpoint to complete naturally.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
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: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, tschoening@am-soft.de
Subject: Re: Does pg_start_backup changes how Postgres writes data?
In-Reply-To: <20190708145226.GZ29202@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox