Обсуждение: pg_logical - for PG 9.59 running on windows server

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

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