Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
1 vote
1 answer
100 views

I am configuring a bidirectional replication between node1 and node2. The configuration of node1 as publisher and node2 as subscriber is correct: the data is replicated and no errors occur. The ...
0 votes
1 answer
216 views

I understood that snapshot contains current state of database regarding current running,committed and uncommitted transactions. I have few questions 1.How snapshots are used in logical decoding? 2.I ...
1 vote
1 answer
746 views

There is xmin parameter in replication slot.I saw this value is empty in case of logical replication.From this it is clear that logical slots does not help in preventing vacuum process of dead tuples ...
1 vote
0 answers
165 views

I have implemented the master-master bidirectional replication using Postgres pglogical extension on Ubuntu. Trying different scenarios that if one of the nodes gets down / shut down, will the process ...
0 votes
1 answer
364 views

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 ...
0 votes
1 answer
859 views

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 ...
0 votes
1 answer
1k views

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 ...
0 votes
1 answer
479 views

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.....
0 votes
0 answers
117 views

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 ...
0 votes
1 answer
1k views

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 ...
-1 votes
3 answers
1k views

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 ...
0 votes
0 answers
2k views

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 ...
Jozomby's user avatar
  • 49
0 votes
1 answer
316 views

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. ...
2 votes
2 answers
11k views

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 ...
0 votes
0 answers
384 views

I cannot install pglogical. I'm fallowing this tutorial: https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.postgresql-rds-postgresql-full-load-pglogical.html#chap-manageddatabases....
Murakami's user avatar
  • 3,810

15 30 50 per page
1
2 3 4

AltStyle によって変換されたページ (->オリジナル) /