O'Reilly logo

Continuous Integration, Delivery, and Deployment by Sander Rossel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required