Обсуждение: Copy over large data Postgresql 9.5
Hello Experts,
I need to transfer pgsql 9.5 data of 90GB from one Cloud provider to other. We have plenty of downtime to do this. I will be copying over data directory after shutting down pgsql services on the source.
The problem is how can I confirm that the data has been copied over correctly. Is the pgsql service starting OK on target is enough to ensure that or is there anything more funky to do that?
I will create compressed archive of data and calculate SHA-256 checksum and compare after copying over to target.
At source pgsql is in streaming replication using repmgr (3.5) so I think I will have to recreate repmgr database after copying over and register master again.
Should I vacuum (full) and reindex pgsql on target to gather the statistics again.
Could you advise on the above please?
I need to transfer pgsql 9.5 data of 90GB from one Cloud provider to other. We have plenty of downtime to do this. I will be copying over data directory after shutting down pgsql services on the source.
The problem is how can I confirm that the data has been copied over correctly. Is the pgsql service starting OK on target is enough to ensure that or is there anything more funky to do that?
I will create compressed archive of data and calculate SHA-256 checksum and compare after copying over to target.
At source pgsql is in streaming replication using repmgr (3.5) so I think I will have to recreate repmgr database after copying over and register master again.
Should I vacuum (full) and reindex pgsql on target to gather the statistics again.
Could you advise on the above please?
Regards
Vikas
On 16 August 2018 15:41:31 CEST, Vikas Sharma <shavikas@gmail.com> wrote: >Hello Experts, > >I need to transfer pgsql 9.5 data of 90GB from one Cloud provider to >other. We have plenty of downtime to do this. I will be copying over >data >directory after shutting down pgsql services on the source. Why not using streaming replication without downtime? Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company