We are currently testing Postgres backup and restore in the context of the new Patroni cluster support in CV 11.36.
While testing we encountered multiple issues which seem to relate to expected configuration settings on the Postgres server.
For example when we tried a full cluster restore (3 node Patroni cluster) with the option to restore all nodes we get an “Error Code: [19:1109]” (we have case 250331-524 open for this already).
Another issue we currently have is when trying to restore out-of-place to another cluster-client we get:
Error Code: [94:92]
Description: Configuration Files check failed on Node [DE9899SP9]. Please check pre-requisites for Full Cluster Restore. Error: [One or more errors occurred while processing the request. (ERROR_ERRORS_ENCOUNTERED.774), PostgreSQL configuration files are missing on node 'DE9899SP9'. Please check prerequisites in documentation for Restore to the entire cluster. (W32.774)]
So regarding these errors and some other we got while testing I have the following question:
Is there a comprehensive documentation page or Postgres administrator guide for all Postgres settings which should or need to be set for a restore?
Ia already found some information but this does not seem be sufficient, e.g. Consideration for Restoring FSBased Backup Set on PostgreSQL 12 and Later.
Thanks for any advice!
