On 05/05/2017 11:31 AM, Mike McLean wrote:
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.
Sorry for the very late reply here...
So, here's the Poll:
Question 1: What version of Postgres are you using for your Koji
Fedora is using the normal rhel7 one in production:
postgresql-server-9.2.18-1.el7.x86_64
In staging we are using a 9.4.x version for BDR.
instance(s)
Question 2: How would you be impacted if Koji required 9.4 or greater?
Should be fine. We would either move to the BDR version in production
(even if we dont enable it) or swtch the db server to Fedora.
kevin