Hi. I currently have a two-server BDR replication setup. Apart from the two master nodes, I have another two servers which I want to have read only replication for some tables only.
I first had to deal with some trouble regarding CREATE EXTENSION being replicated by BDR, and that causing the schema creation for the extension to be run on both servers, thus locking the entire cluster. I solved that by creating the schema, tables and function manually, and replacing the extension SQL file with an empty one.
Now, after joining the subscriber to the provider, I keep getting the following log in the provider:
< 2017-07-02 13:30:38.776 -05 >ERROR: missing required parameter "startup_params_format"
< 2017-07-02 13:30:38.776 -05 >CONTEXT: slot "pgl_ocs_test_dayana_jimena_dayana", output plugin "pglogical_output", in the startup callback
And in the subscriber:
< 2017-07-02 13:29:39.824 CEST >LOG: registering background worker "pglogical apply 192166:2763588059"
< 2017-07-02 13:29:39.824 CEST >LOG: starting background worker process "pglogical apply 192166:2763588059"
< 2017-07-02 13:29:39.827 CEST >LOG: starting apply for subscription jimena_dayana
< 2017-07-02 13:29:39.833 CEST >ERROR: data stream ended
< 2017-07-02 13:29:39.834 CEST >LOG: apply worker [5632] at slot 2 generation 127 crashed
< 2017-07-02 13:29:39.835 CEST >LOG: worker process: pglogical apply 192166:2763588059 (PID 5632) exited with exit code 1
< 2017-07-02 13:29:39.835 CEST >LOG: unregistering background worker "pglogical apply 192166:2763588059"
I’ve searched all around the source code & document5ation, but I see no way to set that parameter, so I’m stucked here. Any help would be appreciated.
Regards,
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: (+51) (#) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe