Re: Improving pg_dump performance

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 (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?

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.