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 subscription_name, status, replication_sets from pglogical.show_subscription_status(); parking_sub | down | {parking_schema} public_sub | replicating | {public_schema} stripe_sub | replicating | {stripe_schema} zip_sub | down | {zip_schema} Checked logs on the replica: 2017-09-13 00:00:14 UTC [2850-1] LOG: starting apply for subscription zip_sub 2017-09-13 00:00:14 UTC [2850-2] ERROR: subscriber zip_sub initialization failed during nonrecoverable step (d), please try the setup again 2017-09-13 00:00:14 UTC [2850-3] LOG: apply worker [2850] at slot 3 generation 70 crashed 2017-09-13 00:00:14 UTC [1573-136] LOG: worker process: pglogical apply 16384:743118875 (PID 2850) exited with exit code 1 I checked my replication set on the master and it looks valid. All tables in the replication set have a Primary Key constraint. What else do you think could have gone wrong? Thanks in advance! -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers