Re: Real time backup options.

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Real time backup options.
Дата
Msg-id bf54be870802080530s42e0f60fg2c551c535f418633@mail.gmail.com
обсуждение исходный текст
Ответ на Real time backup options.  (Michael Lush <mjlush@ebi.ac.uk>)
Список pgsql-novice
>>On Feb 8Gmail - [NOVICE] Real time backup options. - shoaibmir@gmail.com, 2008 5:22 PM, Michael Lush <mjlush@ebi.ac.uk> wrote:

>>I run a modest postgres database manualy edited (via a web fron end) by
>>3-4 people. So the number of transactions is comparativly low.

>>I'd like to set up some sort of real time backups



Did you look at using PITR as an option, specifically using record based log shipping with 'pg_xlogfile_name_offset()' as that might help in your case. You can find details about that on --> http://www.postgresql.org/docs/current/static/warm-standby.html

--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm[@]fast.fujitsu.com.au

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

Предыдущее
От: Michael Lush
Дата:
Сообщение: Real time backup options.
Следующее
От: Charley Tiggs
Дата:
Сообщение: Re: sync two databases