Hack The Sec-Leading Resource Of Linux Tutorial: RDBMS

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; color: #1e73be; font-family: Cabin; font-size: 40px; font-weight: 400; line-height: 50px; margin: 0px 0px 7px; word-wrap: break-word;">
<u>Upgrading to PostgreSQL 9.5 in Fedora 24</u></h1>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL</a>, 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,</span></span><span style="color: #333333; font-family: "Open Sans"; font-size: 14px;"> its primary function is to store data securely, and to allow for retrieval at the request of other software applications. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Xna_IIkerhQ/WBx0-w1q7TI/AAAAAAAABp8/gGU5LnGts_shc5VOhvKzZbF-Uh9GqZJSQCLcB/s1600/postgreSQL_hackthesec.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-Xna_IIkerhQ/WBx0-w1q7TI/AAAAAAAABp8/gGU5LnGts_shc5VOhvKzZbF-Uh9GqZJSQCLcB/s1600/postgreSQL_hackthesec.gif" /></a></div>
<div>
<span style="color: #333333; font-family: "Open Sans"; font-size: 14px;"><br /></span></div>
<div>
<span style="color: #333333; font-family: "Open Sans"; font-size: 14px;">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 <a href="http://www.hackthesec.co.in/search/label/Linux%20Tutorial">Linux </a>(supplied in most distributions).</span></div>
<div>
<a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="background-color: white; display: block; font-family: "Open Sans", serif, sans-serif; font-weight: 600; text-decoration: none;"></a><ul style="text-align: left;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="background-color: white; display: block; font-family: "Open Sans", serif, sans-serif; font-weight: 600; text-decoration: none;"></a>
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="background-color: white; display: block; font-family: "Open Sans", serif, sans-serif; font-weight: 600; text-decoration: none;"></a><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="display: inline !important; text-decoration: none;"><span style="color: red;">How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22</span></a></li>
</ul>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">What’s new in PostgreSQL 9.5</span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><div>
<ul style="font-size: 14px; text-align: left;">
<li>IMPORT FOREIGN SCHEMA</li>
<li>Row-Level Security Policies</li>
<li>BRIN Indexes</li>
<li>Foreign Table Inheritance</li>
<li>GROUPING SETS, CUBE and ROLLUP</li>
<li>JSONB-modifying operators and functions</li>
<li>INSERT … ON CONFLICT DO NOTHING/UPDATE (“UPSERT”)</li>
<li>pg_rewind</li>
</ul>
<div>
<div>
<span style="font-size: 14px;">And a lot of other things, which you can find in detail in the <a href="https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5"><b>PosgreSQL Wik</b>i</a>.</span></div>
<div>
<span style="font-size: 14px;"><br /></span></div>
<div>
<span style="font-size: 14px;">Here, we’ll care just about upgrading from 9.4 to 9.5 Fedora 24.</span></div>
</div>
</div>
<div>
<span style="font-size: 14px;"><br /></span></div>
</span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
<b><span style="color: red;">This is just an (important) advice: before proceeding in upgrading, back-up all your data.</span></b></div>
<div>
<b><span style="color: red;"><br /></span></b></div>
<div style="color: #333333;">
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.</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<div style="color: #333333; font-family: "Open Sans"; font-size: 14px;">
<b><u>Let’s upgrade</u></b></div>
<div style="color: #333333; font-family: "Open Sans"; font-size: 14px;">
First of all, install the upgrade sub-package:</div>
<div>
<div style="background-color: white; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; display: block; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;"><span style="color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 15px;">$ sudo dnf install postgresql-upgrade</span></span></span></div>
</div>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">Now, you can use it to upgrade PostgreSQL:</span></span></div>
<div>
<div style="background-color: white; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; color: white; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 15px; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;">$ sudo postgresql-setup --upgrade</span><div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">At the end of the procedure, look at <b>/var/lib/pgsql/upgrade_postgresql.log</b> log file for useful details, and then start the systemd service:</span></span></div>
</div>
</div>
<div>
<div style="background-color: white; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; color: white; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 15px; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;">$ sudo systemctl start postgresql.service</span><div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">Now, if you:</span></span></div>
<div>
<div style="color: #333333; font-family: "Open Sans"; font-size: 14px; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; color: white; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 15px; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;">$ sudo systemctl status postgresql.service</span></div>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">you should see it started and ready.</span></span></div>
</div>
</div>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">That’s all, your PostgreSQL is at 9.5 version, with all its new features available.</span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><a href="http://www.hackthesec.co.in/">HackTh3Sec</a></span></span></div>
</div>

Upgrading to PostgreSQL 9.5 in Fedora 24

Upgrading to PostgreSQL 9.5 in Fedora 24 PostgreSQL , often simply Postgres, is an object-relational database (ORDBMS) – i.e. a RDBMS, w...