Project

Profile

Help

Actions
Send by e-mail Copy link

Story #8154

closed

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

Added by mdepaulo@redhat.com almost 4 years ago. Updated over 3 years ago.

Status:
CLOSED - CURRENTRELEASE
Priority:
Normal
Assignee:
fao89
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
Copy link
 #1

Updated by mdepaulo@redhat.com almost 4 years ago

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

Updated by mdepaulo@redhat.com almost 4 years ago

  • Description updated (diff)
Actions
Copy link
 #3

Updated by mdepaulo@redhat.com almost 4 years ago

Note that Katello has Postgres 12 now.

Actions
Copy link
 #4

Updated by fao89 almost 4 years ago

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

Updated by pulpbot almost 4 years ago

  • Status changed from ASSIGNED to POST

Added by Fabricio Aguiar almost 4 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 almost 4 years ago

Revision 3674faec | View on GitHub

Require postgreSQL >= 10 on CentOS 7

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

Actions
Copy link
 #10

Updated by Anonymous almost 4 years ago

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

Updated by ipanova@redhat.com almost 4 years ago

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

Updated by mdepaulo@redhat.com over 3 years ago

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

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

Actions
Send by e-mail Copy link

Also available in: Atom PDF