Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group