On 11 April 2017 at 08:22, James Beedy <jamesbe...@gmail.com> wrote: > Hello, > > Just wondering what the extent of the WAL-E support for the postgresql charm > is, and what is the lifecycle here (if any)? > > 1) What can I expect to happen if I configure the wal-e options in the > postgresql charm?
It should start shipping WAL files and making regular filesystem level backups. > 2) Does WAL-E (if configured) automatically start sending my wal files to > s3, or is there a place where I must intervene with some manual ops to get > the process started? It should. However, S3 is still marked as experimental as I've only been testing with Swift. It also might need the bucket to be created (if so, file a bug as the charm should do this automatically). If you are able to help shake out any kinks here, that would be great and I can remove the experimental warnings. Watching the bucket contents is probably the easiest way to confirm it is working. If you run 'SELECT pg_switch_xlog();' at a psql prompt, you should shortly see a new wal file appear. This is simpler than watching the main postgresql log or /var/lib/postgresql/9.x/main/pg_xlog/. > 3) Can I just set the wal-e configs and expect my database to base backup, > and have wal files start pushing to s3 automatically? Yes. > 4) It seems WAL-E needs to have AWS_REGION set. Can we get support for this > config through the postgresql charm? Yes, certainly. Its a minor update, which I've just pushed out to cs:postgresql I've got a branch nearly done which adds point-in-time recovery actions (using WAL-E), and a few helpers like list-backups. This should allow you to easily make use of the backups and wal archive, for recovering deployments or cloning them. I'm currently experiencing failures with the wal-e snap inside lxd containers (the investigation is ongoing). -- Stuart Bishop <stuart.bis...@canonical.com> -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
