<div dir="ltr"><br><br><div class="gmail_quote"><div dir="ltr">On Wed, 2 May 2018 at 23:27 Jamie Lawrence <<a href="mailto:jlawrence@squaretrade.com">jlawrence@squaretrade.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
I've been down this road. Postgres won't lie about its version for you. If you want to do this, you have to patch the Ovirt installer[1]. I stopped trying to use my PG cluster at some point - the relationship between the installer and the product combined with the overly restrictive requirements baked into the installer[2]) makes doing so an ongoing hassle. So I treat Ovirt's PG as an black box; disappointing, considering that we are a very heavy PG shop with a lot of expertise and automation I can't use with Ovirt.<br>
<br>
If nothing has changed (my notes are from a few versions ago), everything you need to correct is in<br>
<br>
/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/constants.py<br>
<br>
Aside from the version, you'll also have to make the knobs for vacuuming match those of your current installation, and I think there was another configurable for something else I'm not remembering right now.<br>
<br>
Be aware that doing so is accepting an ongoing commitment to monkeying with the installer a lot. At one time I thought doing so was the right tradeoff, but it turns out I was wrong.<br>
<br>
-j<br>
<br>
[1] Or you could rebuild PG with a fake version. That option was unavailable here.<br>
[2] Not criticizing, just stating a technical fact. How folks apportion their QA resources is their business.<br>
<br>
> On May 2, 2018, at 12:49 PM, ~Stack~ <<a href="mailto:i.am.stack@gmail.com" target="_blank">i.am.stack@gmail.com</a>> wrote:<br>
> <br>
> Greetings,<br>
> <br>
> Exploring hosting my engine and ovirt_engine_history db's on my<br>
> dedicated PostgreSQL server.<br>
> <br>
> This is a 9.5 install on a beefy box from the <a href="http://postgresql.org" rel="noreferrer" target="_blank">postgresql.org</a> yum repos<br>
> that I'm using for other SQL needs too. 9.5.12 to be exact. I set up the<br>
> database just as the documentation says and I'm doing a fresh install of<br>
> my engine-setup.<br>
> <br>
> During the install, right after I give it the details for the remote I<br>
> get this error:<br>
> [ ERROR ] Please set:<br>
> server_version = 9.5.9<br>
> in postgresql.conf on 'None'. Its location is usually<br>
> /var/lib/pgsql/data , or somewhere under /etc/postgresql* .<br>
> <br>
> Huh?<br>
> <br></blockquote><div><br></div><div>Yes it's annoying and I think <a class="GWVZpf gW" id="IloFPc-5" href="mailto:ylavi@redhat.com" tabindex="-1">+Yaniv Dary</a> opened a bug for it after both of got mad at it. Yaniv?<br><br></div><div>Meanwhile let us know if you were able to patch constants.py as suggested.<br><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
> Um. OK.<br>
> $ grep ^server_version postgresql.conf<br>
> server_version = 9.5.9<br>
> <br>
> $ systemctl restart postgresql-9.5.service<br>
> <br>
> LOG: syntax error in file "/var/lib/pgsql/9.5/data/postgresql.conf"<br>
> line 33, n...n ".9"<br>
> FATAL: configuration file "/var/lib/pgsql/9.5/data/postgresql.conf"<br>
> contains errors<br>
> <br>
> <br>
> Well that didn't work. Let's try something else.<br>
> <br>
> $ grep ^server_version postgresql.conf<br>
> server_version = 9.5.9<br>
> <br>
> $ systemctl restart postgresql-9.5.service<br>
> LOG: parameter "server_version" cannot be changed<br>
> FATAL: configuration file "/var/lib/pgsql/9.5/data/postgresql.conf"<br>
> contains errors<br>
> <br>
> Whelp. That didn't work either. I can't seem to find anything in the<br>
> oVirt docs on setting this.<br>
> <br>
> How am I supposed to do this?<br>
> <br>
> Thanks!<br>
> ~Stack~<br>
> <br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div></div>