Re: file-system snapshot under freebsd for backup

On Thu, Aug 02, 2007 at 09:49:42PM +0800, ProAce wrote:
> The size of my db is more then 50GB , so I consider that the pg_dump
> is not a good backup tool for me.
> And, sometimes, I need query data which is some days ago ( between 1 ~
> 14 days ).
>
> If I want to transfer my db to different PG version, I will use slony-I. :)
>
> I worried that mksnap_ffs spend much time on making a new snapshot.
> I don't know whether PG work very well during the period of making snapshot.
> Or the snapshot be made successfully when the PG execute / commit sql
> statments continuously.

If you're worried then just use PITR with a more conventional copy
mechanism. You don't have to use snapshots.
--
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)