880744 - Add json_enhancements to jenkins PostgreSQL

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Selena Deckelmann :selenamarie :selena]

I've set up a make target that builds json_extensions for PostgreSQL:

https://github.com/selenamarie/socorro/blob/31e166cf19fccf8b3ca51a2fb6a6f3aaf503b0a1/Makefile#L105

It's in a branch and not committed to core Socorro yet because to test it with jenkins, it needs to be installed :D

Classic chicken-and-egg.

Getting this running requires: 

* pgxnclient (Python module)
* sudo access to install modules in `pg_config --pkglibdir`

Once installed, the module is unobtrusive and then can be used by anyone wishing to play around with the JSON datatype by running 'create extension json_enhancements' in their database.

Comment 1

[Selena Deckelmann :selenamarie :selena]

And -- the Makefile does all the right things to get the python modules going -- so really, if you use that Makefile target, all you should need to do to install is: 

   make json

Comment 2

[Selena Deckelmann :selenamarie :selena]

This dependency is blocking a Q2 goal. Not an incredibly urgent rush, but would like to take care of it next week sometime.

Comment 3

[Brandon Burton [:solarce]]

(In reply to Selena Deckelmann :selenamarie :selena from comment #0)
> I've set up a make target that builds json_extensions for PostgreSQL:
> 
> https://github.com/selenamarie/socorro/blob/
> 31e166cf19fccf8b3ca51a2fb6a6f3aaf503b0a1/Makefile#L105
> 
> It's in a branch and not committed to core Socorro yet because to test it
> with jenkins, it needs to be installed :D
> 
> Classic chicken-and-egg.
> 

It's not entirely clear what action you need from web ops

> Getting this running requires: 
> 
> * pgxnclient (Python module)

There is a 1.2 version in our pgdg-92-redhat repo, is that version sufficient?

> * sudo access to install modules in `pg_config --pkglibdir`
> 

Are you requesting sudo access to the jenkins master so you can install modules? 

If these are for a system-wide installation we need to be able to install them via Puppet

Comment 4

[Selena Deckelmann :selenamarie :selena]

(In reply to Brandon Burton [:solarce] from comment #3)
> (In reply to Selena Deckelmann :selenamarie :selena from comment #0)
> > I've set up a make target that builds json_extensions for PostgreSQL:
> > 
> > https://github.com/selenamarie/socorro/blob/
> > 31e166cf19fccf8b3ca51a2fb6a6f3aaf503b0a1/Makefile#L105
> > 
> > It's in a branch and not committed to core Socorro yet because to test it
> > with jenkins, it needs to be installed :D
> > 
> > Classic chicken-and-egg.
> > 
> 
> It's not entirely clear what action you need from web ops
> 
> > Getting this running requires: 
> > 
> > * pgxnclient (Python module)
> 
> There is a 1.2 version in our pgdg-92-redhat repo, is that version
> sufficient?

Yes!

> 
> > * sudo access to install modules in `pg_config --pkglibdir`
> > 
> 
> Are you requesting sudo access to the jenkins master so you can install
> modules? 

No

> If these are for a system-wide installation we need to be able to install
> them via Puppet

Hmmm. :( There's no packages other than pgxn-managed installation. Does that count? 

pgxn can install the package and manage it via puppet.

Comment 5

[Brandon Burton [:solarce]]

I built an RPM of the compiled module using fpm

[[e-mail]1 ~]# yum info postgresql92-json_enhancements
Loaded plugins: downloadonly, rhnplugin, security
This system is receiving updates from RHN Classic or RHN Satellite.
Installed Packages
Name        : postgresql92-json_enhancements
Arch        : x86_64
Version     : 1.0
Release     : 1
Size        : 208 k
Repo        : installed
From repo   : mozilla
Summary     : no description given
URL         : http://example.com/no-uri-given
License     : unknown
Description : no description given

Things are installed exactly the same as a 'pgxn install json_enhancements' and using 1.0.0 from pgxn

[e-mail]1 ~]# locate json_enhancements
/usr/pgsql-9.2/share/extension/json_enhancements--1.0.0.sql
/usr/pgsql-9.2/share/extension/json_enhancements.control
/usr/share/doc/pgsql/extension/json_enhancements.md