Cat Peters catpeters

## migrate_postgresql_database.md

      
        
          
            
              
              1 file
            
          
          
            
              
              27 forks
            
          
          
            
              
              30 comments
            
          
          
            
              
              173 stars
            
          
        
        
          
              
          
          
            
                olivierlacan
                / migrate_postgresql_database.md
            
            
              Last active
              March 24, 2022 20:30
            
              
                How to migrate a Homebrew-installed PostgreSQL database to a new major version (9.3 to 9.4) on OS X. See upgraded version of this guide: http://olivierlacan.com/posts/migrating-homebrew-postgres-to-a-new-version/
              
          
        
      
        
  
      
    This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.
First let's check something.
brew info postgresql
The top of what gets printed as a result is the most important: