Postgres Pro
Downloads
Home   >   mailing lists

Seeded Replication - Mailing list pgsql-general

From Lou Tseng
Subject Seeded Replication
Date
Msg-id DM6PR11MB2939A18E1D2441B4B984165BC4570@DM6PR11MB2939.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: Seeded Replication  (Pavan Teja <pavan.postgresdba@gmail.com>)
Re: Seeded Replication  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Seeded Replication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-general
Tree view
Hi, 

We are working on a project to set up replication from on premises Postgresql 10.4 to Azure Postgresql services. 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/ .  It works for the small testing database but when I applied same steps with entire database, I am getting "ERROR:  duplicate key value violates unique constraint" errors. Basically postgresql does not recognize the primary key.

Any thought / suggestion is helpful!

Lou Tseng

ltseng@advancedpricing.com
Advanced Medical Pricing Solutions
35 Technology Parkway South, Suite. 100
Peachtree Corners, GA 30092

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Recommendation to run vacuum FULL in parallel
Next
From: Pavan Teja
Date:
Subject: Re: Seeded Replication