Note:-Might be the question sounds too broad. But, I believe ,it's very good platform(stackexchange) and I can get advice from worldwide expert DBA here. Since, I'm not able to make decision or choose the right option.
Que: I'm new to postgres and need to make PITR solution for our continuously growing database. Need to plan incremental backup solution as well since database size is increasing at rapid speed. If we can't afford to lose any data and also need to have PITR, which one should be best solution:
Have an standby and in case of any failure/disaster take full backup(pg_basebackup) of the standby db cluster and do PITR from that backup(recovery.conf -time).
continuously taking incremental backups+log backups.
use any 3rd party tool to take incremental as well as log backup of postgres db.
Please let me know which option should be better or any other option if anybody has then suggest that option as well.Also, let me know if any performance impact can happen with a database in case we have multiple standby for that database or any negative impact of keeping a standby.
-Thanks in advance!