Re: Hot Backup with rsync fails at pg_clog if under load

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Hot Backup with rsync fails at pg_clog if under load
Дата
Msg-id CABUevEzH3q=q8XMZ+murfoyE=pvWko6UqO9t8JkfqVNJ2QpVjg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hot Backup with rsync fails at pg_clog if under load  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Hot Backup with rsync fails at pg_clog if under load
Re: Hot Backup with rsync fails at pg_clog if under load
Список pgsql-hackers
<p><br /> On Sep 23, 2011 5:59 PM, "Alvaro Herrera" <<a
href="mailto:alvherre@commandprompt.com">alvherre@commandprompt.com</a>>wrote:<br /> ><br /> ><br /> >
Excerptsfrom Linas Virbalas's message of vie sep 23 09:47:20 -0300 2011:<br /> > > On 9/23/11 12:05 PM, "Heikki
Linnakangas"<br/> > > <<a
href="mailto:heikki.linnakangas@enterprisedb.com">heikki.linnakangas@enterprisedb.com</a>>wrote:<br /> ><br />
>> But on the standby its size is the old one (thus, it seems, that the size<br /> > > changed after the
rsynctransfer and before the pg_stop_backup() was<br /> > > called):<br /> > ><br /> > > ls -l
pg_clog/<br/> > > total 8<br /> > > -rw------- 1 postgres postgres 8192 Sep 23 14:31 0000<br /> ><br />
>Sounds like rsync is caching the file size at the start of the run, and<br /> > then copying that many bytes,
ignoringthe growth that occurred after it<br /> > started.<br /> ><p>That pretty much matches what Daniel does
whenhe got the same failure case. <p>Is this not allowed? Shouldn't wal replay fix this? <p>/Magnus  

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Hot Backup with rsync fails at pg_clog if under load
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Hot Backup with rsync fails at pg_clog if under load