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

From: Andrus <kobruleht2(at)hot(dot)ee>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to create hot standby of Postgres 12/Debian 10.3 in Windows 11
Date: 2022-11-25 20:56:42
Message-ID: f1d831e9-5864-a1ac-fe3d-76884274ac58@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Browse pgsql-general by date

  From Date Subject
Next Message Zheng Li 2022-11-25 22:23:09 Re: Support logical replication of DDLs
Previous Message Kirk Wolak 2022-11-25 18:35:08 Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...