Re: [ovirt-users] 4.2 upgrade question

[Константин Стаценко]

Well, it does seem cleaner.
Thank you.

2018-03-12 15:33 GMT+03:00 Yedidyah Bar David :

> On Mon, Mar 12, 2018 at 1:37 PM, KSNull Zero  wrote:
> > Hello!
> > Currently we run 4.1.9 and try to upgrade to the latest 4.2 release.
> > Our DB server is on separate machine and run PostgreSQL 9.2.23.
> >
> > During upgrade the following error occurs:
> > [WARNING] This release requires PostgreSQL server 9.5.9 but the engine
> > database is currently hosted on PostgreSQL server 9.2.23
> > [ ERROR ] Please upgrade the PostgreSQL instance that serves the engine
> > database to 9.5.9 and retry.
> >
> > Ok, so we need to upgrade PostgreSQL.
> > The question is - do we need to have exact 9.5.9 version of PostgreSQL ?
>
> '9.5.9' is not hard-coded, but is the version shipped by SCL [1].
>
> The CentOS 7 engine build pulls that in and uses it, for both client
> (always)
> and server (if configured to).
>
> This is the only combination that's tested and known to work. To use this
> on your remote PG machine, add there SCL repos and use them. You will need
> to upgrade your database to the new version, similarly to what engine-setup
> does if it's a local db. I do not think we have docs for this, see e.g.
> [2].
>
> If you want to use some other (non-SCL) build of PG also on the client,
> I think it should not be too hard to make everything work, as this is
> what we do in the fedora build, but I didn't try this myself, nor know
> about anyone that did. It's probably enough to remove the file:
>
> /etc/ovirt-engine-setup.env.d/10-setup-scl-postgres-95.env
>
> If you go this way, note that you'll have to repeat removing it per
> each upgrade. Alternatively, you can add your own file there, with
> a later number, clearing the variables set in this file, e.g.:
>
> # cat << __EOF__ > /etc/ovirt-engine-setup.env.d/99-unset-postgresql.env
> unset RHPOSTGRESQL95BASE
> unset RHPOSTGRESQL95DATA
> unset sclenv
> unset POSTGRESQLENV
> __EOF__
>
> And also install the postgresql client/libraries/etc matching what you
> have on your server.
>
> [1] https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/
> [2] https://bugzilla.redhat.com/show_bug.cgi?id=1498351#c12
>
> > Because if we upgrade PostgreSQL to the latest available 9.5.12 the same
> > error occurs saying that client and server version mismatched and upgrade
> > terminates.
> > Thank you.
>
> Best regards,
> --
> Didi
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] 4.2 upgrade question

[Yedidyah Bar David]

On Mon, Mar 12, 2018 at 1:37 PM, KSNull Zero  wrote:
> Hello!
> Currently we run 4.1.9 and try to upgrade to the latest 4.2 release.
> Our DB server is on separate machine and run PostgreSQL 9.2.23.
>
> During upgrade the following error occurs:
> [WARNING] This release requires PostgreSQL server 9.5.9 but the engine
> database is currently hosted on PostgreSQL server 9.2.23
> [ ERROR ] Please upgrade the PostgreSQL instance that serves the engine
> database to 9.5.9 and retry.
>
> Ok, so we need to upgrade PostgreSQL.
> The question is - do we need to have exact 9.5.9 version of PostgreSQL ?

'9.5.9' is not hard-coded, but is the version shipped by SCL [1].

The CentOS 7 engine build pulls that in and uses it, for both client (always)
and server (if configured to).

This is the only combination that's tested and known to work. To use this
on your remote PG machine, add there SCL repos and use them. You will need
to upgrade your database to the new version, similarly to what engine-setup
does if it's a local db. I do not think we have docs for this, see e.g. [2].

If you want to use some other (non-SCL) build of PG also on the client,
I think it should not be too hard to make everything work, as this is
what we do in the fedora build, but I didn't try this myself, nor know
about anyone that did. It's probably enough to remove the file:

/etc/ovirt-engine-setup.env.d/10-setup-scl-postgres-95.env

If you go this way, note that you'll have to repeat removing it per
each upgrade. Alternatively, you can add your own file there, with
a later number, clearing the variables set in this file, e.g.:

# cat << __EOF__ > /etc/ovirt-engine-setup.env.d/99-unset-postgresql.env
unset RHPOSTGRESQL95BASE
unset RHPOSTGRESQL95DATA
unset sclenv
unset POSTGRESQLENV
__EOF__

And also install the postgresql client/libraries/etc matching what you
have on your server.

[1] https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/
[2] https://bugzilla.redhat.com/show_bug.cgi?id=1498351#c12

> Because if we upgrade PostgreSQL to the latest available 9.5.12 the same
> error occurs saying that client and server version mismatched and upgrade
> terminates.
> Thank you.

Best regards,
-- 
Didi
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

[ovirt-users] 4.2 upgrade question

[KSNull Zero]

Hello!
Currently we run 4.1.9 and try to upgrade to the latest 4.2 release.
Our DB server is on separate machine and run PostgreSQL 9.2.23.

During upgrade the following error occurs:
[WARNING] This release requires PostgreSQL server 9.5.9 but the engine
database is currently hosted on PostgreSQL server 9.2.23
[ ERROR ] Please upgrade the PostgreSQL instance that serves the engine
database to 9.5.9 and retry.

Ok, so we need to upgrade PostgreSQL.
The question is - do we need to have exact 9.5.9 version of PostgreSQL ?
Because if we upgrade PostgreSQL to the latest available 9.5.12 the same
error occurs saying that client and server version mismatched and upgrade
terminates.
Thank you.
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users