search

galaxyproject / ansible-postgresql

An Ansible role for managing a PostgreSQL server
https://galaxy.ansible.com/galaxyproject/postgresql
122 stars 58 forks source link

Backup strategy using pg-dump #33

Open gmauro opened 2 years ago

gmauro commented 2 years ago

from @sj213

hexylena commented 2 years ago

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.

gmauro commented 2 years ago

I am pinging Sj. Let's wait for a comment from him

sj213 commented 2 years ago

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.

hexylena commented 2 years ago

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!)