Table of Contents

Search

  1. Preface
  2. Introducing Administrator
  3. Organizations
  4. Licenses
  5. Ecosystem single sign-on
  6. SAML single sign-on
  7. Source control and service upgrade settings
  8. Users and user groups
  9. User roles
  10. Permissions
  11. Runtime environments
  12. Serverless runtime environments
  13. Secure Agent services
  14. Secure Agent installation
  15. Schedules
  16. Bundle management
  17. Event monitoring
  18. File transfer
  19. Troubleshooting

Administrator

Administrator

Vacuuming the PostgreSQL database on Linux

Vacuuming the PostgreSQL database on Linux

Vacuum the PostrgeSQL database to delete obsolete tuples and gain space. You use the script
db_maintenance.sh
to vacuum the PostgreSQL database.
By default, the PostgreSQL database auto vacuums. If you want to manually vacuum the database, perform the following steps:
  1. Go to
    <Secure Agent installation directory>/apps/process-engine/data/db/util
    .
  2. To vacuum the entire database, run the following command:
    db_maintenance <dbusername> <dbpassword> vacuum
  3. To vacuum a single table, run the following command:
    db_maintenance.sh <dbusername> <dbpassword> vacuum <tablename>
For example, you vacuum the 'aeprocesslogdata' table if you run the following command:
db_maintenance.sh bpeluser bpel vacuum aeprocesslogdata


Updated August 03, 2020