Clean shutdown and warm standby
От
Guillaume Smet
Тема
Clean shutdown and warm standby
Дата
Msg-id
1d4e0c10904081211p2c0f1cdepe620c11d1271ceb2@mail.gmail.com
Список
Дерево обсуждения
Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Fujii Masao <masao.fujii@gmail.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Fujii Masao <masao.fujii@gmail.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Fujii Masao <masao.fujii@gmail.com>
Re: Clean shutdown and warm standby Andreas Pflug <pgadmin@pse-consulting.de>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Tom Lane <tgl@sss.pgh.pa.us>
Re: Clean shutdown and warm standby Andreas Pflug <pgadmin@pse-consulting.de>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Tom Lane <tgl@sss.pgh.pa.us>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Robert Haas <robertmhaas@gmail.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Euler Taveira de Oliveira <euler@timbira.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Simon Riggs <simon@2ndQuadrant.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Andreas Pflug <pgadmin@pse-consulting.de>
Re: Clean shutdown and warm standby Fujii Masao <masao.fujii@gmail.com>
Re: Clean shutdown and warm standby Guillaume Smet <guillaume.smet@gmail.com>
Re: Clean shutdown and warm standby Fujii Masao <masao.fujii@gmail.com>
Hi, Following the discussion here http://archives.postgresql.org/message-id/49D9E986.8010604@pse-consulting.de , I wrote a small patch which rotates the last XLog file on shutdown so that the archive command is also executed for this file and we are sure we have all the useful XLog files when we perform a clean shutdown of master + switch to the failover server. This rotation is done only if the archive mode is active and an archive command is set. It's currently really difficult to switch easily (ie without copying the file manually) to the failover server without any data loss. Is there any problem I've missed? Could we consider the inclusion of such a patch or something similar? Comments? Regards, -- Guillaume
В списке pgsql-hackers по дате отправления