Copy over large data Postgresql 9.5

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Copy over large data Postgresql 9.5
Date: 2018-08-16 13:41:31
Message-ID: CAN6gwKxu3XU+nuTmOHHh8kcYAs6UvnnnpQvnAqLvqjxz7D_BOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-08-16 13:57:18 Re: During promotion, new master tries to archive same segment twice
Previous Message Adrian Klaver 2018-08-16 13:16:52 Re: regex match and special characters