pg_update to a new machine?
От
Ron Johnson
Тема
pg_update to a new machine?
Дата
Msg-id
09489f15-b756-9e6d-c081-a8cdf0f9b483@cox.net
Список
Дерево обсуждения
pg_update to a new machine? Ron Johnson <ron.l.johnson@cox.net>
Re: pg_update to a new machine? Stephen Frost <sfrost@snowman.net>
Re: pg_update to a new machine? Andreas Kretschmer <andreas@a-kretschmer.de>
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?
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
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.
Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления
От: Tom Kazimiers
Дата: