galaxyproject
Backup strategy using pg-dump
Have you seen https://github.com/galaxyproject/ansible-postgresql/pull/30 ? I mentioned it on @sj213's PR but I guess it might've been missed.
As far as I can see #30 is about the WAL-archiving backup method; at usegalaxy.eu we have been using plain old DB dumps (using pg_dumpall(1)) ever since we started the site and I prefer sticking with that method for the time being, mainly because I have no practical experience with WAL-archiving. Given the current (and ever growing) size of the database we might one day need to reconsider but for the moment I just wanted to carry our status quo over to the new server instance. I didn't rly intend to push the PR upstream either, that's why I closed my first PR when I realized it had propagated upward. Of course, we should merge the fixes for WAL-archiving from 'galaxyproject' into 'usegalaxy.eu', for possible future use.
and I prefer sticking with that method for the time being
Fair enough!
I'll give this a whirl and merge it. Thanks for upstreaming it though, we definitely appreciate it! A traditional pg_dumpall is still a fantastic option for a lot of smaller servers (and bigger ones too!)