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

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

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
>
>