Modifying the PostgreSQL Repository Maximum Allowed Packets
If you use backup_import for a large CAR file, and if the number of packets being saved is too great for the current packet setting of the PostgreSQL repository, the following TDV error message appears:
com.compositesw.cdms.Webapi.WebapiException: One or more resources could not be saved. Packet for query is too large ... You can change this value on the server by setting the max_allowed_packet' variable.
If you encounter this error message, you can change a TDV PostgreSQL repository setting to allow a larger number of packets to be saved to the repository.
To change the PostgreSQL repository maximum allowed packets
1. Using a PostgreSQL admin tool, log in to the PostgreSQL client as the root user.
2. Change maximum allowed packets:
PostgreSQL> set @@max_allowed_packet = 25165824;
3. Verify that the setting was accepted:
PostgreSQL> show variables like '%max_allowed%';
+--------------------+----------+
| Variable_name -----| Value ---|
+--------------------+----------+
| max_allowed_packet | 25165824 |
+--------------------+----------+