pglogical

pglogical copied to clipboard

Apply Errors are Not logged when using AWS RDS Postgres

2

Using PGLogical extension ( version 2.4.1) in AWS RDS Postgres Version 14.5. On testing a error handling scenario, the RDS postgres error log only contains a single line "2023-01-20 02:14:37...

kkr2320

The conflict check is done before insert/update, but if the conflict-check is ok and there is other transaction commit index insertion before our insert/update, and then conflict occurs, throwing error....

cxb609

Hello Team, We have 350 tables in one database and the size is around 300GB. Initially we set up replication for all tables and we noticed for all tables initial...

levitate-harinathreddy

Is this library even maintained anymore?

3

Not pointing any fingers since it's a great open source tool but just trying to get an affirmation if this library is worth looking into given the huge amount of...

nitinsh99

pglogical with TLS Auth connections

1

My current DB Infrastructure uses pglogical to setup logical replication. However, we want to get rid of using passwords as plain text when the publisher and subscriber are created using...

Viralshah009

pg_logical_slot_peek_changes with slots created with pglogical_output missed DML records

2

we installed from [pglogical_13-2.4.2-1.rhel8.x86_64.rpm](https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-8.5-x86_64/pglogical_13-2.4.2-1.rhel8.x86_64.rpm) , database version is 13.4 , 13.6 two-way replication We test pglogical replication, with pglogical.conflict_resolution=error, and from source database run Insert into pgbench_branches values(109,0,’test’); Commit; At...

Jamespsql

ERROR: BEGIN on origin node failed: ERROR: SET TRANSACTION SNAPSHOT must be called before any query

1

LOG: statement: SELECT pglogical.create_subscription(subscription_name := 'subscription',provider_dsn := 'host=192.168.1.123 port=5432 dbname=testsync user=postgres password=jin12345'); LOG: starting apply for subscription subscription ERROR: BEGIN on origin node failed: ERROR: SET TRANSACTION SNAPSHOT must be...

Jinyouzhiu

From multiDB to Single DB multiple Schemas

1

Hi I am Manuel Acosta, And I got a microservices architecture with multiple dbs, example: - ServiceA -> schema(public) - ServiceB -> schema(public) I want to join those schemas in...

Manuelacosta98

The warning is coming continuously in the log. Using pglogical 2.4.2 on Postgresql 14.6 with conflict_resolution = 'error' and use_spi = true

gkachru

PG 15 doesn't ship TestLib.pm anymore (renamed to PostgreSQL::Test::Util): ``` 13:29:05 Can't locate TestLib.pm in @INC (you may need to install the TestLib module) (@INC contains: /usr/lib/postgresql/15/lib/pgxs/src/makefiles/../../src/test/perl /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.36.0 /usr/local/share/perl/5.36.0...

df7cb