Hi all. I have a localdb and a remotedb.
A) I'd like to send table1 and table2 from localdb to remotedb. B) I'd like to send table3 from remotedb to localdb. I have PG9.5 and pglogical setup, and (A) works fine. Well, worked. I then tried to set up (B) which seems to work, but now (A) is broken. remotedb is logging things like: 2016-08-03 20:20:17.086 CDT,: ERROR: cache lookup failed for replication origin 'pgl_vcstimes_katniss_subscrib73496c2' 2016-08-03 20:20:17.087 CDT,: LOG: worker process: pglogical apply 23704565:3237263450 (PID 21981) exited with exit code 1 I did find: https://www.postgresql.org/message-id/1691408856.31522.1468333259045.javamail.zim...@cobra.ru which leads to this: https://github.com/2ndQuadrant/pglogical/issues/23 But I'm not sure if that helps me, or if it does I don't understand what I'd need to do. On remotedb, I see: vcstimes=# select * from pglogical.show_subscription_status(); -[ RECORD 1 ]-----+------------------------------------------------------- subscription_name | subscribe_katniss status | down provider_node | payroll_provider provider_dsn | host=localhost port=9090 dbname=vcstimes user=postgres slot_name | pgl_vcstimes_payroll_provider_subscribc0f4b85 replication_sets | {default,default_insert_only,ddl_sql} forward_origins | {all} I cannot find any description of status = down, and I don't know how to bring it back up. Any help would be appreciated. Thanks, -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
