Re: [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 
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@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

Re: [ovirt-devel] Heads up: PostgreSQL 9.5

[Simone Tiraboschi]

On Tue, Sep 5, 2017 at 11:47 AM, Dan Kenigsberg  wrote:

> On Tue, Sep 5, 2017 at 11:12 AM, Simone Tiraboschi 
> 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.
>
>
> A recent rebase caused
> http://jenkins.ovirt.org/job/ovirt-system-tests_manual/1086/console to
> fail on
>
> 08:24:55 + systemctl start firewalld
> 08:24:55 + yum install --nogpgcheck -y --downloaddir=/dev/shm ntp
> net-snmp ovirt-engine ovirt-log-collector
> 'ovirt-engine-extension-aaa-ldap*'
> 08:24:55 Error: Package:
> ovirt-engine-tools-backup-4.2.0-0.0.master.20170905074337.
> git8cca476.el7.centos.noarch
> (alocalsync)
> 08:24:55Requires: rh-postgresql95-postgresql
> 08:24:55 Error: Package:
> ovirt-engine-4.2.0-0.0.master.20170905074337.git8cca476.el7.centos.noarch
> (alocalsync)
> 08:24:55Requires: rh-postgresql95-postgresql-server
>
> which seems related. Is it?
>

Yes, we are working on https://gerrit.ovirt.org/#/c/81444/ to include the
correct repo in ovirt-system-tests.
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

[ovirt-devel] Heads up: PostgreSQL 9.5

[Simone Tiraboschi]

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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel