Subject: Re: moving a backup from on-prem linux to azure
To: pgsql-admin@lists.postgresql.org
References: 
 <CADyzmyyiyk7rKYkMqH2QmJPAO5yWeyKu1Nub1dDydu5qMpO1sA@mail.gmail.com>
 <SG2PR06MB2521BB5AC29910A6DA668394BC770@SG2PR06MB2521.apcprd06.prod.outlook.com>
 <CADyzmyxEZaL8-=2Nd4cZy632j+0FrtG5ZdAgN19NUn4aw3c+ZQ@mail.gmail.com>
From: SAS <sas.postgresql@gmail.com>
Autocrypt: addr=sas.postgresql@gmail.com; prefer-encrypt=mutual; keydata=
 mQINBF1TwC8BEADzdG8ZReoeRLmPqB5Y8GFlu2Rf9RhUqHz7/aK4V07aC2rIN/AtmHd/MiqO
 dqXJ695qODcFGWwXZHnlgjZy5adgzviG06DTzqtFm0hLDglgBrfjQWKnhaYARRsNltMYL+eh
 lzDtkqI7mY6pPWQJ0vRwm/2S8HyWVPpM/kAgZdGqmdmh+ks6bNXPXqF+nIcbmWBQKwEjoSQN
 s36mIU0ZRLJnFJfMsK006TqwzEGIufrQ9OKNmEbKlFU+PHE4ro9lK19yXl/KwMjFavO5t7qF
 DT7f7fXOoFulxOHFSY6FdKe33mXVAI/6DSRi3QFtXsME/apaFeFluUCoBFmKzoe4Kat6Wr3L
 GFMI0uCLGXy9VXAKuhcIVqU3AVfJtJmnM4sty/693FcnfpoRjPkgln0XCw1lj5I9JQOwq+R7
 IGdPVVzK3QzFHPRAvVF7pha175AeE2UyfdvCIM8fBp2T3Tit6AfkxyM+6vi5T5O3lE5+XecZ
 RqrTlnUMGxSMb55/mruhqo4mV1CHQRVBPqxwHcuEQcthsepRgvyVpAoYkI6OitUoYsGIbMql
 A00egksR0V+6zjWpx+G8gDXuPGxL2JNBg1yb/jvygww1A4VrnwqS5nmKiVIOXYgML+U7rn13
 gouTaiwjDCNESVcWhxmQoiAofPauMM5itGAFHIbmSkFNmA7IiwARAQABtB5TQVMgPHNhcy5w
 b3N0Z3Jlc3FsQGdtYWlsLmNvbT6JAlQEEwEKAD4WIQQYFCr7KOpZp+rWJwjdRfi2pUecIQUC
 XVPALwIbIwUJCWYBgAULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRDdRfi2pUecITcOEAC7
 woia7Z8+OhrqtMfkCwGqVzWGw70Er1uDqifUy4RU15zvkQTkpN6UA9nPZFRT+sGiQxEt3gb+
 Oj4d/SY24GUPaK2viEG6Cfd/VyjT0KKs2ScR0c1Oka3R1czhHcCTc4oR/WcAUQW1ld28MSAk
 zYlrGH4P1FsbMpqH+QAC+KKBaIr+/E9DQbH9lgOViI+AYKoLsbz5HCTmUHZ52/njtFDkvZdv
 ihdx4kJ9Kt7J5mWxWr2f0wIClCqWouDubdRwRxSGLM1a/ivHtEl3rz2eJoLbj1SS//28Nqw0
 rPRd10ZNoWoyWpmbcw83JL8lDkMU9RmrN+PJypCBj3nUOKglcPB0dCfsKtaHbH+qtHTfFm9p
 m/07IrqTW1gOx4z2wOpuiAh4Fdy8SatoNpm6PF3T/2V2ckXlx6GqDhDeLChsinQK6VXLQbYO
 e3WPTSrREVdFgv97NlzRIY9vGBUd8EOm2YX3nRDkwLbWsqPXjiUFizR1V8EvdzzLLYmUmIyU
 HhdYecCZIzY9U6XfkXvLfBttrRSpqQ1ZCFdvuZzRN5R9Vy7O4Rxat8RyH/4D3oena43ypfbk
 ajIlrRi7ElzXJ3YIC4lq/+q12Q+We6a62nUpI8+xNpDV/qzD8jjWcfDSkrml5QWpYoRZrbJo
 VqUZDRX8mN3V59Nvw1rncXLPsOMnlt3lcbkCDQRdU8AvARAA0xCon2NJFabIdSaBAG8Qy2cJ
 MfTY6coSgQbx0EFv+P+SJc5x97QaefMr/bgkf/AYfpREi65spov8uEnn6IXWH+u+Y48/U1xU
 YsakBr2TzFDKhB8RkMuCVo+BJyahm9WlVLFWNJI7GfGeni772aI310peXBlTCDGKop1QZfAp
 IVSr7jTqNcYED/P6L2S3agiaY1HyQceGwQeJsDywrUaBzTDFg9nXHLzpdrrxUDsVOoB/4A/r
 lWtCAGnjDnOaaVkpwRjzdGaU+ed+yz13yvKjuDbDy/3EVQKUkbq6JOUuxnEhQyp1MFhTkolV
 eIS/MuToWikHzlMFAC6YZDilklnLR0GRJcRiYlLenuYwr8z3gdyuDUQ3bcCdaaIUS2M4CqzR
 1v/x9JiAIOyoEK8CXtwn9pSb/AGia0PDXyh09gn7WGyNyCrGK7vJyheLbuxIdv2czRxfvoVT
 woaXi1jVJP72j/e3OyZku/1FBmvP2x/DZSYN2+WESRxL1/WjdvvXQ8mXDrCJkoA8yQQzN5aR
 6StToPaJ4b0iIIrpqy0is2RLYccQN+5QhrG1x17TmpmaDgJK5XWSeTssraDntx5GTM/gz87j
 hot90StLYQxEcPUGij04WV+iy7r+NG1kruRwkK7ZE0H8hUyVeGBgkmBOWrc1p2v8fKI19oTL
 bKHbAQCgVz0AEQEAAYkCPAQYAQoAJhYhBBgUKvso6lmn6tYnCN1F+LalR5whBQJdU8AvAhsM
 BQkJZgGAAAoJEN1F+LalR5whRRQQAIkuq64fKnArkyTp/rWtzAn9uQ9cPVqKcol2lLaaUY97
 q0ZSefPliz4qpz4CPfQNDTCngSdBgfDLKTuuKLthHe5IgZwUiw1AA+reF7PP+HKGzVv5pqqz
 uIQJwY8xTnIuyL78JhN4Z4Mihism/iufT2MleKzUNSGr8RjASdvHTwFnAqQN7FevNK4QoCRm
 i0da9ZuJh7t0LDFtV+IysaOFvE9//gXATvnBZzQ8/TkAPaJ+Y/yWlSlKtekxhWxMxayID0Zi
 /Om90DYveRVadck6x52jvt1HEu2v5XtXIUmdjM3qaaKrPIRuMrox5vR9K6EouUndSd1/pw2Y
 1mILzogeO133yeqVf4aw9740PT51kMowCt2dj5AegYq3hBXYCv51OO0B1pM+pyDwVbgD2iif
 /rpyRPWZMk0RxmeUfH+wOIztfdtr1iMcJzYD62EuXE4DH4Bi2x0pwqPvFxbzt0V4qq7Nc8jf
 ThgKrUbfLrfcMrjdqPLnYj+EDfNrVVYqoz4Q/xjPvCiV42N1CLeUyDwm+TYrKyW+ax16XxjK
 PMnLozdWEiJ8bz3N8FYax6AfzSGGY2/BCpygnmWQAvDodZQNBnFn37aGiarLEZaUCCDsxQrx
 SK/28CU01eH1Ws5rCS5FsdNbmYQlHHYPVpXdZcA8hbnZ3BirRV88KlDcgrA2eCO8
Message-ID: <94473c83-d2b6-3fb8-eba4-f1a7fb09ec20@gmail.com>
Date: Tue, 12 Nov 2019 20:32:38 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.1.2
MIME-Version: 1.0
In-Reply-To: 
 <CADyzmyxEZaL8-=2Nd4cZy632j+0FrtG5ZdAgN19NUn4aw3c+ZQ@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------F975764C342DA6B349B7E269"
Content-Language: fr
Precedence: bulk

This is a multi-part message in MIME format.
--------------F975764C342DA6B349B7E269
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

Le 12/11/2019 à 16:31, Mark Steben a écrit :
> Thank you for your prompt response Nawaz.  We have used slony in the past and
> can consider it again.
> I was thinking as an alternative to perform an in-place upgrade (9.4 to 11.5)
> on the on-prem server, then setting up streaming replication to azure.  Is
> that possible?


If you can set up an Azure PG has a replica, you should be able to do it that way.

>
> On Mon, Nov 11, 2019 at 8:45 PM Ahmed, Nawaz (Fuji Xerox Australia)
> <Nawaz.Ahmed@aus.fujixerox.com <mailto:Nawaz.Ahmed@aus.fujixerox.com>> wrote:
>
>      
>
>     I would suggest using Slony to setup a replication slave (PG9.6 or even
>     PG12) on the azure server and disconnect the replica from source (PG9.4)
>     once everything is migrated across. And, you would have upgraded to the
>     latest version and migrated to Azure in a single approach. Please visit
>     http://www.slony.info/ <http://www.slony.info/> for the exact approach
>     but I reckon it is from a 9.3 to 9.4 within an on-prem setup. However, in
>     your case you just have to replace the on-prem steps of the replica with
>     Azure config.
>
>     *From:*Mark Steben <mark.steben@drivedominion.com
>     <mailto:mark.steben@drivedominion.com>>
>
>     *Sent:* Tuesday, 12 November 2019 6:22 AM
>     *To:* pgsql-admin <pgsql-admin@postgresql.org
>     <mailto:pgsql-admin@postgresql.org>>
>     *Subject:* moving a backup from on-prem linux to azure
>
>      
>
>     Good afternoon,
>
>      
>
>     We are contemplating moving our linux based production postgres database
>     to our Azure subscription.  What is the most common method of moving a
>     pg_dump file to azure to perform a pg_restore?  (We are running postgres
>     9.4 - I realize we would have to upgrade to at least 9.6 to restore to
>     azure). 
>
>      
>
>     Any comments welcome.  Thank you,
>
>      
>

-- 
Dr Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone
+33 617 11 37 42


--------------F975764C342DA6B349B7E269
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Le 12/11/2019 à 16:31, Mark Steben a
      écrit :<br>
    </div>
    <blockquote type="cite"
cite="mid:CADyzmyxEZaL8-=2Nd4cZy632j+0FrtG5ZdAgN19NUn4aw3c+ZQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Thank you for your prompt response Nawaz.  We have
        used slony in the past and can consider it again.
        <div>I was thinking as an alternative to perform an in-place
          upgrade (9.4 to 11.5) on the on-prem server, then setting up
          streaming replication to azure.  Is that possible?</div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>If you can set up an Azure PG has a replica, you should be able
      to do it that way.<br>
    </p>
    <blockquote type="cite"
cite="mid:CADyzmyxEZaL8-=2Nd4cZy632j+0FrtG5ZdAgN19NUn4aw3c+ZQ@mail.gmail.com"><br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Mon, Nov 11, 2019 at 8:45
          PM Ahmed, Nawaz (Fuji Xerox Australia) &lt;<a
            href="mailto:Nawaz.Ahmed@aus.fujixerox.com"
            moz-do-not-send="true">Nawaz.Ahmed@aus.fujixerox.com</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
          <div lang="EN-AU">
            <div class="gmail-m_8712986492753120630WordSection1">
              <p class="MsoNormal"> </p>
              <p class="MsoNormal">I would suggest using Slony to setup
                a replication slave (PG9.6 or even PG12) on the azure
                server and disconnect the replica from source (PG9.4)
                once everything is migrated across. And, you would have
                upgraded to the latest version and migrated to Azure in
                a single approach. Please visit <a
                  href="http://www.slony.info/" target="_blank"
                  moz-do-not-send="true">
                  http://www.slony.info/</a> for the exact approach but
                I reckon it is from a 9.3 to 9.4 within an on-prem
                setup. However, in your case you just have to replace
                the on-prem steps of the replica with Azure config.</p>
              <b><span lang="EN-US">From:</span></b><span lang="EN-US">
                Mark Steben &lt;<a
                  href="mailto:mark.steben@drivedominion.com"
                  target="_blank" moz-do-not-send="true">mark.steben@drivedominion.com</a>&gt;
              </span><br>
              <span lang="EN-US"></span>
              <p class="MsoNormal"><span lang="EN-US">
                  <b>Sent:</b> Tuesday, 12 November 2019 6:22 AM<br>
                  <b>To:</b> pgsql-admin &lt;<a
                    href="mailto:pgsql-admin@postgresql.org"
                    target="_blank" moz-do-not-send="true">pgsql-admin@postgresql.org</a>&gt;<br>
                  <b>Subject:</b> moving a backup from on-prem linux to
                  azure</span></p>
              <p class="MsoNormal"> </p>
              <div>
                <p class="MsoNormal">Good afternoon,</p>
                <div>
                  <p class="MsoNormal"> </p>
                </div>
                <div>
                  <p class="MsoNormal">We are contemplating moving our
                    linux based production postgres database to our
                    Azure subscription.  What is the most common method
                    of moving a pg_dump file to azure to perform a
                    pg_restore?  (We are running postgres 9.4 - I
                    realize we would have to upgrade to at least 9.6 to
                    restore to azure). </p>
                </div>
                <div>
                  <p class="MsoNormal"> </p>
                </div>
                <div>
                  <p class="MsoNormal">Any comments welcome.  Thank you,<br
                      clear="all">
                  </p>
                  <div>
                    <p class="MsoNormal"> </p>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </blockquote>
      </div>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      <div>
        <div><font color="#00aee6">Dr Stéphane Schildknecht</font></div>
        <div>Contact régional PostgreSQL pour l'Europe francophone</div>
        <div>+33 617 11 37 42</div>
        <br>
      </div>
    </div>
  </body>
</html>

--------------F975764C342DA6B349B7E269--