Re: moving a backup from on-prem linux to azure - Mailing list pgsql-admin

 

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.

Nawaz Ahmed

Database Administrator

Fuji Xerox Australia Pty. Limited
8 Khartoum Rd, Macquarie Park NSW 2113 Australia

| P: 02 9856 5337 | E: Nawaz.Ahmed@aus.fujixerox.com | W: www.fujixerox.com.au |

        





Please think before you print and use duplex printing to preserve resources

From: Mark Steben <mark.steben@drivedominion.com>
Sent: Tuesday, 12 November 2019 6:22 AM
To: pgsql-admin <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,

 

--

Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  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

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.