Re: Reliable WAL file shipping over unreliable network

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: Reliable WAL file shipping over unreliable network
Дата
Msg-id 33220469-5BB2-4A40-8F56-8F4F392C95B3@icloud.com
обсуждение исходный текст
Ответ на Re: Reliable WAL file shipping over unreliable network  (Dianne Skoll <dfs@roaringpenguin.com>)
Ответы Re: Reliable WAL file shipping over unreliable network
Re: Reliable WAL file shipping over unreliable network
Re: Reliable WAL file shipping over unreliable network
Список pgsql-admin
Really? I think you really need to think about it.  You are dealing with a race condition.

While your though process might seem to work and it will appear to work; however in the end it will fail — like I said;
I’veseen it fail first hand. 

You are dealing with a race condition involving filesystem metadata.  If you choose to not use “-c” option then; all I
cantell you is that you have been warned. 


> On Feb 28, 2018, at 1:26 PM, Dianne Skoll <dfs@roaringpenguin.com> wrote:
>
> On Wed, 28 Feb 2018 13:15:48 -0500
> Rui DeSousa <rui.desousa@icloud.com> wrote:
>
>> Sure it does… what happens if the archive server gets full? There is
>> a situation that can fool rsync into thinking it was successfully
>> transferred as rsync only relies on filesystem metadata to verify the
>> file is different.
>
> That's incorrect.  The original transfer will fail and rsync will remove
> the temporary file.  It doesn't rename the file to the final destination
> until and unless the transfer is successful.
>
> "-c" is only used for files that might change multiple times per second;
> since most file systems have only 1-second granualarity in file timestamps,
> you can't rely on a file being identical if the size and timestamps are the
> same.
>
>> The “-c” option will validate the file using a checksum and not just
>> rely on just filesystem metadata.
>
> That's incorrect.  "-c" applies only when rsync looks at existing files
> to see if they differ.  It does not affect what happens when rsync actually
> copies the file data over; that's always verified with a checksum.
>
> Regards,
>
> Dianne.
>



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

Предыдущее
От: Keith
Дата:
Сообщение: Re: Separate log for a specfic database
Следующее
От: Dianne Skoll
Дата:
Сообщение: Re: Reliable WAL file shipping over unreliable network