<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 20, 2017 at 3:50 PM, Fabrice Bacchella <span dir="ltr"><<a href="mailto:fabrice.bacchella@orange.fr" target="_blank">fabrice.bacchella@orange.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="word-wrap:break-word"><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures">I tried to upgrade ovirt to version 4.1 from 4.0 and got:</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"><br></span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> Found the following problems in PostgreSQL configuration for the Engine database:</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> autovacuum_vacuum_scale_factor required to be at most 0.01</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> autovacuum_analyze_scale_<wbr>factor required to be at most 0.075</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> autovacuum_max_workers required to be at least 6</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> Postgresql client version is '9.4.8', whereas the version on XXX is '9.4.11'. Please use a Postgresql server of version '9.4.8'.</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> Please set:</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> autovacuum_vacuum_scale_factor = 0.01</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> autovacuum_analyze_scale_<wbr>factor = 0.075</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> autovacuum_max_workers = 6</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> server_version = 9.4.8</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:menlo"><span style="font-variant-ligatures:no-common-ligatures"> in postgresql.conf on 'XXXX'. Its location is usually /var/lib/pgsql/data , or somewhere under /etc/postgresql* .</span></div><div><span style="font-variant-ligatures:no-common-ligatures"><br></span></div><div><span style="font-variant-ligatures:no-common-ligatures">I'm a little afraid about that. Does ovirt want pg to lies about it's version ? It's a shared instance so what about other tools that access it ? Is there some explanation about the meaning of those values ?</span></div></div></blockquote><div><br></div><div>engine-setup it's comparing the version of the local psql client with the version reported by the remote postgresql server as for:</div><div><a href="https://bugzilla.redhat.com/show_bug.cgi?id=1331168">https://bugzilla.redhat.com/show_bug.cgi?id=1331168</a><br></div><div><br></div><div>Currently it's a strict comparison; maybe we should be more flexibly regarding .z versions; Didi?</div><div><br></div><div>The other checks has been introduced for performance and scaling reasons.</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="word-wrap:break-word"><div><span style="font-variant-ligatures:no-common-ligatures"><br></span></div><div><span style="font-variant-ligatures:no-common-ligatures">And it was not in the release notes, it's not funny to get this warning after starting the upgrade</span></div></div><br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div>