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(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com