Hi

We will merge a patch[1] today that will require the upcoming 4.3 version to use Postgres 10 on f28 and Postgres SCL 10 (Software Collections) on CentOS 7.5

* If you are using f28 and creating new DB schema for development (having no 9.x PG data), then you done and this change should be transparent to you.

* If you are using f27, have some old 9.x PG data and upgrade to f28, then you will have to upgrade your old PG data after moving to f28 according to the instructions in [2]

* If you are using CentOS then you are running PG SCL 9.5 and should upgrade to PG SCL 10

1.  Upgrade to CentOS 7.5 (insure that you have the SCL repo [3] after upgrade)

2.  #yum update -y # insure that your OS has latest patches

3.  #service rh-postgresql95-postgresql stop

4.  #yum install rh-postgresql10 rh-postgresql10-postgresql-contrib -y

5.  #/opt/rh/rh-postgresql10/root/bin/postgresql-setup --upgrade --upgrade-from="rh-postgresql95-postgresql" # If you have junk sachems, drop them first, the upgrade of each takes time.

6.  #service rh-postgresql10-postgresql start # check status to see that it is active

7.  #service rh-postgresql10-postgresql enable

8.  Insure that your patches are re-based on master latest

9.  Remove all <target> binaries created with "#make clean install-dev PREFIX=<target>....."

10. Compile(make install-dev..)/Setup(engine-setup) and run again your patches (git branches you are working on)

11. Insure that basic operations (add new dc/cluster for example) are working

12. Track engine.log / server.log and PG logs for database errors

13. # yum remove rh-postgresql95 rh-postgresql95-postgresql-contrib -y (only if all above is succeed)

[1] https://gerrit.ovirt.org/#/c/95100/

[2] https://docs.bmc.com/docs/btco113/migrating-the-data-from-postgresql-9-x-to-10-x-800581922.html

[3] https://wiki.centos.org/AdditionalResources/Repositories/SCL

If you have any questions/problems , please contact me

Eli Mesika (emesika on IRC)

Best Regards

Eli