Re: warning message in standby
От
Kevin Grittner
Тема
Re: warning message in standby
Дата
Msg-id
4C29BB320200002500032CCE@gw.wicourts.gov
Ответ на
Re: warning message in standby (Robert Haas)
Список
Дерево обсуждения
warning message in standby Fujii Masao <masao.fujii@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Simon Riggs <simon@2ndQuadrant.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: warning message in standby Simon Riggs <simon@2ndQuadrant.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Bruce Momjian <bruce@momjian.us>
Re: warning message in standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: warning message in standby Bruce Momjian <bruce@momjian.us>
Re: warning message in standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: warning message in standby Magnus Hagander <magnus@hagander.net>
Re: warning message in standby Bruce Momjian <bruce@momjian.us>
Re: warning message in standby Magnus Hagander <magnus@hagander.net>
Re: warning message in standby Bruce Momjian <bruce@momjian.us>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Simon Riggs <simon@2ndQuadrant.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Simon Riggs <simon@2ndQuadrant.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Magnus Hagander <magnus@hagander.net>
Re: warning message in standby "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Simon Riggs <simon@2ndQuadrant.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Dimitri Fontaine <dfontaine@hi-media.com>
Re: warning message in standby Simon Riggs <simon@2ndQuadrant.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Bruce Momjian <bruce@momjian.us>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Tom Lane <tgl@sss.pgh.pa.us>
Re: warning message in standby Josh Berkus <josh@agliodbs.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Fujii Masao <masao.fujii@gmail.com>
Re: warning message in standby Fujii Masao <masao.fujii@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Fujii Masao <masao.fujii@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Greg Stark <gsstark@mit.edu>
Re: warning message in standby Robert Haas <robertmhaas@gmail.com>
Re: warning message in standby Fujii Masao <masao.fujii@gmail.com>
Re: warning message in standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: warning message in standby Fujii Masao <masao.fujii@gmail.com>
Robert Haas wrote: > ...with this patch, following the above, you get: > > FATAL: invalid record in WAL stream > HINT: Take a new base backup, or remove recovery.conf and restart > in read-write mode. > LOG: startup process (PID 6126) exited with exit code 1 > LOG: terminating any other active server processes If someone is sloppy about how they copy the WAL files around, they could temporarily have a truncated file. If we want to be tolerant of straight file copies, without a temporary name or location with a move on completion, we would need some kind of retry or timeout. It appears that you have this hard-coded to five retries. I'm not saying this is a bad setting, but I always wonder about hard-coded magic numbers like this. What's the delay between retries? How did you arrive at five as the magic number? -Kevin
В списке pgsql-hackers по дате отправления