Re: pg_dumpall fails

Willy Wonka <lunchtime(at)onethirty(dot)org> writes:
> i don't know what my brother has been doing on the other end, but
> pg_dumpall now returns this:

> SELECT nextval ('"art_links_id_seq"');
> dumpSequence(submissions_submission_id_seq): different sequence name
> returned by SELECT: submissions_n_submission_id_seq

What he's been doing is renaming sequences ... pg_dump doesn't like
that, for no particularly good reason :-(. (This gratuitous failure
is gone in 7.3, but that doesn't help you much today.) I'd suggest
dropping and recreating the sequence, then using setval() to set its
current value correctly. Then you should be able to pg_dump.

regards, tom lane