<div dir="ltr"><div>Well, it does seem cleaner.</div><div>Thank you.</div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-03-12 15:33 GMT+03:00 Yedidyah Bar David <span dir="ltr"><<a href="mailto:didi@redhat.com" target="_blank">didi@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Mon, Mar 12, 2018 at 1:37 PM, KSNull Zero <<a href="mailto:ksnull01@gmail.com">ksnull01@gmail.com</a>> wrote:<br>
> Hello!<br>
> Currently we run 4.1.9 and try to upgrade to the latest 4.2 release.<br>
> Our DB server is on separate machine and run PostgreSQL 9.2.23.<br>
><br>
> During upgrade the following error occurs:<br>
> [WARNING] This release requires PostgreSQL server 9.5.9 but the engine<br>
> database is currently hosted on PostgreSQL server 9.2.23<br>
> [ ERROR ] Please upgrade the PostgreSQL instance that serves the engine<br>
> database to 9.5.9 and retry.<br>
><br>
> Ok, so we need to upgrade PostgreSQL.<br>
> The question is - do we need to have exact 9.5.9 version of PostgreSQL ?<br>
<br>
'9.5.9' is not hard-coded, but is the version shipped by SCL [1].<br>
<br>
The CentOS 7 engine build pulls that in and uses it, for both client (always)<br>
and server (if configured to).<br>
<br>
This is the only combination that's tested and known to work. To use this<br>
on your remote PG machine, add there SCL repos and use them. You will need<br>
to upgrade your database to the new version, similarly to what engine-setup<br>
does if it's a local db. I do not think we have docs for this, see e.g. [2].<br>
<br>
If you want to use some other (non-SCL) build of PG also on the client,<br>
I think it should not be too hard to make everything work, as this is<br>
what we do in the fedora build, but I didn't try this myself, nor know<br>
about anyone that did. It's probably enough to remove the file:<br>
<br>
/etc/ovirt-engine-setup.env.d/<wbr>10-setup-scl-postgres-95.env<br>
<br>
If you go this way, note that you'll have to repeat removing it per<br>
each upgrade. Alternatively, you can add your own file there, with<br>
a later number, clearing the variables set in this file, e.g.:<br>
<br>
# cat << __EOF__ > /etc/ovirt-engine-setup.env.d/<wbr>99-unset-postgresql.env<br>
unset RHPOSTGRESQL95BASE<br>
unset RHPOSTGRESQL95DATA<br>
unset sclenv<br>
unset POSTGRESQLENV<br>
__EOF__<br>
<br>
And also install the postgresql client/libraries/etc matching what you<br>
have on your server.<br>
<br>
[1] <a href="https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/" rel="noreferrer" target="_blank">https://www.<wbr>softwarecollections.org/en/<wbr>scls/rhscl/rh-postgresql95/</a><br>
[2] <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1498351#c12" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1498351#c12</a><br>
<br>
> Because if we upgrade PostgreSQL to the latest available 9.5.12 the same<br>
> error occurs saying that client and server version mismatched and upgrade<br>
> terminates.<br>
> Thank you.<br>
<br>
Best regards,<br>
<span class="HOEnZb"><font color="#888888">--<br>
Didi<br>
</font></span></blockquote></div><br></div>