On Friday, May 5, 2017 12:31:59 PM CDT 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.
So, here's the Poll:
Question 1: What version of Postgres are you using for your Koji
instance(s)
~]# rpm -q postgresql-server
postgresql-server-9.5.6-1.fc25.x86_64
Question 2: How would you be impacted if Koji required 9.4 or
greater?
If the upgrade process for data already in Koji's DB was handled well, then I
wouldn't be negatively affected at all.
Note that Postgres 9.4 and 9.5 are available as software collections
for
RHEL6 and RHEL7.
--
Anthony -
https://messinet.com/ -
https://messinet.com/~amessina/gallery
F9B6 560E 68EA 037D 8C3D D1C9 FF31 3BDB D9D8 99B6