Re: [SL] help with error after restoring backup please

[Bob G. <bo...@rc...>]

I think that restore assumes that the database exists, but no tables or 
anything else, just a blank database.

Paul Tammes wrote:
> Use the upgrade scripts to get your backupfile up to speed.
> Presumably something like
> psql upgrade_2.14.0_2.16.2 < mybackupfile.sql
> and then later 2.16.2_2.18.x
>
> THEN (and not sooner) start admin.pl and update datasets.
> But see docs for exact commands.
>
> 2008/4/26 Mike <lak...@co...>:
>
>   
>> Hello,
>>
>> I recently installed (fresh installation - not distro upgrade)
>> Ubuntu 8.04 LTS. I was previously using Ubuntu 7.10 which was
>> distro upgraded from 7.04. I decided a clean fresh install was
>> the way to go this time so I backed up my sql-ledger (and
>> everything else I needed to keep) and did a clean install.
>>
>> I installed sql-ledger 2.8.14 and tried to restore my backup
>> but when launching sql-ledger I am receiving this error:
>> ---------------------------------------------
>> Upgrading to Version 2.8.14 ...
>> Error!
>>
>> create table curr (rn int, curr char(3) primary key, precision
>> int2)
>> ERROR: relation "curr" already exists
>> ---------------------------------------------
>> Could someone please explain this to me and what I need to do
>> the get this up and running again?
>>
>> Thanks very much!
>> Mike
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save $100.
>> Use priority code J8TL2D2.
>>
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>     
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>