How to create hot standby of Postgres 12/Debian 10.3 in Windows 11 - Mailing list pgsql-general

From Andrus
Subject How to create hot standby of Postgres 12/Debian 10.3 in Windows 11
Date
Msg-id f1d831e9-5864-a1ac-fe3d-76884274ac58@hot.ee
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Kirk Wolak
Date:
Subject: Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...
Next
From: Ron
Date:
Subject: Practical maximum max_locks_per_transaction?