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

Andrus <kobruleht2@xxxxxx> · Fri, 25 Nov 2022 22:56:42 +0200



    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.