Max Tolkachev zhrivodkin

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

  
## PG::Error: ERROR: new encoding (UTF8) is incompatible
======= Prolbem =================================================================================================================
I have installed : ruby-2.0.0,postgres-9.2 , now in rails app when I execute:

      rake db:create , command I get:

PG::InvalidParameterValue: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use template0 as template.
: CREATE DATABASE "my_db_name" ENCODING = 'unicode'.......

      bin/rake:16:in `load'

## es.sh
cd ~
sudo apt-get update
sudo apt-get install openjdk-7-jre -y

wget https://github.com/downloads/elasticsearch/elasticsearch/elasticsearch-0.19.11.tar.gz -O elasticsearch.tar.gz
tar -xf elasticsearch.tar.gz
rm elasticsearch.tar.gz
sudo mv elasticsearch-* elasticsearch
sudo mv elasticsearch /usr/local/share
	======= Prolbem =================================================================================================================
	I have installed : ruby-2.0.0,postgres-9.2 , now in rails app when I execute:

	rake db:create , command I get:

	PG::InvalidParameterValue: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
	HINT: Use the same encoding as in the template database, or use template0 as template.
	: CREATE DATABASE "my_db_name" ENCODING = 'unicode'.......

	bin/rake:16:in `load'
	cd ~
	sudo apt-get update
	sudo apt-get install openjdk-7-jre -y

	wget https://github.com/downloads/elasticsearch/elasticsearch/elasticsearch-0.19.11.tar.gz -O elasticsearch.tar.gz
	tar -xf elasticsearch.tar.gz
	rm elasticsearch.tar.gz
	sudo mv elasticsearch-* elasticsearch
	sudo mv elasticsearch /usr/local/share