Dumping database using 8.1 or 7.1

From: "Jonathan Vallar" <bamvallar(dot)db(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dumping database using 8.1 or 7.1
Date: 2006-08-03 09:59:03
Message-ID: 94aba7f30608030259s1f46928v89520b2028ff911f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I have a corrupt database that runs on Postgres 7.1.2. I was able to repair
the database where I can now connect to the database and do queries.

I have a migration plan to transfer my database to a Postgres 8.1. I
encountered problems when I was dumping the database. Postgres 7.1 reported:
getTables(): SELECT (funcname) for trigger trig_mis_t_ins returned 0 tuples.
Expected 1.

The trig_mis_t_ins trigger is no longer found on the database but it is
still listed at the database. With this, I assume the database is corrupt.

Would my problems go away if I dump it on postgres 8?

Thanks.

Regards,

Jonathan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Rengstl 2006-08-03 10:27:36 Re: Query performance
Previous Message Chris Mair 2006-08-03 09:57:06 Re: Query performance