Bug 1935888

Summary: [rfe] Add the pg_repack utility to the base postgresql 12 package
Product: Red Hat Software Collections Reporter: Mike Silmser <msilmser>
Component: distributionAssignee: Filip Januš <fjanus>
Status: CLOSED ERRATA QA Contact: Vaclav Danek <vdanek>
Severity: medium Docs Contact:
Priority: unspecified    
Version: rh-postgresql12CC: bmikulov, databases-maint, hhorak, kwalker, pkubat, praiskup, vdanek
Target Milestone: alphaKeywords: FutureFeature, TestCaseProvided, Triaged
Target Release: 3.7   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-06-03 11:24:42 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:

Description Mike Silmser 2021-03-05 18:02:41 UTC 
1. Request to include pg_repack in the postgresql package

2. Who is the customer behind the request?

Account: IBM Corp - 6393192
TAM customer: Yes
CSM customer: Yes
Strategic: Yes

3. What is the nature and description of the request?
Including a postgres utility in the postgres package by default

4. Why does the customer need this? (List the business requirements here)
Customer has a requirement for performing maintenance on their database without the downtime and locks that come with a full vacuum

5. How would the customer like to achieve this? (List the functional requirements here)
Customer is currently using the Postgres catalog container images. In order to update the containers to include this, it would need to be included in the base package

6. For each functional requirement listed, specify how Red Hat and the customer can test to confirm the requirement is successfully implemented.

7. Is there already an existing RFE upstream or in Red Hat Bugzilla?
No

8. Does the customer have any specific timeline dependencies and which release would they like to target (i.e. RHEL5, RHEL6)?
RHEL 7 (SCL release)
RHEL 8

9. Is the sales team involved in this request and do they have any additional input?
No

10. List any affected packages or components.
Postgresql 10

11. Would the customer be able to assist in testing this functionality if implemented?
Yes
Comment 3 Mike Silmser 2021-03-05 19:40:14 UTC 
Relevant review request: https://bugzilla.redhat.com/show_bug.cgi?id=1744570
Comment 12 Honza Horak 2021-03-22 16:38:52 UTC 
A test prepared here:
https://src.fedoraproject.org/tests/postgresql/pull-request/6
Comment 18 errata-xmlrpc 2021-06-03 11:24:42 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (new packages: rh-postgresql12-pg_repack), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2021:2228