Re: scheduled backup - Mailing list pgsql-general

From Stephen Frost
Subject Re: scheduled backup
Date
Msg-id 20051021175853.GK6026@ns.snowman.net
Whole thread Raw
In response to scheduled backup  (Apu Islam <apuislam@gmail.com>)
List pgsql-general
* Apu Islam (apuislam@gmail.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

Attachment

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: new type question
Next
From: Douglas McNaught
Date:
Subject: Re: scheduled backup