First we need to install PostgreSQL. You can do it in many ways, but in this example I’m using Homebrew: Creating a new PostgreSQL database For creating a new database we just need to run the createdb command: What are these options? –encoding: specifies the character encoding scheme to be used in this database. –locale: Sets the locale settings LC_COLLATE …