secure deletion of archived logs

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: secure deletion of archived logs
Date: 2019-12-04 10:30:49
Message-ID: 06d9534503de4b14a7f35a1d08dcc4c6@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

with Oracle we use "backup archivelog all delete all input".
this is a kind of atomic transaction.
everything backuped for sure is deleted.

with Postgres we archive to a local host directory
we do a Networker backup of this directory afterwards and delete the archived logs
but this is not an atomic transaction
so there is a small risk that something gets deleted which is not backuped

how to you prevent this?

Is there any backup tool which can do backups analogous Oracle?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2019-12-04 13:08:30 Re: upgrade and migrate
Previous Message Michael Paquier 2019-12-04 08:08:27 Re: upgrade and migrate