pg_update to a new machine?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_update to a new machine?
Date: 2018-02-24 03:57:26
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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?

--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.)


Angular momentum makes the world go 'round.


Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2018-02-24 08:29:12 Re: pg_update to a new machine?
Previous Message Tom Kazimiers 2018-02-24 03:47:48 Unexpected behavior with transition tables in update statement trigger