Re: [HACKERS] Some subscriptions fail (while some succeed) with pglogical

2017-09-12 Thread xiaolongc
Never mind. The problem was actually a minor one -- I need to truncate the table before re-subscribe (otherwise table copy would fail when syncing data with master). -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html -- Sent via pgsql-hackers mailing list

[HACKERS] Some subscriptions fail (while some succeed) with pglogical

2017-09-12 Thread xiaolongc
Hey guys, I'm setting up logical replication with pglogical, and found out that some of my subscriptions are working well but others are not. They are set up in the same way tho, and both master and replica are running pg9.5. Below is subscription status on the replica: \# select