snippetsqlMinor
Postgresql WAL Archiving, How to do it properly?
Viewed 0 times
postgresqlproperlyarchivinghowwal
Problem
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)
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)
Solution
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
link to pgBarman tutorial (pdf)
link to pgBarman site
Context
StackExchange Database Administrators Q#24013, answer score: 4
Revisions (0)
No revisions yet.