Re: Incrementally Updated Backups - Mailing list pgsql-general

From Mikko Partio
Subject Re: Incrementally Updated Backups
Date
Msg-id AANLkTiniRnOHCv+kaG26sFr6VAdzrzxA+-3y2kzO7_xg@mail.gmail.com
Whole thread Raw
In response to Re: Incrementally Updated Backups  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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 

pgsql-general by date:

Previous
From: Yaroslav Tykhiy
Date:
Subject: Re: Query plan choice issue
Next
From: MailingLists
Date:
Subject: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)