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 по дате отправления