Re: [SL] 2.6.22 -> 2.8.15 upgrade error

[Stuart L. <sl...@cc...>]

On 土, 2008-06-14 at 12:09 -0500, Stuart Luppescu wrote:
> I've been putting off the upgrade as long as I could, but I finally gave
> it a go. However, when I log in after following the instructions, I get
> this error:
> 
> Error!
> 
> drop trigger del_recurring ON oe
> ERROR: trigger "del_recurring" for table "oe" does not exist

Well, I just tried again and it worked (after I deleted the nologin
file). But then I found that my nightly backups using pg_dump and
restores to a mirror system stopped working about a week ago. I'm
getting these messages:

pg_restore: [tar archiver] could not open TOC file for input: No such
file or directory

The line that triggers this message is:
pg_restore -c -U sql-ledger -d dbname -F t postgresql_database-backup

The funny thing is that the backup file suddenly went from 4.1MB in size
to 9.3MB on the day it stopped working. I had upgraded postgres from
8.0.13 to 8.0.15 a few days previous, and then we had a power failure
and when the machine rebooted, these problems started.

So, since my mirror was a week out of date, I got a backup file from
System -> Backup -> Save to file, and restored that to my mirror system.
Then when I logged in I got this error message:

Upgrading to Version 2.8.15 ... 
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 REALLY need to get this working again. Any help will be greatly
appreciated.

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
Respect is a rational process   -- McCoy, "The
 Galileo Seven", stardate 2822.3