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
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? |