Well, it does seem cleaner. Thank you. 2018-03-12 15:33 GMT+03:00 Yedidyah Bar David <d...@redhat.com>:
> On Mon, Mar 12, 2018 at 1:37 PM, KSNull Zero <ksnul...@gmail.com> 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