Search Postgresql Archives

Re: migrating data from 8.4 to 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



A. Kretschmer, 11.02.2010 09:42:
In response to Thomas Kellerer :
Marc Lustig, 08.02.2010 11:36:
Hi, can we safely put the data from /var/lib/postgresql/8.4/main/ of
server x to /var/lib/postgresql/8.3/main/ of server y, considering
that the new target machine is running 8.3 whereas the old one ran
8.4 ?

No, a dump&  restore is required (as stated in the release notes)

You can also try pg_migrator. It was introduced with 8.4 and will upgrade
the data "in-place" (i.e. without a dump and restore)

I don't believe that pg_migrator can do a downgrade ...

Ooops!

I read it the wrong way round (I thought the OP wanted to migrate from 8.3 to 8.4...)

Regards
Thomas




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux