El vie, 05-05-2017 a las 13:31 -0400, Mike McLean escribió:
We've been using json in the database more and more, but because
not
all
versions of Postgres have special support for it, we've been storing
it
in text fields.
Postgres 9.4 and up support a jsonb type that has some really nice
features. It would be really nice for us to use in Koji. Koji could
actually query based on structural data in a jsonb field, and even
index
on it.
So, here's the Poll:
Question 1: What version of Postgres are you using for your Koji
instance(s)
Question 2: How would you be impacted if Koji required 9.4 or
greater?
Note that Postgres 9.4 and 9.5 are available as software collections
for
RHEL6 and RHEL7.
In fedora we are using postgresql-server-9.2.18-1.el7.x86_64 from base
RHEL 7. Infrastructure has a policy of not using SCL's so if this
happened we would have to move postgresql to a Fedora server. However
in stage infrastructure is currently running postgresql-bdr94-server-
9.4.11_bdr1-1_2ndQuadrant.el7.centos.x86_64 in order to have BDR
support, so moving to a platform fully supporting BDR would be welcome.
Dennis