Miguel Arroz wrote:
> Going a bit off topic, but one quick question: to avoid storing GB of
> WAL files that will probably take a lot of time to reload, how can the
> backup be "reset"? I suspect that it's something like stopping the WAL
> archiving, doing a new base backup, and restart archiving, but I've
> never done it (have been using SQL dumps), so...
Basically, you only need WAL logs from the last time you made a back-up
of your data directory. We do nightly re-rsync of our data directory
and then purge old WAL files that are no longer needed.