Project

Profile

Help

Story #8154

closed

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

Added by mdepaulo@redhat.com over 3 years ago. Updated almost 3 years 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 modeMODIFIEDfao89Actions
Related to Pulp - Issue #9114: pulp_database role is incompatible with RHEL7MODIFIEDmdepaulo@redhat.comActions
Actions #1

Updated by mdepaulo@redhat.com over 3 years ago

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

Updated by mdepaulo@redhat.com over 3 years ago

  • Description updated (diff)
Actions #3

Updated by mdepaulo@redhat.com over 3 years ago

Note that Katello has Postgres 12 now.

Actions #4

Updated by fao89 over 3 years ago

  • Status changed from NEW to ASSIGNED
  • Assignee set to fao89
Actions #5

Updated by pulpbot over 3 years ago

  • Status changed from ASSIGNED to POST

Added by Fabricio Aguiar over 3 years ago

Revision 3674faec | View on GitHub

Require postgreSQL >= 10 on CentOS 7

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

Added by Fabricio Aguiar over 3 years ago

Revision 3674faec | View on GitHub

Require postgreSQL >= 10 on CentOS 7

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

Actions #10

Updated by Anonymous over 3 years ago

  • Status changed from POST to MODIFIED
  • % Done changed from 0 to 100
Actions #11

Updated by ipanova@redhat.com over 3 years ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE
Actions #12

Updated by mdepaulo@redhat.com almost 3 years ago

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

Updated by mdepaulo@redhat.com almost 3 years 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).

Also available in: Atom PDF