[GENERAL] backup and restore questions

2004-02-20 Thread Sally Sally
Thank you all for replying. I appreciate the tips. Apologies to those who were offended by the html formating. Scott, quick question. The reason I assumed insert would be "safer" than copy is because the docs say that in the case of copy it fails on a single corrupted row whereas insert won't? S

Re: [GENERAL] backup and restore questions

2004-02-20 Thread scott.marlowe
On Fri, 20 Feb 2004, Sally Sally wrote: > Thank you all for replying. I appreciate the tips. Apologies to those who > were offended by the html formating. > Scott, quick question. The reason I assumed insert would be "safer" than > copy is because the docs say that in the case of copy it fails o

Re: [GENERAL] backup and restore questions

2004-02-19 Thread Richard Huxton
On Thursday 19 February 2004 17:41, Sally Sally wrote: > I had a few questions > concerning the backup/restore process for pg. Please don't post HTML if you can avoid it. > class=RTE>  > 1) Is it possible to dump data onto an existing > database that contains data (assumning the schema of both ar

Re: [GENERAL] backup and restore questions

2004-02-19 Thread scott.marlowe
On Thu, 19 Feb 2004, Sally Sally wrote: > I had a few questions concerning the backup/restore process for pg. >   > 1) Is it possible to dump data onto an existing database that contains data > (assumning the schema of > both are the same). Has anyone done this? I am thinking of this in order to

Re: [GENERAL] backup and restore questions

2004-02-19 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Sally Sally , I had a few questions concerning the backup/restore process for pg. 1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same). Has anyone done this? I am thinking of this in order to expediate the data load proces

[GENERAL] backup and restore questions

2004-02-19 Thread Sally Sally
I had a few questions concerning the backup/restore process for pg.   1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same). Has anyone done this? I am thinking of this in order to expediate the data load process   2) I read that wh