How to clean up /var/lib/pgsql on the Capsule server?

Environment

• Red Hat Satellite 6

Issue

• On the Capsule server, /var/lib/pgsql filesystem is growing.

Resolution

• This issue has been reported to the Red Hat Engineering team via This content is not included.Bugzilla 2089936 and has been accepted as a valid feature request for now. To understand more about this behavior, please refer to the root cause section of this article.

• To reduce the space utilization by the PostgreSQL database or the /var/lib/pgsql filesystem,

  • Delete unused versions of content-views from the Red Hat Satellite.
  • Delete the content-views that are no longer needed.
  • Remove\Disable the repos in the Red Hat Satellite server that are no longer needed.
  • Refer to this solution article to clear the orphan contents in both the satellite and the capsule server.

• Perform vacuuming of the PostgreSQL database.

  How to perform vacuuming on the individual Red Hat Satellite 6 databases?

• Reach out to the This content is not included.Red Hat Technical Support in case any further assistance or clarification would be required.

Root Cause

• When content management actions are being performed in the satellite, due to the presence of the Katello component, the satellite can smartly keep track of versions of repos created in pulp and map them to different content-views.

• For an external capsule server, there is no katello component present. It's mainly a Pulp server with postgres database. So when repository content is being synced in the capsule for different environments, Then for each content-view and lifecycle combination, the same repo is created multiple times in pulp resulting in a rather larger amount of records in pulp database.

• This information is now officially part of the Capsule Installation documentation and can be found under the 1.2. Storage Requirements section.

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.