Re: migrating data from 8.4 to 8.3 - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: migrating data from 8.4 to 8.3
Date
Msg-id hl0gtj$qon$1@ger.gmane.org
Whole thread Raw
In response to Re: migrating data from 8.4 to 8.3  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: migrating data from 8.4 to 8.3
Next
From: "Albe Laurenz"
Date:
Subject: Re: Postgres Triggers issue