Following on from this post...
I have a backup generated by pg_basebackup regularly, I would update it through the WAL files.
What is the best way to do it?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
See the documentation on point-in-time recovery and WAL archiving for how to manage this.
archive_mode = onin master
archive_commandin master that stores the WAL archives in a location accessible to the replica
recovery.confon the replica that sets a
restore_commandto fetch the archived WAL. You may also want to set a
recovery_target_timeif you wish to stop replay at a certain point.
You may find tools like pgbarman useful as well.