Skip to content

Instantly share code, notes, and snippets.

View gouvermxt's full-sized avatar
:electron:

Marcio Gouvea Silva gouvermxt

:electron:
8 followers · 6 following
View GitHub Profile
@gouvermxt
gouvermxt / postgres-brew.md
Created June 4, 2019 15:26 — forked from ibraheem4/postgres-brew.md
Installing Postgres via Brew (OSX)

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

  1. brew doctor
  2. brew update
@gouvermxt
gouvermxt / PG::Error: ERROR: new encoding (UTF8) is incompatible
Created August 3, 2017 22:37 — forked from amolkhanorkar/PG::Error: ERROR: new encoding (UTF8) is incompatible
Postgres 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'
@gouvermxt
gouvermxt / cloud9-postgresql-rails-howto.md
Created August 3, 2017 22:23 — forked from eliotsykes/cloud9-postgresql-rails-howto.md
How to setup PostgreSQL & Rails on Cloud9

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