| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Lou Tseng <ltseng(at)advancedpricing(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Seeded Replication |
| Date: | 2019-04-04 21:43:24 |
| Message-ID: | 9bc90591-3c4f-2d98-57a3-88019a5b3430@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Clarke | 2019-04-04 22:05:50 | Re: logical replication - negative bitmapset member not allowed |
| Previous Message | Peter Eisentraut | 2019-04-04 21:37:04 | Re: logical replication - negative bitmapset member not allowed |