How to clean up the sessions table inside the foreman database on Red Hat Satellite 6?

Solution Verified - Updated 1 Oct 2025

Environment

Red Hat Satellite 6.x

Issue

Using the script attached to Postgresql database is growing and disk space utilization of /var/lib/pgsql is increasing in Red Hat Satellite 6, the sessions table inside the foreman database was identified as one of the largest tables.

Resolution

The sessions table inside the foreman database can be cleaned up using either of the following commands based on the user's choice:
- To clear the sessions table completely:
```
# foreman-rake db:sessions:clear --trace --verbose
```
- To trim/clear sessions older that 30 days from the table:
```
# foreman-rake db:sessions:trim --trace --verbose
```

For more KB articles/solutions related to Red Hat Satellite 6.x PostgreSQL-related Issues, please refer to the Consolidated Troubleshooting Article for Red Hat Satellite 6.x PostgreSQL-related Issues

SBR

SysMgmt

Product(s)

Red Hat Satellite

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.