The author mentioned using https://www.pgbarman.org for this, with a freelance DBA.
Does anyone else have experience between the two options?
Does anyone else have experience between the two options?
It works by making a full backup at fixed intervals (say weekly) and then "pretending" to be a replica which makes it receive all the changelogs in realtime. (Basically it receives and archives WAL's). This makes point in time recovery possible.
Highly recommended.