Thread: 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, consideringthat the new target machine is running 8.3 whereas the old one ran 8.4 ? Rgards Marc
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, consideringthat 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