Re: Reducing pg_dump & pg_restore times

From: Chris <dmagick(at)gmail(dot)com>
To: "C(dot)M(dot) Shivkumar" <shivkumar(dot)cm(at)gmail(dot)com>
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reducing pg_dump & pg_restore times
Date: 2006-10-26 05:40:26
Message-ID: 45404A4A.5030907@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-10-26 06:20:25 Re: Reducing pg_dump & pg_restore times
Previous Message C.M. Shivkumar 2006-10-26 05:10:02 Reducing pg_dump & pg_restore times