Re: Improving pg_dump performance

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