Re: restore whoes - Mailing list pgsql-admin

From Tom Lane
Subject Re: restore whoes
Date
Msg-id 7010.1013443371@sss.pgh.pa.us
Whole thread Raw
In response to Re: restore whoes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: restore woes
Re: restore whoes
List pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I think we can live with it _if_ we report a proper error message and
> suggest a solution.

Looking for a way to report an error message misses the point entirely,
IMHO (even if it weren't a horrid kluge).  I don't want to report an
error message; I want to read the file successfully.  If the file in
question is your dump from an already-erased previous version, being
told that you messed it up is no help.

Adding options to the COPY command is no help either, because the COPY
may be embedded in a multi-gigabyte dump file that you can't edit
conveniently.  (And what of pg_restore, or other applications that
generate COPY commands?)  My approach of using a GUC variable is better
because it can be set from outside the dump script --- in
postgresql.conf, if necessary.

            regards, tom lane

pgsql-admin by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: pg_upgrade cmdline issue
Next
From: Naomi Walker
Date:
Subject: Re: restore woes