Re: Backup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backup
Дата
Msg-id 15119.1111617475@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Backup  ("Joseph M. Day" <jday@gisolutions.us>)
Список pgsql-admin
"Joseph M. Day" <jday@gisolutions.us> writes:
> It looks like pg_dump is the equivalent of a full backup, but
> how do I keep the equivalent of a Incremental, or Differential backup.

The only built-in mechanism for incremental backups at the moment is
archiving WAL logs via PITR.  See
http://www.postgresql.org/docs/8.0/static/backup-online.html

> To keep the same functionality, I will need a full backup once a week,
> and a differential once a day.

You might consider rsync'ing the database, though I'm not sure what sort
of performance that will give.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jonathan Nalley"
Дата:
Сообщение: Re: Any examples of companies using PG in high volume
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Clustering