Re: pg_update to a new machine?

Am 24.02.2018 um 04:57 schrieb Ron Johnson:
> 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.)
>

it's a big step from 8.4 to 9.6... If you can do that with a downtime i 
would prefer dump & restore.
A solution without (big) downtime would be replication with slony or 
londiste.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com