I setup 2 postgres database servers with the new synchronous replication feature to get high availability. Next step is planning a backup strategy. I do not have enough storage to achieve the WALs for more than 5 days. I’m thinking about doing the following: Make a base backup every night and delete WALs < 5 days. Is this the correct backup strategy for my requirements?

link|improve this question

80% accept rate
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.