pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmoving a backup from on-prem linux to azure
4+ messages / 3 participants
[nested] [flat]
* moving a backup from on-prem linux to azure
@ 2019-11-11 19:21 Mark Steben <mark.steben@drivedominion.com>
2019-11-12 01:45 ` RE: moving a backup from on-prem linux to azure Ahmed, Nawaz (Fuji Xerox Australia) <Nawaz.Ahmed@aus.fujixerox.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mark Steben @ 2019-11-11 19:21 UTC (permalink / raw)
To: pgsql-admin
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/;
<http://autobasedigital.net/marketing/DD12_sig.jpg;
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: moving a backup from on-prem linux to azure
2019-11-11 19:21 moving a backup from on-prem linux to azure Mark Steben <mark.steben@drivedominion.com>
@ 2019-11-12 01:45 ` Ahmed, Nawaz (Fuji Xerox Australia) <Nawaz.Ahmed@aus.fujixerox.com>
2019-11-12 15:31 ` Re: moving a backup from on-prem linux to azure Mark Steben <mark.steben@drivedominion.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ahmed, Nawaz (Fuji Xerox Australia) @ 2019-11-12 01:45 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; 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.
[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.Ahmed@aus.fujixerox.com<mailto:Nawaz.Ahmed@aus.fujixerox.com> | W: www.fujixerox.com.au<http://www.fujixerox.com.au; |
[http://xww.aus.xerox.com/staffdirectory/ebizcard/images/facebook.png]<https://www.facebook.com/FujiXeroxAustralia; [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/twitter.png] <https://twitter.com/fujixeroxaus; [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/linkedin.png] <http://www.linkedin.com/company/fuji-xerox-australia; [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/youtube.png] <https://www.youtube.com/playlist?list=PL1624299D50FAA7C1; [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/blog.png] <http://www.fujixerox.com.au/blog/;
[http://xww.aus.xerox.com/staffdirectory/ebizcard/images/feedback.png]<https://fujixerox.au1.qualtrics.com/jfe/form/SV_ehrj1apkwRRNKYZ;
Please think before you print and use duplex printing to preserve resources[Please think before you print and use duplex printing to preserve resources]<https://www.fujixerox.com.au/en/Company/Sustainability;
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<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<http://www.fb.com/DominionDealerSolutions;
www.twitter.com/DominionDealer<http://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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: moving a backup from on-prem linux to azure
2019-11-11 19:21 moving a backup from on-prem linux to azure Mark Steben <mark.steben@drivedominion.com>
2019-11-12 01:45 ` RE: moving a backup from on-prem linux to azure Ahmed, Nawaz (Fuji Xerox Australia) <Nawaz.Ahmed@aus.fujixerox.com>
@ 2019-11-12 15:31 ` Mark Steben <mark.steben@drivedominion.com>
2019-11-12 19:32 ` Re: moving a backup from on-prem linux to azure SAS <sas.postgresql@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mark Steben @ 2019-11-12 15:31 UTC (permalink / raw)
To: Ahmed, Nawaz (Fuji Xerox Australia) <Nawaz.Ahmed@aus.fujixerox.com>; +Cc: pgsql-admin
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.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/ 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.Ahmed@aus.fujixerox.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.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* <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;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: moving a backup from on-prem linux to azure
2019-11-11 19:21 moving a backup from on-prem linux to azure Mark Steben <mark.steben@drivedominion.com>
2019-11-12 01:45 ` RE: moving a backup from on-prem linux to azure Ahmed, Nawaz (Fuji Xerox Australia) <Nawaz.Ahmed@aus.fujixerox.com>
2019-11-12 15:31 ` Re: moving a backup from on-prem linux to azure Mark Steben <mark.steben@drivedominion.com>
@ 2019-11-12 19:32 ` SAS <sas.postgresql@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: SAS @ 2019-11-12 19:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2019-11-12 19:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-11-11 19:21 moving a backup from on-prem linux to azure Mark Steben <mark.steben@drivedominion.com>
2019-11-12 01:45 ` Ahmed, Nawaz (Fuji Xerox Australia) <Nawaz.Ahmed@aus.fujixerox.com>
2019-11-12 15:31 ` Mark Steben <mark.steben@drivedominion.com>
2019-11-12 19:32 ` SAS <sas.postgresql@gmail.com>
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