Page tree
Skip to end of metadata
Go to start of metadata

When the database growsa rapidly due to rapidlt growing logs, truncating the logs table may be necessary to avoid running out of disk space.

Step-by-step guide

  1. Stop portal services on all servers: stop

  2. Start PostgreSQL service on DB server: start_postgres

  3. Change to postgres user and run psql:
    su – postgres

  4. Truncate the logs table: postgres=# truncate logs;
  5. Stop postgres services: stop_postgres
  6. Start the portal: start

Truncating is faster than doing a delete, but it will remove all the portal logs, so make sure all parties are in agreement before proceeding.