Remove Deprecated Exclusive Backup Mode

Поиск
Список
Период
Сортировка
Искать
От
David Steele
Тема
Remove Deprecated Exclusive Backup Mode
Дата
Msg-id
ac7339ca-3718-3c93-929f-99e725d1172c@pgmasters.net
Список
Дерево обсуждения
Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Simon Riggs <simon@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andreas Karlsson <andreas@proxel.se>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andreas Karlsson <andreas@proxel.se>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao <masao.fujii@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao <masao.fujii@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Peter Geoghegan <pg@bowt.ie>
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao <masao.fujii@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao <masao.fujii@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe <laurenz.albe@cybertec.at>
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao <masao.fujii@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost <sfrost@snowman.net>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Bruce Momjian <bruce@momjian.us>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Robert Haas <robertmhaas@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander <magnus@hagander.net>
Re: Remove Deprecated Exclusive Backup Mode Andres Freund <andres@anarazel.de>
Re: Remove Deprecated Exclusive Backup Mode Chapman Flack <chap@anastigmatix.net>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Martín Marqués <martin@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier <michael@paquier.xyz>
Re: Remove Deprecated Exclusive Backup Mode "David G. Johnston" <david.g.johnston@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Martín Marqués <martin@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao <masao.fujii@gmail.com>
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus <xof@thebuild.com>
Re: Remove Deprecated Exclusive Backup Mode Simon Riggs <simon@2ndquadrant.com>
Re: Remove Deprecated Exclusive Backup Mode David Steele <david@pgmasters.net>
Hackers,

I propose we remove the deprecated exclusive backup mode of 
pg_start_backup()/pg_stop_backup() for Postgres 12.

The exclusive backup mode has a serious known issue.  If Postgres 
terminates ungracefully during a backup (due to hardware, kernel, 
Postgres issues, etc.) then Postgres may refuse to restart.

The reason is that the backup_label file will usually reference a 
checkpoint LSN that is older than the WAL available in pg_wal.  Postgres 
does emit a helpful error message while PANIC'ing but that's cold 
comfort to an admin who must manually intervene to get their cluster 
operational again.

The deprecated exclusive mode promises to make a difficult problem 
simple but doesn't live up to that promise. That's why it was replaced 
externally in 9.6 and why pg_basebackup has not used exclusive backups 
since it was introduced in 9.2.

Non-exclusive backups have been available since 9.6 and several 
third-party solutions support this mode, in addition to pg_basebackup.

The recently introduced recovery changes will break current automated 
solutions so this seems like a good opportunity to make improvements on 
the backup side as well.

I'll submit a patch for the 2019-01 commitfest.

Regards,
-- 
-David
david@pgmasters.net

В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
Сообщение: Re: pg11.1 jit segv
От: Michael Paquier
Дата:
FAQ