Re: [SL] Error after re-install - Please Help!

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

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