Re: Does pg_start_backup changes how Postgres writes data? - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Does pg_start_backup changes how Postgres writes data?
Date
Msg-id 20190708145226.GZ29202@tamriel.snowman.net
Whole thread Raw
In response to Does pg_start_backup changes how Postgres writes data?  (Thorsten Schöning <tschoening@am-soft.de>)
List pgsql-admin
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

Attachment

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: When it's really necessary to enable WAR archiving in case oflow level backups?
Next
From: Thorsten Schöning
Date:
Subject: Does anyone backup directly on Synology NAS using Barman or similar?