xTuple.com xTupleU Blog & News Customer Support

PostgreSQL 9.4.x

 

Is there any specific reason or issue preventing official support for PostgreSQL 9.4.x?  Or it is just not tested yet?

 

Looking at the Linux world, PostgreSQL is becoming quite common

 

Debian oldstable / wheezy has 9.1 and no plv8 package

Debian stable / jessie has 9.4 and it does have the plv8 package for 9.4 too:

https://packages.debian.org/search?keywords=postgresql-9.4-plv8

 

Ubuntu's current stable release, 15.04 (Vivid Vervet) and the next stable release, 15.10 (Wily Werewolf) has 9.4:

https://launchpad.net/ubuntu/+source/postgresql-9.4

 

Ubuntu LTS 14.04 (Trusty Tahr) has 9.3:

https://launchpad.net/ubuntu/+source/postgresql-9.3

 

RHEL 7 / CentOS 7 have PostgreSQL 9.2

 

Fedora 22 and 23 have PostgreSQL 9.4.x

https://apps.fedoraproject.org/packages/postgresql-server

I can give you anecdotal information... but naturally don't assume this is official xTuple support: it's not.  I appreciate that it's not what you're asking for exactly, but perhaps it provides some context.

I currently do my xTuple related development work with the database loaded in 9.4 and have really since about 9.3 was officially supported by xTuple.  Based on the changes in 9.4, there are no breaking changes that jumped out at me.  I also have a small client that I've got on 9.4 with xTuple since we needed the JSON support; they've haven't got any compatibility problems and they've now been running for a few months.

Having said all that, I won't put larger clients on 9.4 until it's blessed by xTuple and "officially" supported.  Also, we've not exercised plv8 that comes from the 9.4 PostgreSQL Global Development Group apt repos with xTuple... so it's possible that there are issues still latent there.  Having now worked with a fair amount with plv8/9.4 on non-xTuple projects, I'm a bit weary of the extension at this point and would likely want to test it really extensively before jumping in on any version change in the extension.  

 

Ok, so I ran it for some basic accounting tasks and for my purposes it appears to be OK, no problems observed so far.  This doesn't mean it is ready for xTuple to officially support of course, but it is positive.

 

The exact steps I followed:

- set up Debian 8 (jessie)

- install the packages postgresql-9.4 postgresql-contrib and postgresl-9.4-plv8 - the exact versions:

postgresql-9.4                 9.4.3-0+deb8u1

postgresql-9.4-plv8            1.4.2.ds-2

postgresql-contrib             9.4+165

postgresql-contrib-9.4         9.4.3-0+deb8u1

 

- add the necessary config to /etc/postgresql/9.4/main/postgresql.conf

plv8.start_proc = 'xt.js_init'
 

 

- dump the database from the old server using pg_dump

- load the database on the new server using pg_restore

- log in with psql and run

create extension if not exists plv8;

 

- run the Postbooks updater utility

- then I logged in and made some accounting entries and looked at some reports