Re: Dumping database using 8.1 or 7.1

On 8/3/06, Jonathan Vallar <bamvallar(dot)db(at)gmail(dot)com> wrote:
> 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
>

the better yu can do is try to dump the database with the 8.1's
pg_dump... but i don't know what problems can be (or if there is a
problem doing that)...

the better we can do is to wish you luck, your version is obsolete and
unsupported from some time ago...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook