[LRUG] Backing up Postgres

[Jinn Ko]

On 29/01/2015 09:59, Tim Cowlishaw wrote:
> Aha, sorry - didn't read your message closely enough! In that case,
> you might get some mileage out of backing up the posgres data dir at
> the filesystem level periodically, and duplicating the write-ahead log
> to replay any transactions since the last FS backup? This approach is
> described here, I'm afraid I can't claim to have any first-hand
> experience of it though:
> http://www.postgresql.org/docs/9.2/static/continuous-archiving.html

This is also the foundation of mirroring, or replication, with postgres.

If you go down this path have a look at the repmgr[1] project.  It helps
immensely with replication and is maintained by the postgres folks.

[1] http://www.repmgr.org/