Postgres Pro
Downloads
Home   >   mailing lists

Postgres Migration from Postgres 9.0 on Windows to Postgres 10.0 on Linux - Mailing list pgsql-novice

From Peter Neave
Subject Postgres Migration from Postgres 9.0 on Windows to Postgres 10.0 on Linux
Date
Msg-id 8962f2ec5c8544bd9d1bff2878233ba4@EXCH1.WEATHERTOP.local
Whole thread Raw
Responses Re: Postgres Migration from Postgres 9.0 on Windows to Postgres 10.0on Linux  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Postgres Migration from Postgres 9.0 on Windows to Postgres 10.0 on Linux  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-novice
Tree view

Hi,

 

I’ve been tasked with migrating our production database from Postgres 9.0 on Windows to Postgres 10.0 on Linux. I’ve used pg_dump and pg_restore and it works fine but the time taken for my dry run of the migration is about 12 hours (8 hours backup and 4 hours restore)

 

What can I do to reduce the migration time so that I can get production up and running again as soon as possible? I have the option to upgrade either machine if that helps and in that case what would help most faster disk IOPS? RAM? CPU?

 

Peter


Want faster answers from InfoTech? Check out www.portal.jims.net


Jim's Group
 Peter Neave | DevOps Lead | Peter.Neave@jims.net
 Jim's Group Pty Ltd
 48 Edinburgh Rd | Mooroolbark | VIC, 3138
 P 1300 130 490 | Intl +61 3 8419 2910


This email and any attachment(s) are confidential. If you are not the intended recipient you must not copy, use, disclose, distribute or rely on the information contained in it. If you have received this email in error, please notify the sender immediately by reply email and delete the email from your system. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. While Jim's Group employs Anti-Virus Software, we cannot guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and we recommend that this email and any attachments be tested before opening.

Please consider the environment before printing this email.


Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au
 
 
Attachment

pgsql-novice by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: does postgresql 10 have something similar to sql server's setidentity_insert
Next
From: Thomas Kellerer
Date:
Subject: Re: Postgres Migration from Postgres 9.0 on Windows to Postgres 10.0on Linux