Re: [SL] Upgrade problem

[Adrian B. <adr...@ie...>]

Problem was solved by installing postgres 7.3 and pointing to the old data files. Upgrade sql-ledger to latest. backup sql-ledger 
& pg_dumpall. Stopping old postgres. start postgres 8.1. edit data, i.e. output file pg_dumpall. restore database data.

Now it all works.

Thanks for assistance.

Adrian

Paul Tammes wrote:
> Adrian Blake schreef:
>> Progress:
>>
>> the error is now:
>>
>> DBD::Pg::st execute failed: ERROR: column t.validto does not exist
>> .
>> .
>> .
>>
>> ERROR: column t.validto does not exist
>>
>> I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
>> postgres 7.? to 8.1.?
>>
>> Adrian
>>
>> Dieter Simader wrote:
>>   
>>> edit the backup you made with SQL-Ledger,
>>> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
>>> (see the FAQ)
>>> restore the backup with psql
>>>
>>> psql -U sql-ledger dbname < backup.sql
>>>
>>>     
>>   
> Had the same here some time ago, the SQL-Ledger internal backup (you did 
> make one I hope) was my rescue.
> Clean install of System on a new computer, including latest of 
> everything, then unzip the sql-ledger backed up file.
> Look at version, install latest SQL-Ledger and carefully read any 
> remarks about uodating from older versions.
> Sounds like you not only uograded PostgreSQL from 7 to 8 to me.
> Rather then hacking in files I suggest using some of the update scripts 
> in the tar-balls.
> You should be up and running that way in half a day..
> 
> BTW, this is also a good way to transfer complete set of accounts from 
> say customer to bookkeeper.
> If customer uses SQL-Ledger and bookkeeper is at least able to do the 
> same that is.
> Add any needed year end corrections, like salary journal entries and 
> some amortisation.
> Do yearend report and return to customer.
> 
> 
> 
> -------------------------------------------------------------------------
> 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
> 
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30