Table of Contents

Search

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

Administrator

Administrator

Vacuuming the PostgreSQL database on Windows

Vacuuming the PostgreSQL database on Windows

Vacuum the PostgreSQL database to delete obsolete tuples and gain space. You use the script
db_maintenance.bat
to vacuum the PostgreSQL database.
By default, the PostgreSQL database autovacuums. 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.bat <dbusername> <dbpassword> vacuum
  3. To vacuum a single table, run the following command:
    db_maintenance.bat <dbusername> <dbpassword> vacuum <tablename>
For example, you vacuum the 'aeprocesslogdata' table if you run the following command:
db_maintenance.bat bpeluser bpel vacuum aeprocesslogdata


Updated October 29, 2020