Re: adding more space to the existing server

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 31 Jul 2019 23:21:15 -0500



    On 7/31/19 5:21 PM, Julie Nishimura wrote:

    
        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.