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