Re: Basic question on recovery and disk snapshotting

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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
Jov
blog: http:amutu.com/blog <http://amutu.com/blog>