Questions tagged [replication]
Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
3,551 questions
0
votes
0
answers
16
views
Oracle Database 11g refresh group
--EN
Hello. Oracle Database 11gR2.
There are two Refresh Groups: RG01 and RG02. Both refresh groups use the same database link. RG01 contains non-updatable materialized views, while RG02 contains ...
- 1
0
votes
0
answers
33
views
SQL Server replication is in "Performance critical" status persistently
I have multiple publication in the sql server with
SQL Server version: 2017
Transactional REplication
Distributor and Publisher are in the same server
Subscriber is on the different server
Also:
9 ...
- 111
0
votes
0
answers
35
views
PostgreSQL logical replication failing with "permission denied for schema" despite operating as the superuser
On a PostgreSQL 14 database, I've got a logical replication publication of 108 tables across 10 schemas. For some unknown reason, the subscriber fails to replicate tables in one of the schemas (call ...
- 175
0
votes
1
answer
30
views
PostgreSQL:Why promoting standby while primary is online causing WAL fork?
I have been testing PostgreSQL 17 AYSNC replication and failover on Ubuntu VMs. Suppose I have two VMs: A as the primary and B as the standby. If I promote B while A is offline, and later configure A ...
- 700
0
votes
1
answer
33
views
Enabled always statement level trigger on logical replication target does not seem to fire
Overview
I have the following setup using Azure PostgreSQL flexible server v17:
a main database containing a certain table included in the table list for a logical replication publication
a replica ...
- 1,193
0
votes
1
answer
54
views
Automatically transfer all data from postgres server to another remote server
I need to synchronize a test environment with production data (n8n worflows, user info, etc), both have postgres databases and reside on the same intranet
(e.g: server A: 10.0.0.10, server B: 10.0.0....
0
votes
0
answers
27
views
How to update complex data structure in RocksDB?
I have been working with RocksDB for a while, and in my use case, complex data structures are stored as values in the database — for example, a Map that may itself contain nested maps.
1. Update ...
0
votes
0
answers
38
views
Replication vs new database to stock user custom object
I have server1\database1 (production) being replicated to server2\database1 (reporting) running on SQL Server 2016. In both databases, there are objects (table, sp, function, ...) created by the user. ...
- 26
0
votes
0
answers
48
views
Fast query got "cancelling statement" on replica
I'll say in advance that I've seen similar questions on this topic, but I just couldn't find an answer because they concerned long queries, while mine, on the contrary, executes the query in less than ...
- 101
0
votes
1
answer
99
views
How to clean the pg_wal folder when it is not done automatically?
I have two PostgreSQL16 clusters (one cluster per server) each with one and the same database.
They are interconnected via a bi-directional logical replication, with one being the main one and the ...
- 101
0
votes
0
answers
59
views
Best approach to sync preprod from prod without breaking transactional replication
I’m seeking recommendations on the best way to synchronize our preproduction environment from production without disrupting the existing transactional replication.
Currently, both our production and ...
0
votes
1
answer
118
views
How to check if PostgreSQL logical replication has caught up or is still in progress?
We are using PostgreSQL’s logical replication to replicate data from our main transaction database to a reporting database.
Main DB: Production transaction database (source)
Replication DB: Used for ...
Atharva Joshi
0
votes
2
answers
93
views
Understanding WAL LSN
I’m using CNPG Postgres with 2 node availability. There’s a primary and secondary. The primary uses synchronous replication. I am using Change Data Capture with debezium. It creates a replication slot,...
- 591
0
votes
2
answers
106
views
How to implement redundant databases with mutual synchronization in PostgreSQL or SQL Server
I am writing a program in Golang where I need to set up redundant databases. Here’s the requirement:
I have two databases that act as redundant to each other.
The application first tries to write data ...
1
vote
0
answers
22
views
How to get snapshotConflictHorizon transactionID in postgres standby without seeing pg_wal files?
When ever master node performs vacuum, he also logs the snapshotConflictHorizon for few specific vacuum records
for example
rmgr: Heap2 len (rec/tot): 64/ 64, tx: 0, lsn: 1/...
- 137