Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing
В списке pgsql-hackers по дате отправления:
| От | Mark Kirkwood |
|---|---|
| Тема | Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing |
| Дата | |
| Msg-id | 4D2395F7.8060507@catalyst.net.nz обсуждение исходный текст |
| Ответ на | Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing (Devrim GÜNDÜZ <devrim@gunduz.org>) |
| Список | pgsql-hackers |
On 05/01/11 04:43, Devrim GÜNDÜZ wrote: > On Fri, 2010-12-31 at 11:11 +1300, Mark Kirkwood wrote: >> I note that this uninitialized pages with standbys has cropped up from >> time to time - I wonder if in most/all the cases folk were using >> Pitrtools? > I deployed Pitrtools a lot when I was working for CMD, and I haven't > seen any issues with that. It is just a wrapper, nothing else... > > Note that if you perform the backup step when the system is quiet then there is typically no problem with the standby - it is only when the backup coincides with any level of activity that you can elicit the previously mentioned problems. Obviously the case I have included in the first mail shows up the problem immediately, but in fact it is reasonably hard to trigger and I spent quite a while getting to the state of being able to trigger the uninitialized pages on demand. While Pitrtools it is a wrapper, the use of "--exclude=backup_label" is incorrect and needs to be removed. regards Mark
В списке pgsql-hackers по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера