Re: moving a backup from on-prem linux to azure

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)
> <[email protected] <mailto:[email protected]>> 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 <[email protected]
>     <mailto:[email protected]>>
>
>     *Sent:* Tuesday, 12 November 2019 6:22 AM
>     *To:* pgsql-admin <[email protected]
>     <mailto:[email protected]>>
>     *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