Re: AW: AW: secure deletion of archived logs - Mailing list pgsql-general

From Stephen Frost
Subject Re: AW: AW: secure deletion of archived logs
Date
Msg-id 20191211155247.GX6962@tamriel.snowman.net
Whole thread Raw
In response to AW: AW: secure deletion of archived logs  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
List pgsql-general
Greetings,

* Zwettler Markus (OIZ) (Markus.Zwettler@zuerich.ch) wrote:
> > * Zwettler Markus (OIZ) (Markus.Zwettler@zuerich.ch) wrote:
> > > We use "rsync" on XFS with "wsync" mount mode. I think this should do the job?
> >
> > No, that just makes sure that namespace operations are executed synchronously,
> > that doesn't provide any guarantee that the data has actually been written out and
> > sync'd.
>
> What else? "rsync" on XFS mounted wsync + execute "sync" afterwards?

I don't really agree with it, but pitrery uses 'dd' with 'conv=fsync'.
As far as I know, there isn't a way to force 'rsync' to run an fsync()
at the end, and executing a 'sync' afterwards, while it should work,
seems likely to cause you a lot more troubles..

In the end, I wouldn't suggest trying to hack up your own scripts to do
any of this- use one of the existing tools.  It's a lot more complicated
than I think you're appreciating.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: "Zwettler Markus (OIZ)"
Date:
Subject: AW: AW: secure deletion of archived logs
Next
From: Peter Eisentraut
Date:
Subject: Re: Logical Replication of Multiple Schema Versions