Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ixBao-0000rP-7u
	for pgsql-admin@arkaria.postgresql.org; Thu, 30 Jan 2020 15:18:54 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ixBal-0003PC-Fq
	for pgsql-admin@arkaria.postgresql.org; Thu, 30 Jan 2020 15:18:51 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1ixBal-0003P5-6W
	for pgsql-admin@lists.postgresql.org; Thu, 30 Jan 2020 15:18:51 +0000
Received: from mout.perfora.net ([74.208.4.197])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1ixBai-00053g-HV
	for pgsql-admin@lists.postgresql.org; Thu, 30 Jan 2020 15:18:50 +0000
Received: from [192.168.1.143] ([98.169.208.73]) by mrelay.perfora.net
 (mreueus001 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LpdNQ-1jSNfi25pu-00fPji;
 Thu, 30 Jan 2020 16:18:40 +0100
Subject: Re: pg_logical - for PG 9.59 running on windows server
To: Ken Benson <Ken@infowerks.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
References: 
 <MWHPR19MB009681980029F05EF145B6B5A3040@MWHPR19MB0096.namprd19.prod.outlook.com>
From: MichaelDBA <MichaelDBA@sqlexec.com>
Message-ID: <cb578a17-c0fc-6a44-9d55-2953f49d8d94@sqlexec.com>
Date: Thu, 30 Jan 2020 10:18:38 -0500
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 PostboxApp/7.0.11
MIME-Version: 1.0
In-Reply-To: 
 <MWHPR19MB009681980029F05EF145B6B5A3040@MWHPR19MB0096.namprd19.prod.outlook.com>
Content-Type: multipart/alternative;
 boundary="------------35F1495882B5302A34AE96CC"
Content-Language: en-US
X-Provags-ID: V03:K1:KtVXK6e4lpt4EdX7JAI8kY+IxOzTS2joojao6euvieneWe2BolD
 KDnGziEj7XXn1t2nP6Nj7e0vmTNiAOJ0AcXTL+5kfpqLjtG9KERkEpqkBeJlZEauvfrGNcF
 79BXCyF+Sgyopnht38b5VGzNt6zCPTqr3DjY3oirTmD9d4LEE27/BOmZfMaFOGNOAwPgfdQ
 OYLcv5D7YDpxaJ3D3sNHg==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:Ngu5skgTt74=:DoSVlRMYiEtjG0aiD3uCuD
 x8Jv8TbHPb2Ps89cpyVtBvgXs1SxOh68a6qzItOGwxrncoTitXA7gPo8xzNYaaC03kHDY2m8G
 vdPxFUspmwPlztyFvIz8pWvzSQSS8lvtAFFXp1tYbQPIuK4TNSyk/S2fxS7+eWMWPj9Yx0qk9
 oIFkNzUPyOMF4W3x0Lv4bRsIIs9Su9LczOS4OnT+jQWhWeT97y+itl8Eb67LEKsLK0KWk2J8y
 YWLRtzCd685H6YRdEp6nvNQTS+IPoDuxwxHvsAxFW0x2TgYi1bI/gM2+RJA0MpKw0YzWkwqqp
 MyWI/xm1/EYuUM0XJmUPoFUe1+TnzrzH/sVRbdXcmnEXWhxJOVwDdbpyyW3ESlq3IuI++uXXj
 8YySxHEOeWGNoZUqQB8qnWO1ijxifGgqu24A3EQel6/JRSYJq4st7j+hw5NM9m4qIl4x/DIZg
 pfalrDNmWQf77V4bIXphsfATsxTx9ly2ldEElOuxfO4QkOoIVPhEjITikBo21QdfbLiDwfvT9
 JGRCmbyjIHZ2m/4VGLqxkiqzHMexqc2jax1Qd89pWzFLY7SAFSR5rfyY0sTQHgNA94+iFZmvp
 +j02FfDjt5wJkjgfXV31N8dBVblzPdVHOWfI4hwE7O5tGaQ9oCr/SXXthGCukW6DgxJgwj004
 DD0qFebBzPRSlbi770gRG9LNzUe2l9sa6nlfM/DS695Aoqrk1AAS4KiYtFZ2V1/ZzZI+JK4Ln
 LCnLiTCK4eyu0Py3/ylWvZnUDDOoMmLIaLSfGtHwzcEMlVIf+nGuItTL+gipg26RVUOWMMRNg
 wx/6MCziQKjkKNGg2bpZuqG+gRWeY6fpa2DyZeqQadyyDTAH3Te2TIZnl4ODd56Q9+Q0AT5
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

This is a multi-part message in MIME format.
--------------35F1495882B5302A34AE96CC
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

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
>


--------------35F1495882B5302A34AE96CC
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit

<html theme="default-light"><head>
<meta http-equiv="Content-Type" content="text/html; 
charset=windows-1252">
</head><body text="#000000">Hi Ken,<br>
<br>
On  a side issue of upgrading to PG V11, why not PG V12?  It already has
 one minor upgrade applied to it, 12.1.  <br>
<br>
Regards,<br>
Michael Vitale<br>
<br>
<span>Ken Benson wrote on 1/30/2020 10:09 AM:</span><br>
<blockquote type="cite" 
cite="mid:MWHPR19MB009681980029F05EF145B6B5A3040@MWHPR19MB0096.namprd19.prod.outlook.com">
  <meta http-equiv="Content-Type" content="text/html; 
charset=windows-1252">

  <meta name="Generator" content="Microsoft Word 15 (filtered medium)">

  <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->


  <div class="WordSection1">
<p class="MsoNormal">Does anyone have a compiled version of the 
pg_logical module/package for Windows Server, PostgreSQL version 9.5.9?<br>
We have not been able to get a clean compile. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We have a fairly large database (1.29 TB raw size 
of the data cluster) running on Windows Server, PosgreSQL 9.5.9<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is pg_logical a viable alternative?<o:p></o:p></p>
<p class="MsoNormal">If so – how do I get a compiled version for my 
‘source’ server.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:&quot;Times New 
Roman&quot;,serif">Ken Benson | ken @ infowerks-dot-com<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
  </div>
</blockquote>
<br>
</body></html>

--------------35F1495882B5302A34AE96CC--