On Thu, May 3, 2018 at 9:53 AM, Yedidyah Bar David <d...@redhat.com> wrote: > On Thu, May 3, 2018 at 12:13 AM, Roy Golan <rgo...@redhat.com> wrote: >> >> >> On Wed, 2 May 2018 at 23:27 Jamie Lawrence <jlawre...@squaretrade.com> >> wrote: >>> >>> >>> 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. > > Sorry about that, but not sure it's such a bad choice. > >>> >>> If nothing has changed (my notes are from a few versions ago), everything >>> you need to correct is in >>> >>> >>> /usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/constants.py >>> >>> 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. >>> >>> 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. >>> >>> -j >>> >>> [1] Or you could rebuild PG with a fake version. That option was >>> unavailable here. >>> [2] Not criticizing, just stating a technical fact. How folks apportion >>> their QA resources is their business. >>> >>> > On May 2, 2018, at 12:49 PM, ~Stack~ <i.am.st...@gmail.com> wrote: >>> > >>> > Greetings, >>> > >>> > Exploring hosting my engine and ovirt_engine_history db's on my >>> > dedicated PostgreSQL server. >>> > >>> > This is a 9.5 install on a beefy box from the postgresql.org yum repos >>> > that I'm using for other SQL needs too. 9.5.12 to be exact. I set up the >>> > database just as the documentation says and I'm doing a fresh install of >>> > my engine-setup. >>> > >>> > During the install, right after I give it the details for the remote I >>> > get this error: >>> > [ ERROR ] Please set: >>> > server_version = 9.5.9 >>> > in postgresql.conf on 'None'. Its location is usually >>> > /var/lib/pgsql/data , or somewhere under /etc/postgresql* . >>> > >>> > Huh? >>> > >> >> >> Yes it's annoying and I think +Yaniv Dary opened a bug for it after both of >> got mad at it. Yaniv? > > Yaniv did, and I asked for details. Comments are welcome: > > https://bugzilla.redhat.com/show_bug.cgi?id=1573091
Also filed now a bug about the text: https://bugzilla.redhat.com/show_bug.cgi?id=1578276 Feel free to comment there, and/or on the patch linked to it. Thanks. > > Of course, if it's so annoying, and we are so confident in PG's compatibility > inside z-stream, we can simply lax the test by checking only x.y but changing > no other functionality, and discuss something stronger later on (if at all). > > Pushed this for now, didn't verify: > > https://gerrit.ovirt.org/90866 > > Ideally, "verification" isn't merely checking that it works as expected, but > also coming up with means to enhance our confidence that it's indeed safe. > > But it might not be such a big risk to merge this anyway, even for 4.2. > >> >> Meanwhile let us know if you were able to patch constants.py as suggested. >> >>> > Um. OK. >>> > $ grep ^server_version postgresql.conf >>> > server_version = 9.5.9 >>> > >>> > $ systemctl restart postgresql-9.5.service >>> > >>> > LOG: syntax error in file "/var/lib/pgsql/9.5/data/postgresql.conf" >>> > line 33, n...n ".9" >>> > FATAL: configuration file "/var/lib/pgsql/9.5/data/postgresql.conf" >>> > contains errors >>> > >>> > >>> > Well that didn't work. Let's try something else. >>> > >>> > $ grep ^server_version postgresql.conf >>> > server_version = 9.5.9 >>> > >>> > $ systemctl restart postgresql-9.5.service >>> > LOG: parameter "server_version" cannot be changed >>> > FATAL: configuration file "/var/lib/pgsql/9.5/data/postgresql.conf" >>> > contains errors >>> > >>> > Whelp. That didn't work either. I can't seem to find anything in the >>> > oVirt docs on setting this. >>> > >>> > How am I supposed to do this? >>> > >>> > Thanks! >>> > ~Stack~ >>> > >>> > _______________________________________________ >>> > Users mailing list >>> > Users@ovirt.org >>> > http://lists.ovirt.org/mailman/listinfo/users >>> >>> _______________________________________________ >>> Users mailing list >>> Users@ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >> >> >> _______________________________________________ >> Users mailing list >> Users@ovirt.org >> http://lists.ovirt.org/mailman/listinfo/users >> > > > > -- > Didi -- Didi _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: