Thread

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

Andrus <kobruleht2@hot.ee> — 2022-11-25T20:56:42Z

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.