Continuous Integration, Delivery, and Deployment

Installing PostgreSQL on Ubuntu

First, we need to install PostgreSQL and some popular extensions. Ubuntu has some pretty good documentation on how to install PostgreSQL (https://help.ubuntu.com/community/PostgreSQL):

sudo apt-get updatesudo apt-get install postgresql postgresql-contrib

The installation creates a default postgres user without a password. However, we are going to create our own user with admin rights:

sudo -u postgres createuser --superuser sasudo -u postgres psql\password sa\password\password\q

The sudo -u postgres command means we are going to execute the next command as the postgres user. The command --superuser sa command creates a user named sa (for system admin). The psql command puts us in the PostgreSQL terminal. This ...