Bug 1056417

Summary: RFE: db-control online-backup add option to compress backup
Product: [Community] Spacewalk Reporter: Peter Robinson <perobins>
Component: ServerAssignee: Tomas Lestach <tlestach>
Status: CLOSED DEFERRED QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 2.1CC: cperry, perobins
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-03-24 13:22:34 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 737830    

Description Peter Robinson 2014-01-22 07:55:14 UTC
The db-control online-backup uses pg_dump to make a online backup of the spacewalk/satellite database. 

The pg_dump utility has the ability to compress the data base dump and it would be useful to have the ability to compress the backup on the fly to reduce overall disk usage of the backups as they can get rather large.

Comment 1 Jan Pazdziora (Red Hat) 2014-01-24 02:15:39 UTC
The pg_dump is called with -Fc -Z7 since Spacewalk 1.8 so it is compressed as much as possible. What output do you experience?

Comment 2 Peter Robinson 2014-01-26 10:35:02 UTC
running "db-contol online-backup /var/lib/pgsql/backup/rhsat-20140106" just gives me a file that I can view and see all the raw sql statements where I would be expecting gzip data and if I do "file /var/lib/pgsql/backup/rhsat-20140106" it reports it as "PostgreSQL custom database dump - v1.11-0" where I would expect it to be likely reporting a gzip archive.

Comment 4 Michael Mráka 2020-03-24 13:22:34 UTC
Spacewalk project as an upstream for Red Hat Satellite 5 product is going to be End Of Life on May 31 2020.

Spacewalk 2.10 has been released as the last release of this project.
https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes210

Any new feature will not be included therefore closing remaining RFEs to set expectations properly.