|
Pavan,
This is the steps I took. I think I did it right:
[Master]
pg_dump -s -f schema.sql
pg_dump -a -f data.sql
CREATE PUBLICATION
[Client/Slave]
psql \i schema.sql
CREATE SUBSCRIPTION ... WITH (enabled = false)
SET session_replication_role = replica; -- turn off trigger
psql \i data.sql
ALTER SUBSCRIPTION ... ENABLE
--> errors occur here
Thoughts?
From: Pavan Teja <pavan.postgresdba@xxxxxxxxx>
Sent: Wednesday, April 3, 2019 6:48 AM To: Lou Tseng Cc: pgsql-general@xxxxxxxxxxxxxx >> PG-General Mailing List Subject: Re: Seeded Replication Hi Lou,
Did you restore data on the subscriber during the first time. If yes this error is likely to occur.
As a remedy, you need to restore only structural dump during initial building of subscription.
Earlier the same issue was faced by me later it got resolved following the above said approach.
Kindly revert back if any queries.
Regards,
Pavan Teja,
9841380956
On Wed, 3 Apr, 2019, 5:15 PM Lou Tseng, <ltseng@xxxxxxxxxxxxxxxxxxx> wrote:
|
