Joseph Pawletko jgpawletko

## upgradepg.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              4 stars
            
          
                oz
                / upgradepg.md
            
            
              Created
              December 19, 2014 15:21
            
              
                Upgading from PG 9.3 to PG 9.4 on Mac OS X, with Homebrew
              
          
    Brew upgrade...

Run the usual brew update, and brew upgrade to get the latest 9.4 version of PostgreSQL.
After upgrading PG from 9.3 to 9.4 with brew, the server will not start as is. If you value your database contents, and configuration, pg_upgrade is here to migrate those.
Do not delete the old binaries at once: do not run brew cleanup, because you need 9.3 binaries to migrate.
Migration


## Rakefile
require "active_record"

namespace :db do

  db_config       = YAML::load(File.open('config/database.yml'))
  db_config_admin = db_config.merge({'database' => 'postgres', 'schema_search_path' => 'public'})

  desc "Create the database"
  task :create do
    ActiveRecord::Base.establish_connection(db_config_admin)
	require "active_record"

	namespace :db do

	db_config = YAML::load(File.open('config/database.yml'))
	db_config_admin = db_config.merge({'database' => 'postgres', 'schema_search_path' => 'public'})

	desc "Create the database"
	task :create do
	ActiveRecord::Base.establish_connection(db_config_admin)