[GENERAL] Migrating Data Across Major Versions

2011-04-15 Thread Shawn Gennaria
Hi all, I'm in the process of migrating our data from 8.4 to 9.0.3 on a different server, both running Ubuntu. My initial attempt involved running pg_dumpall (from the 9.0.3 version) on the entire 8.4 cluster, putting all of the schemas, data and everything into one giant file. Jumping ahead, I a

Re: [GENERAL] Migrating Data Across Major Versions

2011-04-15 Thread Shawn Gennaria
On Fri, Apr 15, 2011 at 9:32 AM, Adrian Klaver wrote: > On Friday, April 15, 2011 5:25:51 am Shawn Gennaria wrote: >> Hi all, >> >> I'm in the process of migrating our data from 8.4 to 9.0.3 on a >> different server, both running Ubuntu.  My initial attempt invo

Re: [GENERAL] Migrating Data Across Major Versions

2011-04-18 Thread Shawn Gennaria
x, y, z, ..." at the beginning of the file and of course schemas x, y, z, etc hadn't been created yet. So there's no real cause for alarm after all. On Fri, Apr 15, 2011 at 10:23 AM, Adrian Klaver wrote: > On Friday, April 15, 2011 7:10:00 am Shawn Gennaria wrote: > &g