On 07/23/2018 08:56 AM, Adrian Klaver wrote:
On 07/23/2018 06:47 AM, Ron wrote:
On 07/23/2018 08:46 AM, Stephen Frost wrote:
Greetings,
* Ron (ronljohnso...@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?
Yes, we've migrated CAT and Staging databases, and the application has been
tested.
And this is a test conversion of the prod databases...
--
Angular momentum makes the world go 'round.
