Add ability to create replica via multiple threads

[bmironov]

Hello,

This is more of a question than actual issue of the plugin.

Is there a way to use ability of pgBackRest to create replica via multiple threads? It seems that cnpg uses pg_basebackup for this purpose which is quite slow by design (as process is single threaded). On Virtual Machines with big databases I would use ability of pgBackRest to properly create replica:

• utilize latest backup via multiple threads
• bring all necessary WALs from archive and primary again via multiple threads
• create replication slot and finally sync DBs

Above steps save a lot of time due to parallelism, especially for big DB's.

Perhaps, question lies in CNPG-I API. If so, should we raise this request with cnpg as well?

Best regards,
Boris

[Agalin]

Replicas - I don't think so. This is handled outside of the plugin (unless plugin API has been extended in recent months). Standby clusters - already possible but I think only via restore from external backup.

[bmironov]

Yep. I know that there are some obvious restrictions on CNPG-I side of things. At least, please raise this possibility with them, so there might be a distant chance that this kind of functionality would make its way into future versions of the interface with backup plugins.

Thanks a million