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).
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”)
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.
First of all, install the upgrade sub-package:
Now, you can use it to upgrade PostgreSQL:
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:
Now, if you:
you should see it started and ready.
That’s all, your PostgreSQL is at 9.5 version, with all its new features available.