I am also curious as to why an SQL dump from the production server would come out to 2.8G but a dump of an exact replica on a test box would come out to 3.0G. What determines the size and makeup of an SQL dump? Cheers. Steve. On Fri, 15 Aug 2008 12:24:32 +0200, Tino Schwarze <postgresql@xxxxxxx> wrote: > On Fri, Aug 15, 2008 at 11:09:02AM +1000, steve@xxxxxxxxxxxxxxxxxx wrote: >> Nice, that has cleared it up. >> >> I am on 8.1 also. >> >> On my test box, a standard dump took 6m 26sec & a -Fc dump took 11min > 2sec. >> That's not a great difference, but the size difference is quite > noticeable. > > You might use --compress=6 or even --compress=1 to lower the impact of > compression and try again. On the other hand, 11 minutes is not a big > deal for dumping a whole DB... > > Tino. > > -- > "What we nourish flourishes." - "Was wir nähren erblüht." > > www.craniosacralzentrum.de > www.forteego.de > >
