adding more space to the existing server

From: Julie Nishimura <juliezain(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: adding more space to the existing server
Date: 2019-07-31 22:21:00
Message-ID: BYAPR08MB50148CE9EA5DB6321948BD7EACDF0@BYAPR08MB5014.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello postgres folks,

We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully populate, then breaking replication, making the standby the primary, upgrade the disks on the other system, bring it back up, replicate backwards until fully replicated then failing-back to the original primary. Is this feasible?

Our current size is 22 tb, and it is 97% full
(PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit)

Thank you for your suggestions

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-08-01 04:21:15 Re: adding more space to the existing server
Previous Message Gilles Darold 2019-07-31 21:05:28 Re: Oracle to postgres migration via ora2pg (blob data)