Re: DB Dump Size - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: DB Dump Size
Date
Msg-id 20080815102432.GA10831@easy2.in-chemnitz.de
Whole thread Raw
In response to Re: DB Dump Size  (<steve@outtalimits.com.au>)
Responses Re: DB Dump Size  (<steve@outtalimits.com.au>)
List pgsql-admin
On Fri, Aug 15, 2008 at 11:09:02AM +1000, steve@outtalimits.com.au 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

pgsql-admin by date:

Previous
From:
Date:
Subject: Re: DB Dump Size
Next
From: Carol Walter
Date:
Subject: Re: New postgres installation