Re: Server/Data Migration Advice

Le 12 décembre 2011 18:12, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> a écrit :
> I've finally received my new virtual database server (Debian Linux) &
> this weekend I'll be rolling my new PostgreSQL server online. My
> question is I've never migrated production data from 8.4.8 to 9.1.1. I
> would like to find out from the community what exactly is the
> recommended process in moving my database server from 8.4.8 to 9.1.1.
> I'm not simply upgrading the existing server as I will be installing
> PostgreSQL 9.1 on the new hardware and not sure if it's as simple as
> simply performing a pg_dumpall:
>
> pg_dumpall > mydata.sql

it is as simple.
You *must* use the pg_dump from 9.1.
See : http://www.postgresql.org/docs/9.1/static/upgrading.html

>
> I don't know if I need to use some kind of conversion tool to convert
> the data from 8.4.8 so that it's compatible with 9.1.1 so if you guys
> could please shine in on any recommendations, I would greatly
> appreciate it!
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation