I would like having a workflow for backing up Postgresql databases and restore a subset to another Postgresql client and instance by using DumpBasedBackupSet.
So I started editing a clone of the “Demo_FileSystemBackupRestore”-workflow.
I was able to change the “Backup” and “Restore” task to Postgres in ‘dataAgent’ and giving the instances.
What I wonder: the field “instance” is of type String - isn’t there a way to fill this field automatically with all the instances of a given client? For we have Postgresql-clusters with several instances running …
But where I am definitely stuck is at selecting the database to restore, neither Backup nor Restore include a field for specifying subsets of backuped data.
Any hint to put me on the right track is very welcomed.