Skip site navigation (1) Skip section navigation (2)

Re: [Retrieved]RE: backup and recovery

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Victor SudakovDate: 2004-03-25 04:21:16
Subject: automatic pg_dumpall
Previous:From: Bruce MomjianDate: 2004-03-24 23:07:37
Subject: Re: [Retrieved]RE: backup and recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group