Re: pg_dump 'die_on_errors'

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> At 02:31 AM 12/08/2004, Tom Lane wrote:
>> result of
>> considerable experience that says die_on_errors is NOT the right
>> behavior for pg_restore.

> Can you point me to examples?

Trawl the archives for pg_restore complaints ... but basically the point
is that if you fail to restore object N, that doesn't mean you should
refuse to even try to restore the objects after it. A typical example
is that ALTER OWNER TO fails because the original owner doesn't exist in
the new DB. There is no reason here not to keep plugging. If you
abort, the user will have to erase the DB, add the user (whether he
wants to or not, and whether he has the privileges to or not), and start
over. If you don't abort, the worst case is that he has to do exactly
that anyway; but he may not care, and even if he does care it may be a
lot faster to fix things by hand afterwards.

It probably would be a good idea to try to fix things to make the
restore operation less noisy (eg, ditch all the NOTICEs about creating
indexes) so that people could see the actual errors more easily. That's
not at all the same thing as putting in die-on-error, though.

regards, tom lane