topic Re: NUXEO upgrade-from 5.3.2 to 5.5 in Nuxeo Forum

NUXEO upgrade-from 5.3.2 to 5.5

elvis_ — Mon, 13 Aug 2012 10:17:42 GMT

Hi All, I am running nuxeo5.3.2 in a debian with default database(h2). I tried to upgrade nuxeo to 5.5 with postgresql as a database, but didn't succeed!!! Can anybody tell me how can i take sql dump from h2 or a way to upgrade from 5.3 to 5.5. Hope somebody help me.. Thanks in advance

Re: NUXEO upgrade-from 5.3.2 to 5.5

elvis_ — Tue, 14 Aug 2012 09:36:30 GMT

Hello, Can anybody help me please ??

Re: NUXEO upgrade-from 5.3.2 to 5.5

bruce_Grant — Tue, 14 Aug 2012 19:07:33 GMT

Have you tried upgrading to 5.5 without changing the database? That is, make sure the upgrade in place works. Once you have moved to 5.5 then you can figure out how to change migrate the database platform.

Re: NUXEO upgrade-from 5.3.2 to 5.5

elvis_ — Thu, 16 Aug 2012 14:25:15 GMT

Hi Bruce,

Re: NUXEO upgrade-from 5.3.2 to 5.5

bruce_Grant — Thu, 16 Aug 2012 18:00:52 GMT

This is where the documentation is a little on the light side. I will be trying the same in the next few weeks and will let you know what happens, however, I'm using Postgresql.

Re: NUXEO upgrade-from 5.3.2 to 5.5

elvis_ — Mon, 20 Aug 2012 09:49:57 GMT

I tried upgrading to 5.5 without changing the database by copying the folders

Re: NUXEO upgrade-from 5.3.2 to 5.5

Julien_Carsique — Tue, 04 Sep 2012 18:30:52 GMT

Hi,

As suggested by bruce, you could first upgrade, then change the database. But I would recommend to start with the migration from h2 to PostgreSQL, then upgrade (that order may be easier and stronger: since H2 is dedicated to development environments, we don't care a lot about upgrading H2 data).

About SQL dump from H2, there is a lot of information on Internet, including dedicated information about Nuxeo (I remember this has been discussed a lot on the forum, mailing lists, ...). Maybe that old script could help you.

You could also use the Nuxeo export feature then import your data in a Nuxeo configured to use PostgreSQL.

All upgrades are described in the How to upgrade Nuxeo documentation. You will have to upgrade step by step from 5.3.2 to 5.6, not directly. Think to carefully read upgrade notes about PostgreSQL.