Re: Backing Up

James Dey <james(at)mygus(dot)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°