PostgreSQL 9.4.1 released, install on Ubuntu / Linux Mint via PPA

PostgreSQL 9.4.1 released, install on Ubuntu 14.10 Utopic Unicorn, Ubuntu 14.04 Trusty Tahr (LTS), Ubuntu 12.04 / Linux Mint 17.1 Rebecca, Linux Mint 17 Qiana via PPA

PostgreSQL is an open source, powerful, reliable, stable, enterprise-ready and free object-relational database system in the style of MariaDB, MySQL or SQLite projects. It’s an ACID (Atomicity, Consistency, Isolation, Durability) compliant database server/engine that can be highly customized and includes numerous attractive features, making a great replacement for the aforementioned database engines.

What's new in PostgreSQL 9.4.1:

• These new releases contain security and bug fixes over previous releases. All users should plan upgrade their systems as soon as possible.

Features at a glance

Key features include support for foreign keys, views, joins, triggers and stored procedures, support for multiple languages, support for a wide range of SQL data types, including BOOLEAN, CHAR, INTEGER, NUMERIC, VARCHAR, INTERVAL, TIMESTAMP and DATE.

In addition, the software comes with support for storaging binary large objects, including all sorts of multimedia files (video, audio and photo), and provides developers with native programming interfaces for the C, C++, Python, Perl, Ruby, Java, .Net, Tcl and ODBC programming languages.

Among other interesting features, we can mention MVCC (Multi-Version Concurrency Control), tablespaces, multibyte character encodings, point in time recovery, a mature query optimizer and planner, asynchronous replication, online backups, nested transactions (popularly known as savepoints), hot backups, write ahead logging for fault tolerance, support for international character sets, as well as Unicode support.

 

Install PostgreSQL 9.4.1 on Ubuntu / Linux Mint via PPA :

PostgreSQL 9.4.1 available on PPA Launcphad, you can install on Ubuntu 14.10 Utopic Unicorn, Ubuntu 14.04 Trusty Tahr (LTS), Ubuntu 12.04 / Linux Mint 17.1 Rebecca, Linux Mint 17 Qiana via PPA, open a new Terminal window and bash (get it?) in the following commands: 

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install postgresql-9.4

for more information about installation on ubuntu derivative system you can follow this page.