Re: adding more space to the existing server - Mailing list pgsql-general

From Ron
Subject Re: adding more space to the existing server
Date
Msg-id 29a4fd4a-4a47-8ca8-faeb-e22fb90ae26c@gmail.com
Whole thread Raw
In response to adding more space to the existing server  (Julie Nishimura <juliezain@hotmail.com>)
List pgsql-general
On 7/31/19 5:21 PM, Julie Nishimura wrote:
P {margin-top:0;margin-bottom:0;}
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

Can we correctly infer that you aren't using LVM?  (Or in there no more room on the rack/controller for new drives?)

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: adding more space to the existing server
Next
From: Luca Ferrari
Date:
Subject: Re: Cursors for PGJDBC queries