Postgres backup PITR strategies
There are many possibities!

PITR vs STANDBY

PITR &amp; Standby are complementary solutions:


Standby is interesting to recover from:


physical problem: server crash, datacenter unavailabity
and offer quick switchover procedures

PITR will help you in case of data damage:


  If someone performs an operation that damages your data (DROP TABLE , UPDATE with a wrong WHERE clause ...). Then, you will be able to restore your database before this operation.



Implementation

PITR implementation

There are many tools that can help you to perform PITR, I have already used:


barman
wal-e


And there are also:


PgBackREst
...


This article lists and compares several LINUX backup tools.

My bast advices, regarding PITR implementation, are:


Use existing tools (and don't try to write a new one)
Test your backups
Monitor your backups (and see the monitoring point fails)!


standby implementation

As it's native, there's no need for additional tooling on the implementation-side.

But:


monitor it correctly
Write and test your switch procedures (and re-test them at regular intervals, to prevent that the procedure is not accurate when needed!)