| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>, Naomi Walker <nwalker(at)eldocomp(dot)com>, "Mark M(dot) Huber" <MHuber(at)VMdirect(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [Retrieved]RE: backup and recovery |
| Date: | 2004-03-24 23:41:44 |
| Message-ID: | 3823.1080171704@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> My bigger issue is that COPY will fail on a single row failure, and
> nothing will be in the table, while INSERT will not.
In theory, there shouldn't be any failures, because the data was known
valid when it was dumped.
Of course, practice often differs from theory, but I wonder whether we
aren't talking about palliating a symptom instead of fixing the real
problem.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Sudakov | 2004-03-25 04:21:16 | automatic pg_dumpall |
| Previous Message | Bruce Momjian | 2004-03-24 23:07:37 | Re: [Retrieved]RE: backup and recovery |