Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Kretschmer
Subject Re: Copy over large data Postgresql 9.5
Date
Msg-id F2FEFA86-F23C-48F9-A508-770EBDEFA84F@a-kretschmer.de
Whole thread Raw
In response to Copy over large data Postgresql 9.5  (Vikas Sharma <shavikas@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: regex match and special characters
Next
From: Andreas Joseph Krogh
Date:
Subject: Sv: Re: regex match and special characters