Re: [SL] Problems upgrading from 2.6.27 to 2.8.0

[George O. <geo...@ya...>]

On Tuesday 03 April 2007 03:56, Tage Danielsen wrote:
> Dieter Simader wrote:
> > The easiest is to restore from a backup, delete the second record in the
> > defaults table and upgrade again.
> >
> > If you don't have a backup you have no choice but to do a manual upgrade
> > from the point on when the upgrade script failed. The upgrade failed in
> > Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults table.
>
> Sorry it don't work, and come with this error

I have done this once before for earlier version. If you do not have backup or 
at least system backup to get back to previous version you will have to go 
manually and delete all existing files, tables and edit the sql file error by 
error. Every time you do something run the setup it will give you another 
error. Then you will have to back track and repeat all the steps you have 
made to that point and so on. It is painfull but it will teach you one thing:
Always have a backup before any upgrade.


> Upgrading to Version 2.8.0 ...
> Error!
>
> create table cargo (id int not null, trans_id int not null, package
> text, netweight float4, grossweight float4, volume float4)
> ERROR: could not create relation 1663/17233/111289: Filen eksisterer
> {file exist}
>
> hope it will be better
>
> Tage from Denmark
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-- 
George
AUSTRALIA
http://www.okstudio.com.au