Re: Reliable WAL file shipping over unreliable network

Поиск
Список
Период
Сортировка
От Dianne Skoll
Тема Re: Reliable WAL file shipping over unreliable network
Дата
Msg-id 20180228145341.0fdf5414@hydrogen.roaringpenguin.com
обсуждение исходный текст
Ответ на Re: Reliable WAL file shipping over unreliable network  (Rui DeSousa <rui.desousa@icloud.com>)
Список pgsql-admin
On Wed, 28 Feb 2018 13:49:33 -0500
Rui DeSousa <rui.desousa@icloud.com> wrote:

> Really? I think you really need to think about it.  You are dealing
> with a race condition.

You are not correct.

1) rsync copies the source file to a temporary file on the destination.

2) If and only if step (1) is successful, rsync renames the temporary
file to the final filename.

3) If and only if step (2) is successful, rsync sets the timestamp on
the destination file to match that of the source file, assuming the
--archive or similar command-line option was given.

There is no possible sequence of events that could give you a destination
file with the same size and timestamp as the source file and yet be
incorrect (just so long as the source file has stayed the same.)

Regards,

Dianne.


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

Предыдущее
От: Nagy László Zsolt
Дата:
Сообщение: Re: Reliable WAL file shipping over unreliable network
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Reliable WAL file shipping over unreliable network