[LRUG] Backing up Postgres

Mark Woods mwoods at online.ie
Thu Jan 29 04:16:39 PST 2015


Hi Andrew,

Have you had a look at the WAL-E project from Heroku?
https://github.com/wal-e/wal-e

It's been on my list of things to look into but I've never gotten around to
it. Sounds like it might be just what you need tho :-)

Mark

On 29 January 2015 at 09:59, Tim Cowlishaw <tim at timcowlishaw.co.uk> 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
>
>
>
> On 29 January 2015 at 09:52, Andrew Stewart <boss at airbladesoftware.com>
> wrote:
> > 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
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20150129/3faa7da4/attachment-0001.html>


More information about the Chat mailing list