Re: Enable automatic scheduled backups

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Enable automatic scheduled backups
Date: 2010-10-30 10:19:05
Message-ID: 4CCBF119.80002@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-10-30 10:26:27 Re: Unhandled exception in PGAdmin when opening 16-million-record table
Previous Message Gabriele Bartolini 2010-10-30 09:00:37 Re: Enable automatic scheduled backups