<html><div style='background-color:'><DIV class=RTE>I had a few questions concerning the backup/restore process for pg. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>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</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>2) I read that when dumping and restoring data the insert option is safer but slower than copy? Does anyone know from experience how much slower (especially for a database containing millions of records).</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>3) can pg_restore accept a file that is not archived like a zipped file or plain text file (file.gz or file)</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>4) Is the general practise to have one whole dump of a database or several separate dumps (by table etc...)?</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Thanks a lot</DIV>
<DIV class=RTE>Sally</DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2746??PS=">Take off on a romantic weekend or a family adventure to these great U.S. locations.</a> </html>