Re: [SL] 2.6.22 -> 2.8.15 upgrade error

[Paul T. <pt...@wa...>]

in the /sql dir there are sripts named Pg-upgrade-2.0.8-2.2.0.sql etcetera
Start on the one you have and work up to actual version: bos is now part of
the family ;-)

2008/6/22 Stuart Luppescu <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.
>
>
>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>