Re: problems restoring 7.2.1 dump to 7.3.2

From: Ralph Graulich <maillist(at)shauny(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problems restoring 7.2.1 dump to 7.3.2
Date: 2003-05-05 09:05:41
Message-ID: Pine.LNX.4.53.0305051100240.27448@shauny.shauny.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Andrew,

> Yes, I believe what Tom was suggesting is that you'll have to
> re-order the restore. You can do this with the binary formats. You
> need to generate a catalogue from the dump file, and then edit that
> by hand.

Thanks for your input. Finally I managed to do a full export old from old
version - import in new version cycle without any significant errors.
Although it was a tedious work, sorting depending relations (e.g. sequence
-> table -> triggers -> views -> pl/pgsql-procedures - failing, depending
on another table, so next sequence, next table, trigger, former
pl/pgsql-procedure, ah, needs another trigger it's referring to, etc.).

It took me a whole three days to rearrange about nearly 1.400 database
objects, couting sequences, triggers, tables, views, rules and pl/pgsql
procedures. So, one thing I learned: Before extending my project, first
accomplish a working upgrade path by writing down all dependencies ;-)

Kind regards and thanks for your help again, Tom and Andrew
... Ralph ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-05-05 09:30:04 Re: Postgres Java Connection not closing.. Too many Clients Problem
Previous Message John Kunchandy 2003-05-05 08:43:06 Postgres Java Connection not closing.. Too many Clients Problem