Basically I have one (for now) mission critical postgresql database that I will need up to the minute recovery for, I've never implemented a working WAL archival before so I would like to know what is the best way to do this.
The machine we are going to backup to is remote, and we have ssh keys set up, so I was going to have the WAL's rsync'd over. Is that wise with that archive_command option?
A Step by Step guide with examples on how to set these things up would be amazing as I couldn't find one I understood (I'm not a DBA)
Best Answer
Using pgBarman, This was really easy as it walked me through it all, plus it's open source! I stumbed upon this while googling link to pgBarman tutorial (pdf) link to pgBarman site