Re: Scheduling backup

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Scheduling backup
Дата
Msg-id 4C2B0045.7080503@hogranch.com
обсуждение исходный текст
Ответ на Scheduling backup  (RP Khare <passionate_programmer@hotmail.com>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Massa, Harald Armin"
Дата:
Сообщение: Fwd: Scheduling backup
Следующее
От: stanimir petrov
Дата:
Сообщение: pgpool2 + slony 1 in master/slave mode with no load balance and no select replication - slaves handle all reads