In order to unify many distant Postgres databases, we decided to use WAL archiving. The idea is to concatenate a distant WAL archive at the beginning of a local WAL archive before launching PITR restore.
Does anyone know how to concatenate WAL contents, i.e. decode and encode WAL files using the address of backup files (aaa in xxxxx.aaa.backup files)?