Upgrading to PostgreSQL 9.5 in Fedora 24

PostgreSQL, often simply Postgres, is an object-relational database (ORDBMS) – i.e. a RDBMS, with additional (optional use) "object" features – with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, and to allow for retrieval at the request of other software applications. 

It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS, PostgreSQL is the default database – for web hosting – and it is also available for Microsoft Windows and Linux (supplied in most distributions).

• How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22

What’s new in PostgreSQL 9.5

• IMPORT FOREIGN SCHEMA
• Row-Level Security Policies
• BRIN Indexes
• Foreign Table Inheritance
• GROUPING SETS, CUBE and ROLLUP
• JSONB-modifying operators and functions
• INSERT … ON CONFLICT DO NOTHING/UPDATE (“UPSERT”)
• pg_rewind

And a lot of other things, which you can find in detail in the PosgreSQL Wiki.

Here, we’ll care just about upgrading from 9.4 to 9.5 Fedora 24.

This is just an (important) advice: before proceeding in upgrading, back-up all your data.

The procedure for upgrading PostgreSQL is not automatic, so you have to make some operation manually, but, as you will see, it’s very easy.

Let’s upgrade

First of all, install the upgrade sub-package:

$ sudo dnf install postgresql-upgrade

Now, you can use it to upgrade PostgreSQL:

$ sudo postgresql-setup --upgrade

At the end of the procedure, look at /var/lib/pgsql/upgrade_postgresql.log log file for useful details, and then start the systemd service:

$ sudo systemctl start postgresql.service

Now, if you:

$ sudo systemctl status postgresql.service

you should see it started and ready.

That’s all, your PostgreSQL is at 9.5 version, with all its new features available.

HackTh3Sec