Re: Backing Up

James Dey <james@mygus.com> schrieb:
> The problem is, when I restore my DB I get a lot of parser errors on the
> sequences and things like ERROR:  Relation "taxname_id_seq" does not exist
> ERROR:  Relation "taxdata_id_seq" does not exist
> ERROR:  Relation "taxlink_id_seq" does not exist
>
> This is on 7.3 red hat edition, restored from 7.3 normal edition.

7.3 is out of lifetime and has few errors, including errors with wrong
order of objects in backup-dumps.

You can try to list the objects in the dump with -l and manually reorder
this list and use pg_restore with -L new_list to solve the problem.
Read the man-page 'man pg_restore' and search for -l, -L now.


And, of course, upgrade your system!


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°