pglogical

pglogical copied to clipboard

automatic assignment / event trigger workaround

2

1. `event_trigger` for automatic assignment: https://github.com/2ndQuadrant/pglogical#automatic-assignment-of-replication-sets-for-new-tables works only for `CREATE TABLE` 2. there is a bug that prevents `event_trigger` form being used for `DROP TABLE`: https://www.postgresql.org/message-id/16177-053a34714817c3e1%40postgresql.org `BUG #16177: pg_event_trigger_ddl_commands() returns...

Andrei-Pozolotin

spurious walsender activity

2

1. say we have 2 separate databases: * ` main_data` - configured for replication, all tables are part of `default` replication set * `unit_test` - not configured for replication at...

Andrei-Pozolotin

Not able to replicate full data, even if subscription status is Replicationg and local.sync_status show 'r' on all tables

1

Not able to replicate full data, even if subscription status is Replicationg and local.sync_status show 'r' on all tables. A table has 12 GB of data on source Database but...

shivansh931

sequences with non-0 increment are replicated incorrectly

1

The sequence cache mechanism only works reasonably with sequences incremented by 1. Otherwise, by adding the cached value it may make a value that cannot be generated on the subscriber....

bashtanov

Inconsistent documentation describing DDL replication

1

I'm confused about whether or not this tool supports DDL replication. The below screenshot shows pglogical being described as supporting Transparent DDL Replication on this page https://www.2ndquadrant.com/en/resources/pglogical/ ![Screenshot 2019-12-24 at...

chris-wilson-coop

Missing Records Updated inside a Function

3

I have a somewhat large data warehouse database (1.5TB) that I want to upgrade from 9.5.5 to 10.6. I have data that was updated via function call on the pub....

badinvestor

Downed replication during pg_repack unrecoverable

7

I have a strange issue that appeared today. We are replicating from 9.4.10 (pglogical 1.2.1) to 9.6.2 (pglogical 1.2.2). It is extremely invasive for us to restart our provider cluster,...

jfinzel

If ask or answer questions at sites like StackOverflow, it would be very nice if you could create a hyperlink to each method which pglogical provides. For example: https://www.2ndquadrant.com/de/resources/pglogical/documentation/#pglogical.create_replication_set Up...

guettli

pglogical activity invisible to statistics collector?

3

# Problem It seems that rows inserted by pglogical are somehow invisible to the statistics collector. In particular, I'd expect this value to increment as pglogical inserts rows on a...

felixge

I build postgres-xl 10R1.1 successes but build pglogical 2.2.2 got below error message: [root@localhost pglogical-REL2_2_2]# make sed 's/__PGLOGICAL_VERSION__/2.2.2/;s/__REQUIRES__//' /root/pglogical-REL2_2_2/pglogical.control.in > /root/pglogical-REL2_2_2/pglogical.control gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute...

arthurwei74