Re: [Retrieved]RE: backup and recovery - Mailing list pgsql-admin

From Tom Lane
Subject Re: [Retrieved]RE: backup and recovery
Date
Msg-id 3823.1080171704@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Retrieved]RE: backup and recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [Retrieved]RE: backup and recovery
Next
From: "Somasekhar Bangalore"
Date:
Subject: Need a Reporting Tool for postgres 7.3.2