Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Hello,
I'm struggling with pglogical and DDL replication. I found a function pglogical.replicate_ddl_command().
This function is great but as postgresql EVENT TRIGGER can't be executed INSTEAD OF but can execute function only at DDL end / DDL start so I can't use this function seamlessly with any application.
If this function have options execute_locally := true / false, I can use it with event trigger to execute remotely current_query() but not locally.
For backward compatibility should be default true, of course.
Hello, I'm struggling with pglogical and DDL replication. I found a function
pglogical.replicate_ddl_command().This function is great but as postgresql
EVENT TRIGGERcan't be executedINSTEAD OFbut can execute function only at DDL end / DDL start so I can't use this function seamlessly with any application.If this function have options
execute_locally := true / false, I can use it with event trigger to execute remotelycurrent_query()but not locally.For backward compatibility should be default
true, of course.