[ovirt-users] Remote DB: How do you set server_version?

[Roy Golan]

On Wed, 2 May 2018 at 23:27 Jamie Lawrence <jlawrence at 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.
>
> 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 at 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 <ylavi at redhat.com> opened a bug
for it after both of got mad at it. Yaniv?

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 at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180502/9abd33e4/attachment.html>