Challenge
When performing a configuration restore or migration, the Restore process fails with the error:
2200N: invalid XML content DETAIL: buffer full
Cannot read configuration backup
Cause
This error is caused by an underlying issue within PostgreSQL 15.1 and 15.2
PostgreSQL 15.1 was included with the following versions of Veeam Backup & Replication:
Veeam Backup & Replication 12 P20230718
Veeam Backup & Replication 12 P20230412
Veeam Backup & Replication 12 P20230223
Veeam Backup & Replication 12 GA
Veeam Backup & Replication 12 RTM
By default, PostgreSQL is used with all new installs of Veeam Backup & Replication 12. Existing Veeam Backup & Replication deployments that were upgraded from 11a or older will continue to use Microsoft SQL Server until they are manually migrated to PostgreSQL.
Solution
This issue was resolved in PostgreSQL 15.3.
To resolve and prevent this issue, Veeam recommends all customers with Veeam Backup & Replication deployments using PostgreSQL 15.1 or 15.2 upgrade to the latest but we strongly recommend to download and install the latest PostgreSQL 15.x version.
More Information
How to Check Installed PostgreSQL Version
To check which version of PostgreSQL is installed, check the File Version of the postgres.exe file.
PowerShell example:
