On 2019-04-03 13:44, Lou Tseng wrote:
> However, our database is about 200G and it will take a long time to
> complete the initial data copy. We would like to manually seed the
> subscriber database with data dump and then turn on the subscription
> like depesz showed in this
> post https://www.depesz.com/2017/02/07/waiting-for-postgresql-10-logical-replication/ .
I doubt you will get a huge speedup, since the dump and the initial data
copy use the same COPY command internally.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services