How to create hot standby of Postgres 12/Debian 10.3 in Windows 11
Andrus <kobruleht2@hot.ee>
From: Andrus <kobruleht2@hot.ee>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2022-11-25T20:56:42Z
Lists: pgsql-general
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.