1,859 questions
0
votes
0
answers
25
views
PostgreSQL SSL Replication: Why is WAL Sender Encrypted but Not WAL Receiver?
I am setting up SSL encryption for PostgreSQL replication and have the following configuration:
PostgreSQL Version: 14.3 OpenSSL Version: 3.1.0
Configuration Details:
I have enabled encrypted ...
- 31
0
votes
1
answer
43
views
How to parse logical replication commands
Code
do $$BEGIN
perform pg_create_logical_replication_slot('test', 'pgoutput', false);
END$$ ;
create publication Jalgi_pub for all tables;
select * from pg_logical_slot_peek_binary_changes('test', ...
- 28k
1
vote
2
answers
46
views
Steps to stop replication on Postgres in primary
In Postgres, I want to stop the replication process on the primary. Secondary database is no more working and primary wal folder is growing in size. Can someone help me with what are the settings I ...
- 2,571
0
votes
0
answers
47
views
Scraping/chaining InfluxDB 1.8 data to InfluxDB 2.7
Is there a way to mirror or scrape data from an InfluxDB 1.8 database to a v 2.7.x database?
If I were given two v. 2 databases I think the case would be covered by the (edge) data replication. But I ...
- 333
0
votes
1
answer
42
views
Commit delay for MariaDB Galera cluster and MaxScale
I'm working in a clustered MariaDB database with Galera and MaxScale in r/w routing.
My question is if the commit command successful return implies a completed replication or not.
This is the scenario:...
- 9,577
0
votes
1
answer
68
views
Create named instance in SQL Server Express
I'd like to pull some data into SQL Server Express, from a high-current electrical test machine running SQL Server.
The first problem I'm experiencing is that I can't get replication setup, because ...
- 2,667
0
votes
0
answers
84
views
PostgreSQL v13 Streaming Replication Issue
Using PostgreSQL v13 streaming replication setup between a primary, and secondary (Hot Standby) server. After maintenance reboots of each server were complete, the secondary (a read-replica) is stuck ...
1
vote
0
answers
54
views
Suppress DBCC messages for sp_addarticle
Anyone know how to turn off this unwanted output? I have several stored procedures that are used to tear down and rebuild replication for hundreds of databases.
These stored procedures output lots of ...
- 35
0
votes
0
answers
31
views
Multiplexing read-only/read-write datasource
I've implemented CustomRoutingDataSource. It should multiplex between two DataSources depending on whether current transation is ReadOnly or not.
public class CustomRoutingDataSource extends ...
- 5,308
0
votes
1
answer
80
views
SymmetricDS How do I transform a MySQL Longtext column to a PostgreSQL Text column?
I am working on a replication between a old MySQL 8 database and a new PostgreSQL database.
This is a two way replication but I am having issues with syncing a LongText column in MySQL to a Text ...
- 1
0
votes
0
answers
34
views
Cannot delete or update a parent row: a foreign key constraint fails with Galera and MaxScale
I'm working with two servers MariaDB with galera replication and MaxScale rw router.
One server takes write queryies only, the other one just selects.
I have this sequence of operations:
start ...
- 9,577
0
votes
2
answers
46
views
SQL Server read only failover database CLR enabled
We have enabled CLR on the primary database with a read only synchronized readonly failover database and it works perfectly using the following instruction.
IF EXISTS (SELECT * FROM sys....
- 1,043
0
votes
0
answers
51
views
Handling Replication Lag with ProxySQL in a Spring Boot Application using MySQL InnoDB
I am working on a Spring Boot application using MySQL 8.0.39 with InnoDB and ProxySQL for load balancing between a master and a slave MySQL server. The database is configured to split read and write ...
- 1
1
vote
1
answer
80
views
walsender process and connections via bouncer in Postgres is not using TLS Encryption
I have been testing TLS encryption for my Postgres database. All the external client connections are using SSL for encryption. I tried to query the pg_stat_ssl view, which will list the information ...
- 31
0
votes
0
answers
81
views
SQL Server Replication procedure or function sp_get_redirected_publisher has too many arguments specified
Replication stopped working on a SQL Server 2022 to SQL Server 2022 setup. Snapshot replication, one subscriber. As far as I am aware nothing changed.
I am getting the following error message, every ...
