How to manually vacuum the TIBCO Data Virtualization repository from version 8.5.2 onwards?
Article ID: KB0072296
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.5.2 and higher |
Description
The Postgres repository has been upgraded to version 12 in TDV 8.5.2. Check the release notes for TDV 8.5.2 to view this information.
So, if a user executes the command to manually vacuum the TDV repository an error will be encountered now.
Command used:
So, if a user executes the command to manually vacuum the TDV repository an error will be encountered now.
Command used:
VACUUM FULL ANALYZE VERBOSE;
Screenshot of the error received:
The reason for this error is that VERBOSE + ANALYZE cannot be used together in the same VACUUM command. This has been reported as an issue from the PostgreSQL side from version 11 onwards.
Environment
All Supported OS
Resolution
The user can execute the below command:
VACUUM (ANALYZE, VERBOSE);
Note: The above command may not work in all scenarios. Then, the following command can also be used:
VACUUM(FULL, ANALYZE, VERBOSE);
These commands will serve the same purpose of manually vacuuming the TDV repository.
Issue/Introduction
This article will mention the command to be used to perform a manual vacuum on the TIBCO Data Virtualization repository from version 8.5.2 onwards
Additional Information
PostgreSQL article for reference:
https://www.postgresql.org/message-id/20181031075235.GE7862%40paquier.xyz
Previous KB article:
https://support.tibco.com/s/article/Manually-vacuuming-the-TDV-repository
https://www.postgresql.org/message-id/20181031075235.GE7862%40paquier.xyz
Previous KB article:
https://support.tibco.com/s/article/Manually-vacuuming-the-TDV-repository
Feedback
Yes
No
Powered by
