| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: migrating data from 8.4 to 8.3 |
| Date: | 2010-02-11 08:59:33 |
| Message-ID: | hl0gtj$qon$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2010-02-11 09:57:39 | Re: Postgres Triggers issue |
| Previous Message | A. Kretschmer | 2010-02-11 08:42:09 | Re: migrating data from 8.4 to 8.3 |