2 votes

How to Identify the Most Up-to-Date Secondary Replica in a SQL Server Always On Availability Group when the primary replica is unavailable?

Assume a situation where the primary replica is down. The objective is to identify the secondary replica with the most up-to-date data in the absence of real-time communication with the primary. For ...
Sean Gallardy's user avatar
2 votes

How to lock an entire Postgres database

Setting up a streaming replication standby server in PostgreSQL is much easier than that. Follow the documentation. MySQL is quite different from PostgreSQL when it comes to replication. A simple ...
Laurenz Albe's user avatar
  • 50.3k
1 vote

SQL Server - moving databases to an earlier version - options

Short Answer Option #3. Upgrade/replace the target(s) to SQL 2019. Long Answer We run into a similar issue whenever we first implement a new version of SQL Server. We have a number of secondaries, ...
Doug Deden's user avatar
  • 1,724
1 vote

How to create a pg_basebackup for without streaming?

The -Xs option to pg_basebackup makes it open a second replicatiom connection the database server and stream the WAL to be stored in the pg_wal directory of the base backup. That way, you can get a ...
Laurenz Albe's user avatar
  • 50.3k

Only top scored, non community-wiki answers of a minimum length are eligible