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.
On Fri, May 5, 2017 at 1:31 PM, Mike McLean mikem@redhat.com 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)
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.
I have been using PostgreSQL 9.6 for the most part, though I have some using PostgreSQL 9.5 as well. I don't have a problem with PostgreSQL 9.4 as a minimum requirement.
Question 1: What version of Postgres are you using for your Koji
instance(s)
Postgres 8.4
Question 2: How would you be impacted if Koji required 9.4 or greater?
I could move my databases to EL7, but I'd rather stick with the system postgres.
How would Koji be packaged for EPEL under this plan? I don't believe SCL packages are contained in EPEL.
Pat
On 05/05/2017 01:40 PM, Pat Riehecky wrote:
Question 1: What version of Postgres are you using for your Koji
instance(s)
Postgres 8.4
Question 2: How would you be impacted if Koji required 9.4 or greater?
I could move my databases to EL7, but I'd rather stick with the system postgres.
Base EL7 version is 9.2.7. So you still need SCL here (which is readily available for RHEL and CentOS).
How would Koji be packaged for EPEL under this plan? I don't believe SCL packages are contained in EPEL.
It's a database requirement, not a installed package requirement. Postgres is not necessarily running on the same host as kojihub (and I suspect often is not).
On May 05 13:31, 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)
Currently in cbs.centos.org we're using Postgres 8.4 (from base in CentOS 6)
Question 2: How would you be impacted if Koji required 9.4 or greater?
We could likely coordinate an upgrade/migration if needed.
Note that Postgres 9.4 and 9.5 are available as software collections for RHEL6 and RHEL7.
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.
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
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
koji-devel@lists.fedorahosted.org
-
Anthony Joseph Messina -
Brian Stinson -
Dennis Gilmore -
Kevin Fenzi -
Mike McLean -
Neal Gompa -
Pat Riehecky