On 07/23/2018 06:47 AM, Ron wrote:
> On 07/23/2018 08:46 AM, Stephen Frost wrote:
>> Greetings,
>>
>> * Ron (ronljohnsonjr@gmail.com) 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@aklaver.com