Re: Reducing pg_dump & pg_restore times - Mailing list pgsql-general

From Chris
Subject Re: Reducing pg_dump & pg_restore times
Date
Msg-id 45404A4A.5030907@gmail.com
Whole thread Raw
In response to Reducing pg_dump & pg_restore times  ("C.M. Shivkumar" <shivkumar.cm@gmail.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: "C.M. Shivkumar"
Date:
Subject: Reducing pg_dump & pg_restore times
Next
From: Chris
Date:
Subject: Re: Reducing pg_dump & pg_restore times