I have set up Postgres conintuous backup by making a base backup and archiving WAL files, as specified here.
Our database is very low use (but very important to back up) so we produce a new WAL file every couple of days. I plan to force it to generate WAL files every hour, the questions is what criteria I should consider in setting the frequency of base backups? once per day, month, 3 months? what are the benefits / problems of long vs short intervals between base backups?