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@xxxxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Attachment:
pgpFNs894kh1n.pgp
Description: PGP signature
