| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Gabe Nell <gabe(at)kikini(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Incrementally Updated Backups |
| Date: | 2010-09-11 22:43:19 |
| Message-ID: | 201009112243.o8BMhJD23646@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gabe Nell wrote:
> > That section has been removed from the current 9.0 docs because we are
> > unsure it works.
>
> Hmm. So the only way to make a consistent backup from a standby server
> is to shut down the standby first? Or is even that problematic?
>
> Would it change anything if we are able to guarantee that the
> filesystem is snapshotted as a point-in-time snapshot by using LVM or
> on Amazon EC2 by snapshotting an EBS volume?
I believe a snapshot of the standby is fine even if it is running, just
like on the master.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick | 2010-09-12 05:45:35 | Is there a bug in FOR i IN 1..10 LOOP (8.4.4)? |
| Previous Message | Gabe Nell | 2010-09-11 22:28:41 | Re: Incrementally Updated Backups |