All Questions
Tagged with replication postgresql
574 questions
0
votes
2
answers
64
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
5
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
0
votes
0
answers
35
views
Why did WAL generation double after adjusting hot standby settings?
I’m running PostgreSQL 15 with a master and a replica in hot-standby mode.
The hot-standby parameters are as follows:
max_standby_streaming_delay = 5h
hot_standby_feedback = on
These parameters were ...
- 11
0
votes
0
answers
54
views
Postgres pg_wal size increasing possibly from patroni outage
I've recently hit an issue of pg_wal files not being cleaned up on a replica postgres instance server despite these being archived on the master instance. Patroni was out during the time due to an ...
0
votes
1
answer
22
views
Is it possible to run Django migrations on a Cloud SQL replica without being the owner of the table?
I'm using Google Cloud SQL for PostgreSQL as an external primary replica, with data being replicated continuously from a self-managed PostgreSQL source using Database Migration Service (DMS) in CDC ...
- 117
1
vote
1
answer
35
views
Why is my Cloud SQL external replica not reflecting schema changes (like new columns) after Django migrations?
I'm using Google Cloud Database Migration Service (DMS) to replicate data from a self-managed PostgreSQL database into a Cloud SQL for PostgreSQL instance, configured as an external primary replica.
...
- 117
1
vote
1
answer
53
views
Postgres Database Free Storage Space Downward
I have a situation on my Postgres 13 db on AWS.
8TB of storage
60GB of memory that it isn't really using
I regularly check to see if any query is running and if so, kill it.
Transaction Log Disk ...
- 347
2
votes
0
answers
36
views
Deadlock seems to occasionally and regularly lead to replication failure
We have two PostgreSQL databases running on RHEL virtual servers (PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit). Our production server/...
- 599
1
vote
1
answer
134
views
Resume PostgreSQL logical replication after replication slot dropped
Is is possible to resume logical replication from the exact point is has stopped?
In the past, with earlier versions of Postgresql (up to 12) I experienced many times, that logical replication was ...
- 149
0
votes
0
answers
28
views
Postgresql logical replication not working properly multiple servers
I'm trying to use 2-way logical replication between 3 postgresql (v16 or v17) servers, so that any write on any server is replicated to the other servers, and also propagates to all servers even if a ...
- 101
1
vote
1
answer
127
views
Replay standby WAL to point in time without creating new timeline
We have a PostgreSQL 13 replication cluster where one of the standbys is setup with a recovery_min_apply_delay="x hr", which could be useful in the case of data corruption.
For a scenario ...
- 625
0
votes
0
answers
41
views
Why does query planning time increase on a standby replica with increase in dead tuples but not on the primary?
We are using Postgres 10 with standby replication (read replica in recovery mode). For the same query, we observe significantly higher planning time on the replica compared to the primary. Execution ...
- 1
0
votes
1
answer
92
views
Do long running queries get dropped when you restart the PostgreSQL instance?
Maybe this is a very basic question, but I want to be sure.
I am upgrading an RDS cluster with a blue green deployment. I was checking the cluster, following the AWS guidelines, and saw a bunch of ...
- 3
0
votes
1
answer
69
views
How to replicate a database daily without changing WAL postgres settings?
I need to replicate a Postgres database daily (it could also be continuously) to another server but without changing the Postgres settings.
I can't change the database settings because it's from my ...
- 3
0
votes
1
answer
107
views
PostgreSQL HA Cluster equivalent to SQL Server Availability Group Listener object
I've setup a PostgreSQL v16.6 HA Cluster using repmgr. Ensured replication is working between primary and standby nodes. Then I tried simulating a failover event by shutting down PostgreSQL service at ...
- 175