Re: [SL] Problems upgrading from 2.6.27 to 2.8.0

[Tage D. <ta...@ht...>]

George Osvald wrote:
> 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
>>     
>
>   
The problem is not backup, I made at filebackup of database and 
sql-ledger, and I am running 2.6.27 very OK, but I like to upgrade to 
2.8 due to new features, and this is not running.

Tage from Denmark