Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file

Поиск
Список
Период
Сортировка
Искать
От
David Steele
Тема
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file
Дата
Msg-id
ae33b33e-1581-27ac-10bf-b4fab7c3c418@pgmasters.net
Ответ на
Список
Дерево обсуждения
Postgres restart in the middle of exclusive backup and the presence of backup_label file SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Michael Paquier <michael@paquier.xyz>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Michael Paquier <michael@paquier.xyz>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Laurenz Albe <laurenz.albe@cybertec.at>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Andrew Dunstan <andrew@dunslane.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Euler Taveira" <euler@eulerto.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Ashutosh Sharma <ashu.coek88@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Ashutosh Sharma <ashu.coek88@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Magnus Hagander <magnus@hagander.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Laurenz Albe <laurenz.albe@cybertec.at>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Martín Marqués <martin.marques@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Stephen Frost <sfrost@snowman.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Michael Paquier <michael@paquier.xyz>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Magnus Hagander <magnus@hagander.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Chapman Flack <chap@anastigmatix.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Nathan Bossart <nathandbossart@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Michael Paquier <michael@paquier.xyz>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file David Steele <david@pgmasters.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Andrew Dunstan <andrew@dunslane.net>
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file "Bossart, Nathan" <bossartn@amazon.com>
On 1/6/22 20:20, Euler Taveira wrote:
> On Thu, Jan 6, 2022, at 9:48 PM, Bossart, Nathan wrote:
>> After a quick glance, I didn't see an easy way to hold a session open
>> while the test does other things.  If there isn't one, modifying
>> backup_fs_hot() to work with non-exclusive mode might be more trouble
>> than it is worth.
 >
> You can use IPC::Run to start psql in background. See examples in
> src/test/recovery.

I don't think updating backup_fs_hot() is worth it here.

backup_fs_cold() works just fine for this case and if there is a need 
for backup_fs_hot() in the future it can be implemented as needed.

Regards,
-David


В списке pgsql-hackers по дате отправления
От: Euler Taveira
Дата:
От: Juan José Santamaría Flecha
Дата:
FAQ