current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
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's 100% free, no registration required.
up vote 3 down vote favorite

We are looking for a solution for the following problem:

We have set up streaming replication so we have a master DB and a slave DB, we want to have basebackups and WAL files sent to our S3 storage periodically.

I have looked at:

  • WAL-e which seemed to suit us perfectly, except that it does not support multiple tablespaces, which is a deal breaker.

  • Barman supports this but does not support S3, which is also a deal breaker, although it may be possible with pre- and post-backup hooks which I am currently looking into.

  • OmniPITR doesn't support S3 either.

Is there an application that does all these things already, or will I have to do some scripting?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

After a lot of research, I ended up using Barman and a custom post-backup script, it works very good!

share|improve this answer
1  
I have been looking to dump barman backups into S3 also. Care to share the post-backup script? Thanks, Colin –  user31197 Dec 3 '13 at 3:18
    
We've never gotten around to creating the script, but it's pretty straightforward, you can just read the ENV vars to get the file information you need to upload to S3 :) Here are the docs docs.pgbarman.org - Look in the bottom for the hooks –  Mackwerk Dec 3 '13 at 13:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.