Multiple PostgreSQL Backups in one plan

[mregni]

Description

It would be nice if instead of only 1 plugin run of each type we can run multiple of the same time. For example backup/restore 3 postgresql databases. Currently the plugin dropdown in the plan creator page only let's you select 1 database.

Use Case

I'm trying to backup my whole docker volumes folder in 1 backup run. Meaning I need to backup 6 PostgreSQL databases. This is not currently possible because we can only select 1 plugin of each type.

Alternatives Considered

Work around is that I would have to create a plan for each stack i'm running but that would mean over 12 plans so I was hoping of this would become an option in the future as well to just select multiple.

[marcpope]

You need to create a user that has access to all the databases. Then it will back them all up in 1 shot. Unless I am not understanding correctly.

[mregni]

Well, what i'm trying to do is backup my whole docker volumes folder in one archive. i'm running like 5 different PostgreSQL containers and each one needs to run the backups plugin. In the screenshot you can see I added already 3 of them but then in the plan config I can only select 1 database to backup. Problem is that the databases are on different host (different containers) so one plugin config does not cover it.

Plugin config:

Plan config edit screen

Is this something that should not be done (solution would also be that I create a plan for each docker stack I'm running but that would require 13 plans instead of one). Doable, but I wanted to check first if there is a better solution for my problem.

[theborg72]

you have to make a plan for each database. but you can set them up with 10min between and it will work in the same run. just with a few minutes between