pg_logical - for PG 9.59 running on windows server

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

pg_logical - for PG 9.59 running on windows server

opa6x57

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

 

Reply | Threaded
Open this post in threaded view
|

Re: pg_logical - for PG 9.59 running on windows server

Michaeldba@sqlexec.com
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. 

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

 


Reply | Threaded
Open this post in threaded view
|

RE: pg_logical - for PG 9.59 running on windows server

opa6x57

From: MichaelDBA <[hidden email]>
Sent: Thursday, January 30, 2020 7:19 AM
To: Ken Benson <[hidden email]>
Cc: [hidden email]
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