Skip site navigation (1) Skip section navigation (2)

Re: upgrade 8.0.3 -> 8.2.4

From: Steve Holdoway <steve(dot)holdoway(at)firetrust(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: upgrade 8.0.3 -> 8.2.4
Date: 2007-05-11 01:05:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Thanks, I knew about that one, and spent half a day cleaning up the data set before transfer.

That was exciting...

Cheers, Steve

On Thu, 10 May 2007 08:57:25 -0600
Dan Harris <fbsd(at)drivefaster(dot)net> wrote:

> Steve Holdoway wrote:
> > Are there any gotchas? I've got the opportunity to move to another database server for this application and yould like to take the opportunity to upgrade at the same time.
> Yes.  One of them that got me was that in 8.0.x, you could insert "invalid" 
> unicode byte sequences and it would warn you but accept them just fine.  In 8.2, 
> this is strictly enforced and you will not be able to restore your dump file 
> without running a utility to "fix" the dump file.
> This change has prevented me from doing the upgrade as my dump file is nearly 
> 100GB and the programming design of this utility requires that the whole file be 
> read into RAM before it begins processing it ( I've let it run for days and it 
> doesn't complete ).  I didn't think I had any Unicode in my database at all, but 
> I guess there are a few instances of "noise" in there that cause this..
> Hopefully this doesn't block someone else from upgrading.
> -Dan
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?

In response to

pgsql-admin by date

Next:From: Steve HoldowayDate: 2007-05-11 01:10:27
Subject: Re: upgrade 8.0.3 -> 8.2.4
Previous:From: Peter KoczanDate: 2007-05-10 23:45:38
Subject: Re: upgrade 8.0.3 -> 8.2.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group