On Sat, 2007-06-09 at 10:03 -0400, Mike wrote:
> I recently switched Linux distributions from OpenSUSE 10.2 to
> Ubuntu 7.04. I am now trying to get sql-ledger working again.
> I followed all the steps of the readme file and the faq. I
> also restored my previous backup (which I've done before
> without a hitch). The problem is that when I try logging in I
> am getting the following error message:
> ----------------------------------------------------------------------------------------------------------------------------
> Error!
>
> create table cargo (id int not null, trans_id int not null,
> package text, netweight float4, grossweight float4, volume float4)
> ERROR: relation "cargo" already exists
> ---------------------------------------------------------------------------------------------------------------------------
>
> I've tried creating another user and logging in as the new
> user, but I am still getting the same error and the database
> locks.
>
> Anyone have any idea how I can fix this please?
>
> Thanks,
> Mike
>
Perhaps you could do a 'pg_dumpall' on your database and then start up
with a clean database. The 'create table cargo' appears to be part of
the initialization - part of your system thinks it is starting from
scratch, but you already have the database table(s) created.
In any case, doing a 'pg_dumpall' and saving the resulting file off on
safe storage, is a good thing to do.
Bob G
|
