Strategy for moving a large DB to another machine with least possible down-time

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Strategy for moving a large DB to another machine with least possible down-time
Дата
Msg-id VisenaEmail.57.45219778166c5146.14897f82eab@tc7-visena
обсуждение исходный текст
Ответы Re: Strategy for moving a large DB to another machine with least possible down-time  (Bill Moran <wmoran@potentialtech.com>)
Re: Strategy for moving a large DB to another machine with least possible down-time  (Andy Colson <andy@squeakycode.net>)
Список pgsql-general
Hi all.
 
PG-version: 9.3.5
 
I have a DB large enough for it to be impractical to pg_dump/restore it (would require too much down-time for customer). Note that I'm noe able to move the whole cluster, only *one* DB in that cluster.
 
What is the best way to perform such a move, can i use PITR, rsync + webl-replay magic, what else?
Can Barman help with this, maybe?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Вложения

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

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: cloning database
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Strategy for moving a large DB to another machine with least possible down-time