From: MichaelDBA <MichaelDBA@sqlexec.com>
Sent: Thursday, January 30, 2020 7:19 AM
To: Ken Benson <Ken@infowerks.com>
Cc: pgsql-admin@lists.postgresql.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