Install PostgreSQL 11 on Ubuntu 18.04 / Ubuntu 16.04

This short guide will help you to Install PostgreSQL 11 on Ubuntu 18.04 / Ubuntu 16.04. PostgreSQL Server is a robust open source and highly-extensible database server. PostgreSQL provides object-relational database system allowing you to manage extensive SQL datasets.

Key PostgreSQL 11 Enhancements:

Improvements to partitioning functionality

SQL stored procedures that support embedded transactions

Improvements to parallelism

Window functions now support all framing options shown in the SQL:2011 standard