pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

pglogical.create_subscription and forward_origins parameters

Open nomorelogic opened this issue 2 months ago • 3 comments

I wanted to report a critical issue with the forward_origins parameter in pglogical.create_subscription.

Here is a link to my personal experience.

postgresql pglogical replication and Segmentation error on bidirectional replication

A personal consideration on the parameter: the default value that is preset to work in unidirectional replication is perfectly understandable.

Given the sensitivity of bidirectional replication, I believe it would be beneficial to implement a security mechanism that prevents the server from crashing. This mechanism could intercept bidirectional replication conditions and signal, in some way, that the parameter needs to be changed.

Thank you for your attention.

nomorelogic avatar Oct 13 '25 15:10 nomorelogic

Thanks for the report. A segfault is always a bug, indeed. I currently prioritize pglogical issues that have patches and where those patches include tests. Would you be willing to write that?

nmisch avatar Oct 27 '25 16:10 nmisch

Do you mean if I can write the patch myself? I don't think I have the right skill to do this job.

nomorelogic avatar Oct 28 '25 10:10 nomorelogic

That's what I meant. No problem, but this may wait longer.

nmisch avatar Oct 28 '25 14:10 nmisch