Laurent Glaude | 22 Dec 17:10
Favicon

Migrating from HSQLDB to PostgreSQL 8.1

Hello,

 

I have a Nuxeo 5.1.6 installation that currently runs on the default HSQLDB setup (CentOS 5.2). I have read that it is not recommended, so I have installed PostgreSQL 8.1.1 and I will be soon working on trying to migrate our current HSQLDB to Postgre.

 

Has anyone done it before? I would like to know what the recommended steps to do so are, or at least if there are best practices and pitfalls I should beware.

 

Thanks,

 

-Laurent

 

Laurent Glaude

Programmeur Analyste | Programmer Analyst

Services informatiques aux étudiants | Student IT Services

lglaude-870xbScz6v+w5LPnMra/2Q@public.gmane.org

Tél. | Tel. : (613) 562-5800x1672

800-1 Nicholas

Ottawa ONCanadaK1N 7B7

 

www.uOttawa.ca

Université d'Ottawa | University of Ottawa

L'Université canadienne | Canada's University

 

_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
Florent Guillaume | 22 Dec 19:30

Re: Migrating from HSQLDB to PostgreSQL 8.1

Hi,

Please note that we don't support Nuxeo with PostgreSQL 8.1, only  
PostgreSQL 8.2.
It may very well work in 8.1 without a hitch but we don't recommend or  
support it (and it's quite old).
For Nuxeo 5.2, PostgreSQL >= 8.3.4 will be the supported version.

Florent

On 22 Dec 2008, at 17:13, Laurent Glaude wrote:
> I have a Nuxeo 5.1.6 installation that currently runs on the default  
> HSQLDB setup (CentOS 5.2). I have read that it is not recommended,  
> so I have installed PostgreSQL 8.1.1 and I will be soon working on  
> trying to migrate our current HSQLDB to Postgre.
>
> Has anyone done it before? I would like to know what the recommended  
> steps to do so are, or at least if there are best practices and  
> pitfalls I should beware.
>
> Thanks,
>
> -Laurent

--

-- 
Florent Guillaume, Head of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87
jiveforums | 25 Mar 17:48

Re: Migrating from HSQLDB to PostgreSQL 8.1

hello, 
can you please tell me how can I migrate HSQLDB to PostgreSQL ? 

thank you,
--
Posted by "bem" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2190#6344>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Julien CARSIQUE | 25 Mar 17:14

Re: Migrating from HSQLDB to PostgreSQL 8.1

Hello,

Here is information about migrating document repository storage:
http://doc.nuxeo.org/xwiki/bin/view/Main/JCRMigration
http://doc.nuxeo.org/xwiki/bin/view/Main/MigrateViaJCRIO

Regards,
Julien

jiveforums-ecm@... a écrit :
> hello, 
> can you please tell me how can I migrate HSQLDB to PostgreSQL ? 
>
>
> thank you,
> --
> Posted by "bem" at Nuxeo Discussions <http://nuxeo.org/discussions>
> View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2190#6344>
> _______________________________________________
> ECM mailing list
> ECM@...
> http://lists.nuxeo.com/mailman/listinfo/ecm
> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>   

--

-- 
Julien Carsique, Nuxeo (Paris, France)
www.nuxeo.com - The Open Source ECM Platform - www.nuxeo.org
Nuxeo ECM Stack - The Java EE, scalable, standard-based ECM Platform
jcarsique@... | Tel: +33 1 40 33 79 87

_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

tdelprat | 25 Mar 19:46

Re: Migrating from HSQLDB to PostgreSQL 8.1

Hi,

You should probably specify what data you are talking about (nuxeo uses 
several datasources).

If you want to migrate all the data from a default (unconfigured) nuxeo, you 
should at last tell us what version of nuxeo you are using.

Tiry

----- Original Message -----
From: ecm-bounces@... <ecm-bounces@...>
To: ecm@... <ecm@...>
Sent: Wed Mar 25 17:48:45 2009
Subject: Re: [Ecm] Migrating from HSQLDB to PostgreSQL 8.1

hello,
can you please tell me how can I migrate HSQLDB to PostgreSQL ?

thank you,
--
Posted by "bem" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: 
<http://www.nuxeo.org/discussions/thread.jspa?threadID=2190#6344>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm


Gmane