From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
---|---|
To: | Apu Islam <apuislam(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: scheduled backup |
Date: | 2005-10-21 18:02:35 |
Message-ID: | m23bmusq84.fsf@Douglas-McNaughts-Powerbook.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Apu Islam <apuislam(at)gmail(dot)com> writes:
> I need suggestion to backup my postgresql server. The database is growing
> 1/2 Gb a day and I am looking for a solution that would push the data off
> to the backup server periodically with minimal amount of load to the
> server (I am trying to avoid table locking). I am thinking to use rsync to
> sync the data directories periodically. will that allow me to retrieve the
> data in case of a disaster ? what is the best practise ?
If you're using 8.0.X, you should be able to use rsync along with WAL
shipping to save the data files and the WAL files on a remote machine.
You can then use the PITR mechanism to restore if you need to--see the
docs.
BTW, pg_dump doesn't lock any tables.
-Doug
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2005-10-21 18:10:57 | Re: scheduled backup |
Previous Message | Stephen Frost | 2005-10-21 17:58:53 | Re: scheduled backup |