Hi Steve Singer, I find the pglogical package has updated, I reinstall the new RPM package and test again. But I find the same error in subscription node after I run pglogical.create_subscription command: Error message: < 2016-01-26 12:23:59.642 UTC >LOG: worker process: pglogical apply 19828:2377587811 (PID 12299) exited with exit code 1 < 2016-01-26 12:23:59.642 UTC >LOG: unregistering background worker "pglogical apply 19828:2377587811" < 2016-01-26 12:23:59.642 UTC >LOG: registering background worker "pglogical apply 19828:2377587811" < 2016-01-26 12:23:59.642 UTC >LOG: starting background worker process "pglogical apply 19828:2377587811" < 2016-01-26 12:23:59.643 UTC >ERROR: subscriber replicate_gis_data_from_11 initialization failed during nonrecoverable step (s), please try the setup again I also find the provide node has error message: < 2016-01-26 04:16:51.173 UTC >LOG: exported logical decoding snapshot: "0003F483-1" with 0 transaction IDs < 2016-01-26 04:16:51.282 UTC >LOG: unexpected EOF on client connection with an open transaction < 2016-01-26 04:16:51.549 UTC >LOG: logical decoding found consistent point at 4F/8CD1A090 < 2016-01-26 04:16:51.549 UTC >DETAIL: There are no running transactions. < 2016-01-26 04:16:51.549 UTC >LOG: exported logical decoding snapshot: "0003F484-1" with 0 transaction IDs < 2016-01-26 04:16:51.675 UTC >LOG: unexpected EOF on client connection with an open transaction < 2016-01-26 04:16:51.968 UTC >LOG: logical decoding found consistent point at 4F/8CD1A0F8 < 2016-01-26 04:16:51.968 UTC >DETAIL: There are no running transactions. < 2016-01-26 04:16:51.968 UTC >LOG: exported logical decoding snapshot: "0003F485-1" with 0 transaction IDs < 2016-01-26 04:16:52.399 UTC >ERROR: schema "topology" already exists < 2016-01-26 04:16:52.436 UTC >LOG: unexpected EOF on client connection with an open transaction
I test pglogical according to README document. Could you tell me what is wrong? Thanks, Leo -- View this message in context: http://postgresql.nabble.com/pglogical-logical-replication-contrib-module-tp5879755p5884242.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers