From: SAS <sas.postgresql@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: moving a backup from on-prem linux to azure
Date: Tue, 12 Nov 2019 20:32:38 +0100
Message-ID: <94473c83-d2b6-3fb8-eba4-f1a7fb09ec20@gmail.com> (raw)
In-Reply-To: <CADyzmyxEZaL8-=2Nd4cZy632j+0FrtG5ZdAgN19NUn4aw3c+ZQ@mail.gmail.com>
References: <CADyzmyyiyk7rKYkMqH2QmJPAO5yWeyKu1Nub1dDydu5qMpO1sA@mail.gmail.com>
<SG2PR06MB2521BB5AC29910A6DA668394BC770@SG2PR06MB2521.apcprd06.prod.outlook.com>
<CADyzmyxEZaL8-=2Nd4cZy632j+0FrtG5ZdAgN19NUn4aw3c+ZQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sas.postgresql@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: moving a backup from on-prem linux to azure
In-Reply-To: <94473c83-d2b6-3fb8-eba4-f1a7fb09ec20@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox