Re: Does pg_start_backup changes how Postgres writes data?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Thorsten Schöning <tschoening(at)am-soft(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Does pg_start_backup changes how Postgres writes data?
Date: 2019-07-08 14:52:26
Message-ID: 20190708145226.GZ29202@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

* Thorsten Schöning (tschoening(at)am-soft(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thorsten Schöning 2019-07-08 16:38:25 Does anyone backup directly on Synology NAS using Barman or similar?
Previous Message Stephen Frost 2019-07-08 14:49:11 Re: When it's really necessary to enable WAR archiving in case of low level backups?