Re: Incrementally Updated Backups

From: Mikko Partio <mpartio(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Gabe Nell <gabe(at)kikini(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Incrementally Updated Backups
Date: 2010-09-13 09:25:10
Message-ID: AANLkTiniRnOHCv+kaG26sFr6VAdzrzxA+-3y2kzO7_xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> >> That section has been removed from the current 9.0 docs because we are
> >> unsure it works.
> >
> > Is the feature (or the documentation) still being worked on, or is
> pg_dump
> > the only way to take a backup of a warm standby while the database is
> > running?
>
> I don't think you can take a pg_dump of a warm standby without making
> recover. But I can't see why you can't use a snapshot to recover a
> warm standby, since the file system will be just a base snapshot and a
> bunch of wal files.

Sorry, I got confused with the terms. What I meant was 'hot standby', the
new feature implemented in 9.0. I guess you can take a pg_dump out of a hot
standby, right?

Regards

Mikko

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-09-13 10:16:21 Re: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
Previous Message RB 2010-09-13 09:24:13 Re: Incrementally Updated Backups