Project

Profile

Help

Story #8154

As an EL7 pulp_installer user, I use a newer version of postgres than 9.6

Added by mdepaulo@redhat.com 8 months ago. Updated 2 months ago.

Status:
CLOSED - CURRENTRELEASE
Priority:
Normal
Assignee:
Category:
-
Sprint/Milestone:
-
Start date:
Due date:
% Done:

100%

Estimated time:
Platform Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Sprint:
Quarter:

Description

This has been discussed often, but with #8095 / FIPS compliance (note 7), it may become more important.

We should change pulp_installer from using Postgres 9.6 on EL7 from the SCL, to either the Postgres 10 SCL or Postgres 12 SCL.

This means upgrading existing installs as well.

Also, there are official in-place upgrade instructions from 9.6 to 10, and from 10 to 12: https://access.redhat.com/documentation/en-us/red_hat_software_collections/3/html/3.3_release_notes/chap-migration#sect-Migration-PostgreSQL-9_6-10

https://access.redhat.com/documentation/en-us/red_hat_software_collections/3/html/3.6_release_notes/chap-migration#sect-Migration-PostgreSQL-10-12


Related issues

Related to Pulp - Issue #8095: geerlingguy.postgresql role (pulp_installer) now errors under FIPS modeMODIFIED<a title="Actions" class="icon-only icon-actions js-contextmenu" href="#">Actions</a>
Related to Pulp - Issue #9114: pulp_database role is incompatible with RHEL7MODIFIED<a title="Actions" class="icon-only icon-actions js-contextmenu" href="#">Actions</a>

Associated revisions

Revision 3674faec View on GitHub
Added by Fabricio Aguiar 6 months ago

Require postgreSQL >= 10 on CentOS 7

https://pulp.plan.io/issues/8154 closes #8154

Revision 3674faec View on GitHub
Added by Fabricio Aguiar 6 months ago

Require postgreSQL >= 10 on CentOS 7

https://pulp.plan.io/issues/8154 closes #8154

History

#1 Updated by mdepaulo@redhat.com 8 months ago

  • Related to Issue #8095: geerlingguy.postgresql role (pulp_installer) now errors under FIPS mode added

#2 Updated by mdepaulo@redhat.com 8 months ago

  • Description updated (diff)

#3 Updated by mdepaulo@redhat.com 8 months ago

Note that Katello has Postgres 12 now.

#4 Updated by fao89 7 months ago

  • Status changed from NEW to ASSIGNED
  • Assignee set to fao89

#5 Updated by pulpbot 7 months ago

  • Status changed from ASSIGNED to POST

#10 Updated by Anonymous 6 months ago

  • Status changed from POST to MODIFIED
  • % Done changed from 0 to 100

#11 Updated by ipanova@redhat.com 6 months ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE

#12 Updated by mdepaulo@redhat.com 2 months ago

  • Related to Issue #9114: pulp_database role is incompatible with RHEL7 added

#13 Updated by mdepaulo@redhat.com 2 months ago

For future reference, if we have trouble with this role's symlinks, the better solution would be to use wrappers scripts for the postgres binaries: https://riptutorial.com/bash/example/19492/wrapper-script

We would then point the geerlingguy.postgresql role to that.

We would only need 1 wrapper script, with symlinks (the 1 script would execute $0).

Please register to edit this issue

Also available in: Atom PDF