On Thu, May 3, 2018 at 9:53 AM, Yedidyah Bar David <didi@redhat.com> wrote:
On Thu, May 3, 2018 at 12:13 AM, Roy Golan <rgolan@redhat.com> wrote:
On Wed, 2 May 2018 at 23:27 Jamie Lawrence <jlawrence@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.stack@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:
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