Re: Reliable WAL file shipping over unreliable network - Mailing list pgsql-admin

From Dianne Skoll
Subject Re: Reliable WAL file shipping over unreliable network
Date
Msg-id 20180228145341.0fdf5414@hydrogen.roaringpenguin.com
Whole thread Raw
In response to Re: Reliable WAL file shipping over unreliable network  (Rui DeSousa <rui.desousa@icloud.com>)
List 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 by date:

Previous
From: Nagy László Zsolt
Date:
Subject: Re: Reliable WAL file shipping over unreliable network
Next
From: Laurenz Albe
Date:
Subject: Re: Reliable WAL file shipping over unreliable network