Re: AW: AW: secure deletion of archived logs

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: AW: AW: secure deletion of archived logs
Date: 2019-12-11 15:52:47
Message-ID: 20191211155247.GX6962@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Zwettler Markus (OIZ) (Markus(dot)Zwettler(at)zuerich(dot)ch) wrote:
> > * Zwettler Markus (OIZ) (Markus(dot)Zwettler(at)zuerich(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2019-12-11 16:13:51 Re: Logical Replication of Multiple Schema Versions
Previous Message Zwettler Markus (OIZ) 2019-12-11 15:25:57 AW: AW: secure deletion of archived logs