Marcio Gouvea Silva gouvermxt

Installing Postgres via Brew

Pre-Reqs

In your command-line run the following commands:

brew doctor
brew update

How to setup PostgreSQL & Rails on Cloud9

At time of writing, Cloud9 has PostgreSQL pre-installed, so you won't need to install it yourself. However, its not running by default, so you will need to start it with this command in the terminal:

sudo service postgresql start

Change the PostgreSQL password to 'password' (or choose a different password):

	======= 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'