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 ...