On 07/23/2018 06:47 AM, Ron wrote:
On 07/23/2018 08:46 AM, Stephen Frost wrote:
Greetings,
* Ron (ronljohnsonjr@xxxxxxxxx) wrote:
An interesting idea. To clarify: it's possible to parallel backup a
running
8.4 cluster remotely from a 9.6 system?
Yes, you can do a parallel backup, but you won't be able to get a
consistent snapshot. You'll need to pause all changes to the database
while the pg_dump processes connect and start their transactions to
have the backup be consistent.
I can do that!!!
Assuming you can get this setup, have you tested some subset of your
data on 9.6.9?:
1) Going from 8.4 --> 9.6 is jumping 7 major versions of Postgres. Do
you know that the data/code will work in 9.6.9?
2) Does the transfer have time built in for fixing problems on the 9.6.9
end?
3) If the answer 2) is no, then is there a plan to deal with changes in
the 8.4 database while working on the 9.6.9 database?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
