[ovirt-devel] Heads up: PostgreSQL 9.5

[Martin Perina]

Hi,

​Please be aware, that this change means that PostgreSQL 9.5 is required
from now on for master/4.2 development. For RPM installation everything
should be covered, but you need to upgrade your PostgreSQL database​

​manually when using development environment:

  Fedora 26
    - it contains PostgreSQL 9.6 by default, so you should be OK

  Fedora 24/25
    - it contains PostgreSQL 9.5 by default, so you should be OK

  CentOS 7
    - you need to install PostgreSQL 9.5 from Software Collections:

        1. Install SCL PostgreSQL 9.5
              yum update ovirt-release-master
              yum install rh-postgresql95

        2. Stop and disable standard PostgreSQL
              systemctl stop postgresql
              systemctl disable postgresql

        3. Upgrade the database to SCL 9.5
              scl enable rh-postgresql95 bash
              postgresql-setup upgrade
              exit

        4. Configure SCL 9.5
            Please add your custom configuration changes applied to
standard PostgreSQL 9.2 to SCL PostgreSQL 9.5 by comparing configuration
files:
              /var/lib/pgsql/data
                - standard PostgreSQL 9.2 configuration

              /var/opt/rh/rh-postgresql95/lib/pgsql/data/
                - SCL PostgreSQL 9.5 configuration

           Following files should be checked and updated as needed:
             pg_hba.conf
             postgresql.conf

        5. Enable and start SCL 9.5
             systemctl enable rh-postgresql95-postgresql
             systemctl start rh-postgresql95-postgresql

        6. Remove standard PostgreSQL 9.2
             yum remove postgresql-contrib postgresql-server postgresql


You should be able to use SCL PostgreSQL 9.5 for backporting patches to
4.1.z without any issues.

Thanks

Martin


On Tue, Sep 5, 2017 at 10:12 AM, Simone Tiraboschi <stirabos at redhat.com>
wrote:

> Hi all,
> we merged a set of patches to consume PostgreSQL 9.5 from SCL.  ​
>
Please report any suspect behavior.
>
> We already fixed and published a patched version of ovirt-release-master
> which includes the SCL repo but if you installed it in the past you need to
> upgrade or manually install centos-release-scl-rh to configure the SCL repo.
>
> If you installed DWH in the past, you need to upgrade it as well.
>
> ciao
>
> _______________________________________________
> Devel mailing list
> Devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20170905/6250b5a9/attachment.html>