Re: Upgrading 9.1.17 to which version?

From: nigel(dot)andersen(at)gmx(dot)com
To: psql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Upgrading 9.1.17 to which version?
Date: 2019-05-17 11:04:16
Message-ID: trinity-1aa7707a-2cda-41f6-a832-5b2298986de3-1558091056631@3c-app-mailcom-bs16
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>Get a second machine, set it up to be as identical to the existing machine as you can - aside from it not >being near death - and migrate "production" to it.

>Then on the machine described above install v10 and whatever else you need for staging/testing and then >once everything checks out migrate the production database to the new machine and point production >resources to it.

>Lastly, but first, consider finding an experienced professional to evaluate you exact current >circumstances and execute the above - or whatever they recommend.  The first item warrants doing that at >the least.  You can delay deciding on how to approach the second option until after your production >environment is stable.

>David J.

Thanks for that. It's effectively what I've done by re-incarnating a disused dev server that had an identical install as the prod db server. I dumped the db's last night and loaded them up without any issue. It's a slower machine but it hasn't got disks that are going AWOL and at least gives me some breathing space to setup the new server and test migrate the databases across to a newer version of PostgreSQL today/over the weekend.

Browse pgsql-general by date

  From Date Subject
Next Message nigel.andersen 2019-05-17 11:06:11 Re: Upgrading 9.1.17 to which version?
Previous Message Malte Swart 2019-05-17 08:56:17 pg_rewind and full_page_writes on zfs