Secure Agent Services

Back Next

Reindexing the PostgreSQL database on Linux

Use the reindexing option to clean the index and free up space after you vacuum data on PostgreSQL. You use the script

db_maintenance.sh

to reindex the PostgreSQL database.

To reindex the PostgreSQL database, perform the following steps:

Go to

<Secure Agent installation directory>/apps/process-engine/data/db/util

To reindex the entire database, run the following command:

db_maintenance <dbusername> <dbpassword> <dbport> reindex

To reindex a single table, run the following command:

db_maintenance.sh <dbusername> <dbpassword> <dbport> reindex <tablename>

For example, you reindex the 'aeprocesslogdata' table if you run the following command:

db_maintenance.sh bpeluser bpel 5432 reindex aeprocesslogdata

The dbport argument is required even if you use the default port, 5432.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.