Copy over large data Postgresql 9.5 - Mailing list pgsql-general

From Vikas Sharma
Subject Copy over large data Postgresql 9.5
Date
Msg-id CAN6gwKxu3XU+nuTmOHHh8kcYAs6UvnnnpQvnAqLvqjxz7D_BOw@mail.gmail.com
Whole thread Raw
Responses Re: Copy over large data Postgresql 9.5
List pgsql-general
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: regex match and special characters
Next
From: Adrian Klaver
Date:
Subject: Re: During promotion, new master tries to archive same segment twice