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?
Regards
Vikas