migrating data from 8.4 to 8.3

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 ?

Rgards
Marc

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)

Regards
Thomas

In response to Marc Lustig :

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!

Make a regular Backup und restore that Backup. Consider, 8.4 contains
features that not in 8.3, maybe you are not able to do this.

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

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 ...

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

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