[ovirt-devel] [IMPORTANT] Upgrading to PG 10.x in version 4.3 on f28/CentOS7.5 , instructions for developers,, please read before you re-base on master

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-... [3] https://wiki.centos.org/AdditionalResources/Repositories/SCL If you are developing from a VM then it is always recommended to create a "before upgrade" snapshot of the VM. (I know it is not supported from the user portal but you can ask for access rights only for doing this from your admin on the admin portal. If you have any questions/problems , please contact me Eli Mesika (emesika on IRC) Best Regards Eli