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
