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
7
votes
1 answer

Is logical replication using pglogical possible with timescaleDB?

I set up a fully functional logical replication of multiple masters to one slave. As soon as I convert any of the replicated tables to timescaleDB's hypertable, the replication stops working - only the structure is replicated, but no data. Is it…
Tom
  • 91
  • 7
3
votes
2 answers

How to change subscription status from down to replicating

I am trying to replicate postgresql database from provider node to subscriber node. I have followed tutorial from http://bonesmoses.org/2016/10/14/pg-phriday-perfectly-logical/ and created provider node and added a table to replication set and…
Lani
  • 178
  • 1
  • 2
  • 9
3
votes
1 answer

Postgres Replication with pglogical: ERROR: connection to other side has died

Got this error (on replica) while replicating between 2 Postgres instances: ERROR: connection to other side has died Here is the logs on the replica/subscriber: 2017-09-15 20:03:55 UTC [14335-3] LOG: apply worker [14335] at slot 7 generation…
xiaolong
  • 3,396
  • 4
  • 31
  • 46
2
votes
1 answer

RDS Postgres Logical Replication into EC2 - only rds_superusers can query or manipulate replication origins

We try to replicate from AWS RDS pg11 (pglogical 2.2.1) to pg12. AWS RDS pg12 has only pglogical 2.3.0, which is not compatible to 2.2.1, and there is no way to downgrade (tried already). The replication starts and creates schemas in target, but…
Mihail Gershkovich
  • 412
  • 4
  • 9
2
votes
1 answer

Is a primary key necessary to replicate inserts using pglogical?

I tried to setup a simple master > slave replication using pglogical. The pglogical docs mention that one needs a primary key for replicating updates and deletes. Since I don't need neither one, I set up a replication set at the provider as…
Tom
  • 91
  • 7
1
vote
2 answers

Postgres 15 Multi-Master Replication

For the last few days I've been trying to implement a working multi-master replication using postgresql however, unsuccessfull. I came across multiple tools, none of which as worked. I think I'm getting close to a solution but I'm hitting a…
João Ferreira
  • 58
  • 9
1
vote
0 answers

How can I re-create a subscription via pglogical?

I am using pglogical in postgresql11 to replica data from master cluster to a slave cluster. It is working fine. but I run pglogical.drop_subscription to delete the subscription from slave instance. After that I tried to run…
Joey Yi Zhao
  • 37,514
  • 71
  • 268
  • 523
1
vote
2 answers

Why can't I create pglogical subscription?

I'm trying to setup replication from postgres DB source (pg 11.7, pglogical 2.2.1) to target (pg 13.5, pglogical 2.3.3) The connectivity and access across DBs are configured and tested. I've manually duplicated roles from source to target using…
Greg Toews
  • 31
  • 4
1
vote
1 answer

Setting up pglogical over ssh tunnel, connection reset by peer

I am setting up a pglogical replication between an on-premise PostgreSQL 10.14 (publisher and AWS RDS Postgresql 10.16 (subscriber), but after setting up a subscription, I only get to connection resets. Can anyone spot what I'm doing wrong? Network…
Pavel Kucera
  • 31
  • 1
  • 5
1
vote
0 answers

PostgreSQL to Kafka replication using Pglogical

Can we setup PostgreSQL to Kafka replication using Pglogical? Please share steps if possible. Note- We are using AWS RDS and Aurora for PostgreSQL. Thanks,
Chetan Dev Khanna
  • 127
  • 7
1
vote
0 answers

Is it possible to receive updates on changes (insert, update, delete) in specific tables in AWS Aurora Postgres 11.6

I'm trying to write a service that will receive updates from Postgres DB when several tables changed. I'm writing it in Python using psycopg2 library. I have found several examples of a very simple solution - using PUBLICATION and SUBSCRIPTION but…
Art Lasky
  • 21
  • 5
1
vote
1 answer

How can I get past this problem recreating a pg_logical subscription?

I'm having a problem dropping and creating subscriptions - I think these messages are saying it exists on the replica and not the primary: db=# CREATE SUBSCRIPTION sub db-# CONNECTION 'dbname=db host=some.domain.com user=logical_replicator…
Crag
  • 1,723
  • 17
  • 35
1
vote
2 answers

How do I install pglogical extension on Windows machine?

I need to migrate an enterprise production database from a Windows source machine running Postgres 9.5 to an Ubuntu destination machine running Postgres 11.6 with < 15 mins downtime. I plan to do this with pglogical, which requires the extension…
Alexi Theodore
  • 1,177
  • 10
  • 16
1
vote
2 answers

How does pglogical-2 handle logical replication on same table while allowing it to be writeable on both databases?

Based on the above image, there are certain tables I want to be in the Internal Database (right hand side). The other tables I want to be replicated in the external database. In reality there's only one set of values that SHOULD NOT be replicated…
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
1
vote
2 answers

Can I use .pgpass in logical replication?

I'm using Logical replication. I made subscription like below. =# CREATE SUBSCRIPTION mysub CONNECTION 'host=xxx.xxx.xxx.xxx port=5432 user=postgres dbname=mydb password=' PUBLICATION mypub; NOTICE: created replication slot "mysub"…
arayo
  • 197
  • 2
  • 12
1
2 3 4