On 2018-07-23 09:17:41 -0500, Ron wrote: > On 07/23/2018 09:11 AM, Andres Freund wrote: > > Hi, > > > > On 2018-07-23 02:23:45 -0500, Ron wrote: > > > We've got an old (v8.4.17, thus no parallel backups) 2.9TB database that > > > needs to be migrated to a new data center and then restored to v9.6.9. > > Have you considered using pg_upgrade instead? > > Yes, but: > 1. can't find 9.6 packages on the RHEL 5.10 server.
If necessary you could just build it yourself. > 2. The window is only 8 hours, and the data also has to be moved to a new DC > in that window. You could just use physical drives ;) Greetings, Andres Freund
