| 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 |
| Message-ID: | 09489f15-b756-9e6d-c081-a8cdf0f9b483@cox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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?
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.
| 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 |