[LRUG] Backing up Postgres

Andrew Stewart boss at airbladesoftware.com
Thu Jan 29 01:52:32 PST 2015


On 29 Jan 2015, at 10:50, Tim Cowlishaw <tim at timcowlishaw.co.uk> wrote:
> Aha! I have a script for exactly this: it's nothing fancy, but it will
> take a backup, compress it, and rotate the last n backups. Could
> trivially be extended to send them to S3 too:
> 
> https://gist.github.com/timcowlishaw/d8734bbaa4c9e85a8a24

Thanks!  But as far as I can tell it doesn't do incremental backups.  I wouldn't want to hit the database every few minutes for a full dump...

Cheers,
Andy


More information about the Chat mailing list