Postgres Pro
Downloads
Home   >   mailing lists

Re: Scheduling backup - Mailing list pgsql-general

From John R Pierce
Subject Re: Scheduling backup
Date
Msg-id 4C2B0045.7080503@hogranch.com
Whole thread Raw
In response to Scheduling backup  (RP Khare <passionate_programmer@hotmail.com>)
List pgsql-general
Tree view 
On 06/30/10 12:37 AM, RP Khare wrote:
> Is there any way to schedule PGSQL databases backups?  I want to take
> hourly dumps of my production database.


if those are your backup requirements, you should take a look at PITR,
Point In Time Recovery, where you take just an occasional full database
dump, then archive WAL logs which record the changes to the database,
minute by minute.

these logs can be used to play back the database transactions to any
specific Point In Time.

pgsql-general by date:

Previous
From: "Massa, Harald Armin"
Date:
Subject: Fwd: Scheduling backup
Next
From: stanimir petrov
Date:
Subject: pgpool2 + slony 1 in master/slave mode with no load balance and no select replication - slaves handle all reads