11:45 a.m.
Hi,
SCL PG10 upgrade patch [1] has been merged this morning, here are the steps
that every engine developer should do:
1. Rebase all you existing patches for master
2. If you are using engine development environment on Fedora 28
- you are safe, you are already using PG 10, which is part of Fedora
- if you encounter any issue, please raise it
3. If you are using engine development environment on CentOS 7
- you need to install PG 10 from SCL as mentioned in previous email
- don't remove your PG 9.5, you will still need it it
- here is the flow:
- if you are working on patch for master branch (or in future stable
4.3 branch), you need to use PG 10
- if you are working on backport to 4.2 stable branch, you still need
to use PG 9.5
- both PG versions can be installed at the same time on your machine,
but only one can actually be running
4. If you are using RPM installation
- you shouldn't be affected, after you rebase your existing patch and
rebuild RPMs, PG 10 will be automatically installed and used
If you have any issues with your dev env after this PG 10 bump, please ping
Eli or me.
Thanks
Martin
On Tue, Dec 4, 2018 at 1:14 AM Eli Mesika <emesika(a)redhat.com> wrote:
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
--
Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.