On Monday May 15 2006 11:14 am, Vivek Khera wrote: > On May 14, 2006, at 12:27 AM, Ed L. wrote: > > While watching a 9-hour 60GB network load from 7.4.6 pg_dump > > into 8.1.2, I noticed the order in which indices and > > constraints are created appears to be their creation order. > > If you use the 8.1.2 pg_dump to make the dump from your 7.4.6 > DB, what is the order like? > I suspect it would be more to what you're expecting. In > general, you should use the pg_dump corresponding to the > version into which you are loading for best results. 8.1.2 has same problem (try attached script to see). Ed
Attachment:
test.sh
Description: application/shellscript
