PostgreSQL: All Great Structures Deserve a Strong Foundation

PostgreSQL Installation:

Server OS: Version:

> sudo apt-get update

> sudo add-apt-repository "deb https://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"

> wget --quiet -O - https://postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

> sudo apt-get update

> sudo apt-get install postgresql-9.5

Why PostgreSQL?

PostgreSQL is an excellent free database that offers world class relational and object data storage.

Great Schema Free Object Support

PostgreSQL offers the jsonb type which allows storage of JSON data with no pre-defined schema.

Read More

Great Relational Performance

PostgreSQL offers exceptional performance with highly related data which rival higher priced alternatives such as Microsoft SQL and Oracle.

Read More

Bomb

Inventore dolores aut laboriosam cum consequuntur delectus sequi lorem ipsum dolor sit amet, consectetur.

Read More

After the install, there will only be one user(postgres). Let's run the following commands to add another user that matches are Linux Username to make life easier

sudo -u postgres psql

postgres=> alter user postgres password 'apassword';

postgres=> create user yerusername createdb password 'somepass';

postgres=> create database yerusername owner yerusername;

postgres=> \q


now as your regular user 'yerusername' you can connect to postgres, and have the privileges to create new users and databases.

Now, you can simply use the psql command to access the PostgreSQL command shell