MySQL/PostgreSQL backups

[adeleglise]

Hi, first of all, thanks for the role it's really helpful.

I saw that you implemented before/after backups commands, but in borgmatic databases dump hooks are native. Is it possible to use them with your role ? It would a shame to use this role and have to deploy a jinja template of the config file just for those commands.

Thanks.

[m3nu]

I didn't look into Borgmatic's hooks yet. Great if they cover the majority of use cases.

We probably still want the before/after hooks to run custom commands that Borgmatic may not support yet.

I'm still open to adding options for Borgmatic hooks and improving the docs in this regards.

[adeleglise]

I'm still open to adding options for Borgmatic hooks and improving the docs in this regards.

That would be great !

[sNud]

Hi,

i have recently discovered your role. Thank you for your great work.

The integration of the native borgmatic database dump hooks would be very helpful for me.

Can you give us a status if it can be integrated? What are the current alternatives? Should I use before/after hooks or is there a way to use the role and still provide a custom config or other parameters?

Thanks.

[m3nu]

Can be added. Just edit the Borgmatic config j2 template.

For the param names, we could use this: borgmatic_dump_[mysql|postgres|mariadb]

Possible values

• empty (default) does nothing
• all dump all DBs, as per Borgmatic docs
• db1, db2 (dump specific DBs, not sure how Borgmatic separates them)

[cl1ent]

Hey,

do you have an update here? If not, would you @m3nu want to create a PR or should I make one? I'd also be happy to use the PostgreSQL dump feature and not rely on before hooks.

[m3nu]

Feel free to contribute a PR, @cl1ent . Bonus points if it's flexible enough to use it with other kinds of hooks.