Re: warning message in standby

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: warning message in standby
Дата
Msg-id
4C29BB320200002500032CCE@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Robert Haas
Дата:
Сообщение: Re: Keepalives win32
От: Robert Haas
Дата:
Сообщение: Re: keepalives on MacOS X
FAQ