Thread: How to create hot standby of Postgres 12/Debian 10.3 in Windows 11

How to create hot standby of Postgres 12/Debian 10.3 in Windows 11

From
Andrus
Date:

Hi!

Postgres 12 from Postgres repository is running in Debian 10.3  VPS server:

PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit

(its upgrade is currently not an option).

Cluster should mirrored to Windows 11 workstation in real time over internet.

I installed Debian in Windows 11  using Linux Subsystem for Windows with

wsl --install Debian

This installs Debian 11.5

I tried to install Postgres 12 for replication in this Debian using

sudo apt install postgresql-12

but this fails with

E: Unable to locate package postgresql-12

How to install Postgres 12 in Debian 11.5 ?

Will this replication work since Debian versions are different but hopefully locale implementations are same ?

Which is most reasonable way to replicate whole Postgres 12/Debian 10.3  cluster in Windows 11 ?

Andrus.