Re: Enable automatic scheduled backups - Mailing list pgsql-general

From John R Pierce
Subject Re: Enable automatic scheduled backups
Date
Msg-id 4CCBF119.80002@hogranch.com
Whole thread Raw
In response to Re: Enable automatic scheduled backups  (Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>)
List pgsql-general
On 10/30/10 2:00 AM, Gabriele Bartolini wrote:
> Il 30/10/10 10:52, RP Khare ha scritto:
>> I want pgsql to take automatic scheduled backup of the database every
>> 30 minutes. How to do this?
> On Unix like systems, you can set a crontab that executes pg_dump
> every 30 minutes.
>

if the database becomes too large for this simple scheme to be practical,

implementing a PITR style continuous  WAL log archiving system will
easily stay inside the 30 minute requirement of the original request.




pgsql-general by date:

Previous
From: Gabriele Bartolini
Date:
Subject: Re: Enable automatic scheduled backups
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Unhandled exception in PGAdmin when opening 16-million-record table