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

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?

On Mon, Nov 11, 2019 at 8:45 PM Ahmed, Nawaz (Fuji Xerox Australia) <
Nawaz(dot)Ahmed(at)aus(dot)fujixerox(dot)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/ 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.
>
> [image: Fuji Xerox Australia]
>
> *Nawaz Ahmed*
>
> *Database Administrator*
>
> Fuji Xerox Australia Pty. Limited
> 8 Khartoum Rd, Macquarie Park NSW 2113 Australia
>
> *|* P: 02 9856 5337 *|* E: Nawaz(dot)Ahmed(at)aus(dot)fujixerox(dot)com *|* W:
> www.fujixerox.com.au *|*
>
> <https://www.facebook.com/FujiXeroxAustralia>
> <https://twitter.com/fujixeroxaus>
> <http://www.linkedin.com/company/fuji-xerox-australia>
> <https://www.youtube.com/playlist?list=PL1624299D50FAA7C1>
> <http://www.fujixerox.com.au/blog/>
>
> <https://fujixerox.au1.qualtrics.com/jfe/form/SV_ehrj1apkwRRNKYZ>
>
>
>
> Please think before you print and use duplex printing to preserve resources[image:
> Please think before you print and use duplex printing to preserve resources]
> <https://www.fujixerox.com.au/en/Company/Sustainability>
>
> *From:* Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
> *Sent:* Tuesday, 12 November 2019 6:22 AM
> *To:* pgsql-admin <pgsql-admin(at)postgresql(dot)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,
>
>
>
> --
>
> *Mark Steben*
> Database Administrator
> *(at)utoRevenue* <http://www.autorevenue.com/> | *Autobase*
> <http://www.autobase.net/>
> *CRM division of Dominion Dealer Solutions*
> 95D Ashley Ave.
> West Springfield, MA 01089
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions
> www.twitter.com/DominionDealer
> www.drivedominion.com <http://www.autorevenue.com/>
>
>
>
>
>
> IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments,
> is private and confidential and may contain legally privileged information.
> It is for the addressee's attention only. If you are not the intended
> recipient and have received this transmission, you must not use, edit,
> print, copy or disclose its contents to any person or disseminate the
> information contained herein or hereto attached, and you must notify sender
> immediately by return email and delete this transmission from your system.
> Any confidentiality, privilege or copyright is not waived or lost because
> this e-mail has been sent to you in error. We have used reasonable efforts
> to protect this transmission from computer viruses and other malicious
> software, but no warranty is made and the sender takes no responsibility
> for any loss or damage incurred from using this email or the information
> contained in this email.
>

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>