Re: Reducing pg_dump & pg_restore times

C.M. Shivkumar wrote:
> Hello all!
>
> I have databases of sizes ranging from 30-60GB that have to be backed-up
> and restored. I want to reduce the pg_dump and pg_restore times for the
> same. Can someone throw some light on how to go about it. I have tried
> tweaking the postgresql.conf properties. Though, I am not sure what each
> property means. If someone could point to a document on the same it
> would be really helpful.

How long does a backup take (roughly) ?

This page links off to each section you need to look at:
http://www.postgresql.org/docs/8.1/static/runtime-config.html

--
Postgresql & php tutorials
http://www.designmagick.com/