Enable automatic scheduled backups

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.

--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it

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.

On 30/10/2010 09:52, RP Khare wrote:

I want pgsql to take automatic scheduled backup of the database every 30
minutes. How to do this?

There isn't a scheduler built into PostgreSQL; you use cron or similar.
Have a read here too:

http://www.postgresql.org/docs/9.0/static/backup.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie