Postgres Pro
Downloads
Home   >   mailing lists

Re: Basic question on recovery and disk snapshotting - Mailing list pgsql-general

From Jov
Subject Re: Basic question on recovery and disk snapshotting
Date
Msg-id CADyrUxNceRYH4Gdu0M7t4RPD0tBjRSpkHh61-tKQzn7J33=9Pg@mail.gmail.com
Whole thread Raw
In response to Basic question on recovery and disk snapshotting  (Yang Zhang <yanghatespam@gmail.com>)
Responses Re: Basic question on recovery and disk snapshotting
List pgsql-general
Tree view
Are you sure the EBS snapshot is consistent? if the snapshot is not consistent,enven on the same volume,you will have prolbems with your backup.

One methed can be try is run pg_start_backup() before take snapshot.




2013/4/27 Yang Zhang <yanghatespam@gmail.com>
We're running on EBS volumes on EC2.  We're interested in leveraging
EBS snapshotting for backups.  However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?

(I believe) the usual reasoning for separating pg_xlog onto a separate
volume is for performance.  However, if they are on different volumes,
the snapshots may be out of sync.

Thanks.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




--
Jov

pgsql-general by date:

Previous
From: Misa Simic
Date:
Subject: Re: Optimizing bulk update performance
Next
From: Tobias Oberstein
Date:
Subject: outgoing TCP from custom background worker?