| 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: | Whole Thread | Raw Message | 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
| 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 |