Re: [SL] 2.6.22 -> 2.8.15 upgrade error

[Stuart L. <sl...@cc...>]

On 日, 2008-06-15 at 00:33 +0200, Paul Tammes wrote:
> Upgrading and restoring at the same time?  Seems a bit tricky to begin
> with.
> 
> If all else fails first restore to same version then do upgrades
> later. But maybe this helps:
> 
> Did you use the upgrade-2.x.x-databasename_2.x.y-databasename scripts
> before letting postgres or SQL-Ledger have a second go?
> If not i strongly suggest you do that, saved my ass in the past
> getting from a blown 2.2 to a new 2.4 iirc..

I downgraded back to 2.6.27, restored from the backup, and everything
was fine. Then I tried upgrading to 2.8.1 and got the same message as
before:
Error!
create table cargo (id int not null, trans_id int not null, package
text, netweight float4, grossweight float4, volume float4)
ERROR: relation "cargo" already exists

I tried over and over, but I keep getting the same message. This is
getting frustrating.

Paul, where do I get those upgrade scripts you mention?

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
Denver, n.:  A smallish city located just below
 the `O' in Colorado.