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 Igrishin||Date: 2010-10-30 10:26:27|
|Subject: Re: Unhandled exception in PGAdmin when opening
|Previous:||From: Gabriele Bartolini||Date: 2010-10-30 09:00:37|
|Subject: Re: Enable automatic scheduled backups|