https://connect.hyland.com/t5/nuxeo-forum/how-migrate-data-postgres-8-4-to-9-1/m-p/316511#M3512 <P>You can either</P> <UL> <LI>perform a pg_dump (version 9.1) remotely onto the running 8.4 or</LI> <LI>use pg_upgrade <A href="http://www.postgresql.org/docs/9.1/static/pgupgrade.html" target="test_blank">http://www.postgresql.org/docs/9.1/static/pgupgrade.html</A></LI> </UL> <P>I tried both and it works pretty fine</P> Sun, 05 Aug 2012 20:47:50 GMT Sun_Seng_David_ 2012-08-05T20:47:50Z https://connect.hyland.com/t5/nuxeo-forum/how-migrate-data-postgres-8-4-to-9-1/m-p/316510#M3511 <P>Hello,</P> <P>is there precaution or procedure to migrate database from postgres 8.4 to 9.1</P> <P>I want to test nuxeo 5.6 on a newer install. I using in production nuxeo 5.5 on ubuntu 10.04 with postgres 8.4 VM5.6 in test propose ubuntu 12.04 with postgres 9.1 (recommended)</P> <P>I mean it's a good opportunities to test migration to last supported software.</P> <P>thanks for your return of experience. etien</P> Sun, 05 Aug 2012 20:32:14 GMT https://connect.hyland.com/t5/nuxeo-forum/how-migrate-data-postgres-8-4-to-9-1/m-p/316510#M3511 etien_ 2012-08-05T20:32:14Z https://connect.hyland.com/t5/nuxeo-forum/how-migrate-data-postgres-8-4-to-9-1/m-p/316511#M3512 <P>You can either</P> <UL> <LI>perform a pg_dump (version 9.1) remotely onto the running 8.4 or</LI> <LI>use pg_upgrade <A href="http://www.postgresql.org/docs/9.1/static/pgupgrade.html" target="test_blank">http://www.postgresql.org/docs/9.1/static/pgupgrade.html</A></LI> </UL> <P>I tried both and it works pretty fine</P> Sun, 05 Aug 2012 20:47:50 GMT https://connect.hyland.com/t5/nuxeo-forum/how-migrate-data-postgres-8-4-to-9-1/m-p/316511#M3512 Sun_Seng_David_ 2012-08-05T20:47:50Z