| 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: | Whole Thread | Raw Message | 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 ...
| 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 |