Home

Database setup

Step 1: Create a new username and password for postgresql

Note: You need to have postgresql installed in your system if you are not using Cloud9

First, you have to start the postgresql server and log into the psql server console.

$ sudo service postgresql start
$ sudo sudo -u postgres psql

Then, create a user in the server with default username and password. Exit the server.

postgres=# CREATE USER username SUPERUSER PASSWORD 'password';
postgres=# \q

Step 2: Create the Environment variables in your local system

In your terminal / console, type the following command:

$ echo "export USERNAME=username" >> ~/.profile
$ echo "export PASSWORD=password" >> ~/.profile
$ source ~/.profile