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

From Julie Nishimura
Subject adding more space to the existing server
Date
Msg-id BYAPR08MB50148CE9EA5DB6321948BD7EACDF0@BYAPR08MB5014.namprd08.prod.outlook.com
Whole thread Raw
Responses Re: adding more space to the existing server
Re: adding more space to the existing server
List 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

pgsql-general by date:

Previous
From: Gilles Darold
Date:
Subject: Re: Oracle to postgres migration via ora2pg (blob data)
Next
From: Ron
Date:
Subject: Re: adding more space to the existing server