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. |
