RE: pg_logical - for PG 9.59 running on windows server

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
Sent: Thursday, January 30, 2020 7:19 AM
To: Ken Benson <Ken(at)infowerks(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_logical - for PG 9.59 running on windows server

Hi Ken,

On a side issue of upgrading to PG V11, why not PG V12? It already has one minor upgrade applied to it, 12.1.
[Ken.B] We typically wait for the 'next' release .. we would switch to 12 when 13 is released. Until then, we'll stay on 11.x

Regards,
Michael Vitale

Ken Benson wrote on 1/30/2020 10:09 AM:

Does anyone have a compiled version of the pg_logical module/package for Windows Server, PostgreSQL version 9.5.9?
We have not been able to get a clean compile.

We have a fairly large database (1.29 TB raw size of the data cluster) running on Windows Server, PosgreSQL 9.5.9

We have created a new Linux server (11.4) - and are looking for the least-down-time method to get that database migrated from Windows/9.5.9 to Linux/11.4

Is pg_logical a viable alternative?
If so - how do I get a compiled version for my 'source' server.

Ken Benson | ken @ infowerks-dot-com