Search Postgresql Archives

pg_update to a new machine?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux