Note:

For a full database vacuum, it is advisable to stop all application services and run the database vacuum during a period of down time.

To run a database vacuum on all database tables, follow these steps:

Step

Action (Linux)

1

Log into the Database server as a user with administrator privileges.

2

Log into the database as the pgdba user using the su – pgdba command.

3

Navigate to the psql prompt.

Type psql voyencedb voyence to navigate to the psql prompt, and press Enter.

4

Run the database vacuum.

Type vacuum full; to run the database vacuum, and press Enter.

Note:

The database vacuum may take several minutes/hours depending on the size of your database. If "vaccum full" hangs, then go to $VOYENCE_HOME/db/controldb/data and make autovacuum = off in postgresql.conf file.