Re: Re. Postgres Upgrade.

Ron <ronljohnsonjr@xxxxxxxxx> · Sun, 6 Sep 2020 15:55:39 -0500



    On 9/6/20 2:12 PM, Sushil Shirodkar wrote:

    
        Hello experts,
      
        
        Looking for advise/suggestions on the following scenario. 
      
        
        Existing Setup       
                 Moving to

      
        Postgres => 10.5           Postgres => 12.4
        Ubuntu   => 16.04.5     Ubuntu   => 20.04.1
        

        Question: 
        We have new environment ready with PG 10 & PG 12 with
          Ubuntu 20.
        

        To reduce the upgrade time, can I bring the volume(10/main)
          from old 
        server to new server & connect to PG10 and do the
          pg_upgrade ? 
      
    
    What about the binaries?  (Though you can install PG 10 binaries for
    Ubuntu 20.04 easily enough.)

    
        will 
        PG10 running on "Ubuntu 16" work on "Ubuntu 20" for upgrade
          to PG12 ? 
        or I have to go thru pg_dumpall route. 

        
    You could copy the volumes over and pg_upgrade, do a pg_dumpall or
    enable logical replication from one to another.  (That would greatly
    minimize downtime.)

    
    -- 

      Angular momentum makes the world go 'round.