pg_update to a new machine?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема pg_update to a new machine?
Дата
Msg-id 09489f15-b756-9e6d-c081-a8cdf0f9b483@cox.net
обсуждение исходный текст
Ответы Re: pg_update to a new machine?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: pg_update to a new machine?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
The 2.8TB database must be moved to a new server in a new Data Center, and upgraded from 8.4.17 to 9.6.6

Will this work?

pg_upgrade       --old-datadir "CURSERVER://var/lib/pgsql/data"       --new-datadir "NEWSERVER://var/lib/pgsql/data"       --old-bindir "CURSERVER://usr/bin"       --new-bindir "NEWSERVER://usr/bin"
Or must I:
1. temporarily allocate 3TB of scratch space on the new server,
2. install 8.4 on the new server,
3. install 9.6.6 on the new server,
2. rsync CURSERVER://var/lib/pgsql/data to NEWSERVER://var/lib/pgsql/8.4/data, and then
3. pg_upgrade?

Are there better ways?  (The pipe from current DC to new DC will be 10Gbps.)

Thanks

--
Angular momentum makes the world go 'round.

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

Предыдущее
От: Tom Kazimiers
Дата:
Сообщение: Unexpected behavior with transition tables in update statementtrigger
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: pg_update to a new machine?