Skip site navigation (1) Skip section navigation (2)

Re: WAL and pg_dump

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Mike C <smith(dot)not(dot)western(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL and pg_dump
Date: 2005-12-22 22:17:32
Message-ID: 1135289852.2964.542.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:
> On 12/22/05, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>         On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
>         > All the documentation I've seen for PITR points to having to
>         do a file
>         > system copy of sorts.
>         Yes. There's no other way, but why would you want another way?
> Mainly because a pg_dump backup takes up a lot less disk space than a
> filesystem copy (in my case, approx 3.5GB backup from a 25GB db). 

What is your backup time in each case, and what is your recovery time?

Is space your limiting factor? 

Best Regards, Simon Riggs

In response to


pgsql-admin by date

Next:From: Tom LaneDate: 2005-12-22 23:21:38
Subject: Re: Create Index Locking Question
Previous:From: Mike CDate: 2005-12-22 21:09:28
Subject: Re: WAL and pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group