Re: Backing Up - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: Backing Up
Date
Msg-id 20060204212053.GC23797@KanotixBox
Whole thread Raw
In response to Backing Up  ("James Dey" <james@mygus.com>)
List pgsql-novice
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°

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Select date & time
Next
From: Bruno Wolff III
Date:
Subject: Re: put text list into table form