Copy over large data Postgresql 9.5

Started by Vikas Sharmaover 7 years ago2 messagesgeneral
Jump to latest
#1Vikas Sharma
shavikas@gmail.com

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

#2Andreas Kretschmer
andreas@a-kretschmer.de
In reply to: Vikas Sharma (#1)
Re: Copy over large data Postgresql 9.5

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