Explicit Vacuum Full script

You can run the following script that is present in the TCA/TCA-CP appliance. However, be very careful while running this script because vacuum full is DISRUPTIVE.

admin@10[ ~ ]$ ls -l /opt/vmware/scripts/runPostgresVacuumFull.sh
-rwxr-xr-x 1root root 1616Feb  300:44/opt/vmware/scripts/runPostgresVacuumFull.sh

You can run the following script:

admin@10 [ ~ ]$ /opt/vmware/scripts/runPostgresVacuumFull.sh
admin@10 [ ~ ]$ cat/var/log/vmware/tca/postgresVacuumFull.log
Wed Feb  7 10:08:52 PM UTC 2024
Wed Feb  7 10:08:52 PM UTC 2024 PostgreSQL app status is True, continuing!
vacuumdb: vacuuming database "tca"
INFO:  vacuuming "public.test2"
INFO:  "test2": found 0 removable, 49950 nonremovable row versions in8325 pages
DETAIL:  0 dead row versions cannot be removed yet.CPU: user: 0.08 s, system: 0.24 s, elapsed: 0.50 s.INFO:  vacuuming "public.test1"
... 
... 
...

The logs for this script are located in /var/log/vmware/tca/postgresVacuumFull.log. After running the script successfully, following message is displayed:

PostgreSQL vacuum full is completed successfully