Stack Overflow
Stack Overflow

Questions tagged [pglogical]

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

https://www.2ndquadrant.com/en/resources/pglogical/

pglogical 2.0 – the next generation in logical replication for PostgreSQL. This version will continue to be supported until EOL for PostgreSQL server versions 9.4, 9.5 and 9.6 and will also work with PostgreSQL 10 due to release in Fall 2017.

48 questions
0
votes
1 answer

Postgres 9.6 -> 14 using pglogical, autovacuum not running

We're upgrading our Postgresql from 9.6 to 14, using pglogical (latest installed via yum). The replication is working fine without errors. What we are not seeing, however, is any autovacuum activity on the v14 database, even though we continue to…
Mark Fletcher
  • 701
  • 1
  • 14
  • 36
0
votes
0 answers

Unable to install pglogical on Mac OS

I'm having real trouble installing the extension pglogical on Mac. Cloned the pglogical repo When executing make install I get the following error: macuser$ make install sed 's/__PGLOGICAL_VERSION__/2.4.1/;s/__REQUIRES__//' …
VynlJunkie
  • 1,953
  • 22
  • 26
0
votes
1 answer

Stop and Resume pglogical Replication -PostgreSQL 12

I wanted to check if there is a way to stop and resume PostgreSQL replication using pglogical? For some reason, if either the publisher or subscriber needs to restart and go offline for sometime (or connectivity issues because of some n/w issues),…
P_Ar
  • 377
  • 2
  • 9
  • 25
0
votes
0 answers

Large Object Replication using AWS DMS?

Wanted to check if Large Object replication is supported by AWS DMS when Source and destination DB's are PostgreSQL? I just used pglogical to replicate a DB which has Large Object (Like IOD's etc) and the target DB does not have LO's. When I query a…
P_Ar
  • 377
  • 2
  • 9
  • 25
0
votes
0 answers

pg_logical replication failing - Postgresql 11.9

Need some help with pglogical replication. Following is my replication setup: On the Publisher side, node created successfully. I applied row filtering on a column for some tables. Something like: SELECT…
P_Ar
  • 377
  • 2
  • 9
  • 25
0
votes
0 answers

PostgreSQL pglogical replication filling up the disk space

I tried to use pglogical to replicate data between 2 PG servers and found huge disk occupation during the process. Here is the details Env: Source PG: server name: pg-publisher. IP address: 10.0.0.1 Whole disk space: 3.5T Size of PG data folder:…
Binary
  • 81
  • 8
0
votes
0 answers

What is modifying pglogical / Database Migration Service (GCP) in the source database?

We are using the pglogical extension for replicating a PostgreSQL database into Google Cloud, using the Database Migration Service. We are able to reach the continuous replication phase successfully. The problem is after this. Over the source…
alek6dj
  • 334
  • 3
  • 17
0
votes
1 answer

Using pgLogical row filter for jsonB column type

I am trying to replicate a table that contains jsonB column. I want to use row filtering to select only the rows that I need. How do I define the row filter for jsonB? Table person: id serial, name …
Fulliautomatix
  • 17
  • 4
0
votes
1 answer

Postgres 13 + pglogical 2.3.4 on an existing dataset

I'm experiencing an issue trying to setup pglogical between a provider and a subscriber, both already have some data in common. This is a minimal script to reproduce what I'm trying to do: CREATE DATABASE db1; \c db1; CREATE EXTENSION…
Andre Galastri
  • 1
  • 1
0
votes
1 answer

pglogical.replicate_ddl_command quote handling

Provider is on OEL 7 postgres 12.4 and Subscriber in on RDS 13.2 pglogical.replicate_ddl_command works fine as long as there are no quotes between start and end of the command. for example, below works fine select…
TaB
  • 109
  • 1
  • 6
0
votes
1 answer

Can pglogical be used to migrate on-prem database to AWS RDS?

I am trying to replicate my on-prem postgres 12.4 database to AWS RDS 13.2 with minimal downtime. I tested pglogical to create a replica from my source db to another on prem host and found that pglogical requires superuser role such as postgres with…
TaB
  • 109
  • 1
  • 6
0
votes
1 answer

Is it possible to replicate just one schema in postgresql?

NOTE: a similar Q. was asked but was not answered here: How do I replicate a single schema in postgresql? I am trying to replicate just one schema in a postgresql (13) database using pglogical to another server. In my test setup on the provider node…
Giles
  • 1,597
  • 11
  • 15
0
votes
0 answers

How can I set up a CDC replication from AWS RDS PostgreSQL to Kafka using Pglogical?

Is it possible to setup replication from PostgreSQL to Kafka using PGlogical? Currently we are using attunity as our replication tool which has been causing issues on our instances. We are using RDS PostgreSQL.
Chetan Dev Khanna
  • 127
  • 7
0
votes
1 answer

Could not access file "pglogical" while trying to install pglogical

I'm following instructions from https://github.com/2ndQuadrant/pglogical to install pglogical on postgres 12 on Centos 8. The install seems be successful: yum -y install postgresql12-pglogical Last metadata expiration check: 0:21:30 ago on Wed 30…
naveed
  • 1,395
  • 2
  • 15
  • 29
0
votes
1 answer

pglogical: list replication sets?

I looked at the docs of pglogical. But I could not find a way to list all replication sets, which I created with create_replication_set(). How to list all replication sets?
guettli
  • 25,042
  • 81
  • 346
  • 663
1 2
3
4