Michael Hoitomt hoitomt

## 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:

  
## app.py
os
from flask_extended import Flask

app = Flask(__name__)
app.config.from_yaml(os.join(app.root_path, 'config.yml'))
	os
	from flask_extended import Flask

	app = Flask(__name__)
	app.config.from_yaml(os.join(app.root_path, 'config.yml'))