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/