[LRUG] Backing up Postgres

[Tim Cowlishaw]

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

Cheers,

Tim,


On 29 January 2015 at 09:42, Andrew Stewart <boss at airbladesoftware.com> wrote:
> Hello LRUG!
>
> I'm just starting a small project and thought I'd take the opportunity to use postgres for the first time.  What do people use for backing up postgres?
>
> My current backup policy with mysql is a full dump nightly, copied to S3, and the binlogs copied to S3 every 15min.  I'm aiming for that as a minimum with postgres.
>
> "Mirroring", for want of a better term, to another postgres instance elsewhere for availability would be nice; but first and foremost I want to store backups on S3 so I can, for example, load up the database as it was 3 days ago to recover some data a customer accidentally deleted.
>
> From googling around it seems barman and wal-e are the main choices.  I also looked at the backup gem but it only seems to handle full dumps, not incremental transactions.
>
> Would anyone like to make recommendations?
>
> Many thanks in advance,
>
> Andy Stewart
>
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org