Re: scheduled backup

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Apu Islam <apuislam(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: scheduled backup
Date: 2005-10-21 17:58:53
Message-ID: 20051021175853.GK6026@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Apu Islam (apuislam(at)gmail(dot)com) wrote:
> 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 ?

PITR.

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-10-21 18:02:35 Re: scheduled backup
Previous Message Jim C. Nasby 2005-10-21 17:52:33 Re: new type question