Darafei Praliaskouski Komzpa

## upgrade-postgres-9.4-to-9.5-to-9.6-to-10.md

      
        
          
            
              
              1 file
            
          
          
            
              
              5 forks
            
          
          
            
              
              12 comments
            
          
          
            
              
              25 stars
            
          
        
        
          
              
          
          
            
                Komzpa
                / upgrade-postgres-9.4-to-9.5-to-9.6-to-10.md
            
            
              Last active
              January 15, 2021 18:04
                — forked from dideler/upgrade-postgres-9.3-to-9.4.md
            
              
                Upgrading PostgreSQL from 9.4 to 9.5 to 9.6 to 10 when upgrading Ubuntu 14.10 to 16.04
              
          
        
      
        
  
      
    TL;DR
9.4 -> 9.5:
sudo pg_dropcluster 9.5 main --stop
sudo service postgresql stop
sudo pg_upgradecluster -m upgrade -k 9.4 main
sudo su postgres -c "/usr/lib/postgresql/9.5/bin/vacuumdb --all --analyze-in-stages"
sudo pg_dropcluster 9.4 main