Migrate 2 DB's - v8.3

Поиск
Список
Период
Сортировка
От Jeff Baldwin
Тема Migrate 2 DB's - v8.3
Дата
Msg-id CABk2_VnxEATLmKW2Z6u=ChtYZAhxFtBMS_iNCj9D9i+TaYi8=Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Migrate 2 DB's - v8.3  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Hello,

I am working to migrate 2 DB's (not the entire postgres instance), from 1 host to another... and I need some guidance on the best approach/practice.

I have migrated ~25 other DB's in this environment, and I was able to use pg_dump/pgrestore for those, and it worked fine.  These final 2 are live DB's, and I need to move them with minimal downtime (1-2hrs is acceptable).

The DB's are blob DB's that are 45 and 90G in size, and are in the same Data Center, with 1G connection in between

I am running postres 8.3 (I know :) ), so there may be some limitations there as well.   

Any help/guidance on the best way to approach this, are greatly appreciated.

Kind Regards,
Jeff

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: 9.6beta, parallel execution and cpu_tuple_cost
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Migrate 2 DB's - v8.3