pglogical

pglogical copied to clipboard

QUESTION: Can I still use postgresql Physical replication after enabled pglogical?

1

1: I have two main sever in different geolocation which is using pglogical for bi-directional replications 2: I want to have a full stream physical replica on each main server's...

xytxyt

status code 404 when installing on AWS EC2 REHL 9

1

hi guys, when I'm running "yum install postgresql15-pglogical", I got an error msg: - Status code: 404 for https://dl.2ndquadrant.com/default/release/rpm/packages/rhel/9/x86_64/15/repodata/repomd.xml (IP: 159.69.181.86) Error: Failed to download metadata for repo '2ndquadrant-dl-default-release-pg15': Cannot...

calduck2016

My publisher has four tables and two replication sets, Repset1 (T1, T2) and Repset2 (T3, T4). ``` select pglogical.create_replication_set('repset1'); select pglogical.create_replication_set('repset2'); select pglogical.replication_set_add_table('repset1','t1'); select pglogical.replication_set_add_table('repset1','t2'); select pglogical.replication_set_add_table('repset2','t3'); select pglogical.replication_set_add_table('repset2','t4'); ```...

Jerry-Freelancer

This prevents v15+ DROP DATABASE hanging when a pglogical process waits inside one of these calls. (See https://github.com/2ndQuadrant/pglogical/issues/418 for fixes of that symptom under different conditions.) In all versions, it...

nmisch

It seems that function [`pglogical_connect_base`](https://github.com/2ndQuadrant/pglogical/blob/REL2_x_STABLE/pglogical.c#L299) overrides the values of the following connection-string parameters, if given by the user: * `connect_timeout` * `keepalives` * `keepalives_idle` * `keepalives_interval` * `keepalives_count` This means...

dubek

pglogical apply PID exited with exit code 1

2

### Base Info Both on source & target: - RDS Postgres 11.15 - Db.m5.8xlarge - PGLogical v2.4.0 ### Example - When we try to move data from one shard to...

jitesh-co

Update `forward_origins` for the existing subscription

1

I have created a subscription to synchronise the data between a virtual machine and a GCP CloudSQL instance. Before we promote the CloudSQL instance to handle all the traffic, we...

shreyasp

Commit 418099df971835560eb5ac6076955fcc65eb4599 added this macro to every other pglogical_compat.h. `make installcheck` passes.

nmisch

If sync process synced very closely to the their remote, there is a possibility that no commit since the starting LSN point. If that is the case, apply worker is...

woonhak

Unable to create docker image

2

I am trying to extend bitnami postgresql with timescaledb and pglogical extension. Somehow adding pglogical gives errors. My dockerfile looks like following: ```FROM bitnami/postgresql:15 USER root RUN install_packages build-essential git...

apgapg