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

Notify from trigger on pglogical replicated table

I'm trying to setup a push-from-server functionality based on PostgreSQL, pglogical and PostgreSQL's listen-notify mechanism. On my replicated table I've setup a trigger that uses pg_notify to push messages to queue after insert. Altered the trigger…
Jacek Chmielewski
  • 1,763
  • 4
  • 16
  • 18
1
vote
0 answers

How would I use pglogical from a downstream database?

I'd like to use pglogical to replicate a set of tables, but I want to make all of my changes downstream from the master - to avoid risk, I don't want to make any modifications to the master database. I'd also like to start using pglogical now so we…
Crag
  • 1,723
  • 17
  • 35
0
votes
1 answer

ERROR: could not open relation with OID 12303343

I am using cloudsql postgresql and have installed pglogical extension for logical replication between two data sources. However when I run following command in Dbeaver client I get the errors SELECT pglogical.replication_set_add_table( set_name…
SRJ
  • 2,092
  • 3
  • 17
  • 36
0
votes
1 answer

Pglogical Replication Status Down

I am using pglogical for logical replication in PostgreSQL(CloudSQL GCP) and I found my subscription down thus data is not replicating at all from source table to target table.. I checked logs on Publisher Database side background worker "logical…
SRJ
  • 2,092
  • 3
  • 17
  • 36
0
votes
0 answers

How does pglogical.replicate_ddl_command ensure that ddls are run at a consistent point?

From the pglogical readme: pglogical provides the pglogical.replicate_ddl_command function to allow DDL to be run on the provider and subscriber at a consistent point. But how exactly does it ensure that that happens? Looking through the codebase,…
sleepygoose
  • 1
  • 1
0
votes
0 answers

Unable to Drop pglogical provider node

I am using pglogical in one of my production environments and I try to set up the subscriber node and its complaining of node interface not found. I decided to drop the provider node and recreate it again. postgres=# select * from…
Juvette M
  • 1
  • 1
  • 3
0
votes
0 answers

When does pg_replication_slot_advance(slot_name name, upto_lsn pg_lsn) function is used?

1Q Is it called by postgres internally or can it be called by an user. 2Q If it is called by user, then how does he find valid moveto_lsn point in wal records so that after advancing the logical slot...logical decoding continues without error. 3Q If…
Yashwanth Sai Pathipati
  • 1
0
votes
0 answers

How can I upgrade a PostgreSQL production database using pglogical extension without losing data on the subscriber?

I have a production PostgreSQL database that replicate from publisher to subscriber using pglogical extension. My database is running on postgres 11 and I want to upgrade to postgres 14. I first upgrade the subscriber and then the publisher and…
Juvette M
  • 1
  • 1
  • 3
0
votes
0 answers

How to resolve duplicate key errors in pglogical after failover to DR node?

We have set up logical replication using the pglogical extension and added the required tables to it. During the DR testing, we intentionally broke the replication and redirected the application to the DR node. However, we encountered issues with…
Sanjay
  • 11
  • 3
0
votes
1 answer

Upgrade a Postgres Database Using pg_ugrade Issues with pglogical

I have a Postgres database running on version 11. I want to upgrade to Postgres 14. This database also have logical replication set up using pglogical extension. when I run a compatibility check on both clusters, it fail pointing to pglogical…
Juvette M
  • 1
  • 1
  • 3
0
votes
3 answers

Allow two RDS databases to connect to each other for replication

I have two RDS databases within the same VPC and with the same security group. I'm following this guide AWS: how to enable bi-directional replication using pglogical to set up bi-directional replication between the two databases using…
D Malan
  • 10,272
  • 3
  • 25
  • 50
0
votes
0 answers

Why is my AWS DMS task with pglogical failing on dropped and renamed tables?

I have an AWS DMS database migration task running Full Load and Replication. The source is RDS (Aurora PostgreSQL) and I have pglogical configured. The task ran the initial load just fine, and replication was working until we changed the name of…
Jozomby
  • 49
  • 8
0
votes
0 answers

pglogical logical plugin missing DML records

Created pglogical plugin replication slot. SELECT 'init' FROM pg_create_logical_replication_slot('demo_slot', 'pglogical_output'); Created table which have primary key. create table pglogical_test(id serial primary key,name text); Inserted few…
Bandi LokeshReddy
  • 115
  • 1
  • 1
  • 12
0
votes
1 answer

we are not able to replicate 5GB table in postgresql using logical replication

we have multiple tables and all are replicated successfully except one table which is in size of 5GB. Once we created replication slot, the size of the server is growing high but can't see the data. we are using Postgres 12 and Logical…
harinath-reddy
  • 1
0
votes
0 answers

Cannot install pglogical

I cannot install pglogical. I'm fallowing this tutorial:…
Murakami
  • 3,474
  • 7
  • 35
  • 89
1
2
3 4