sql-ledger-users

[SL] help with error after restoring backup please

[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

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

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
>