database.html

<h1>
<!-- Blog title -->
Relational Database</h1>
<h3>
<!-- Tagline -->
Postgress 9.5.2 installation in redhat 6.6</h3>
<div id="bannerImage"></div>
    <p><font color="#00a48c">Step 1:</font> Add rpm image of postgress in to rpm repository with the command</p>
<div id="code">rpm -Uvh http://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/pgdg-redhat95-9.5-2.noarch.rpm </div>
    <p><font color="#00a48c">Step 2:</font> Type in <em>yum install postgresql95-server </em></p>
<p>If the above command throws <a href="https://en.wikipedia.org/wiki/HTTP_404">404 exception</a>, edit the base url in the below file to a working url </p>
<div id="code">vim /etc/yum.repos.d/pgdg-95-redhat.repo</div></p>
    <div id="code">baseurl=https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.6-$basearch </div></p>
<p><font color="#00a48c">Step 3:</font> Initialize the database with the command: <em>service postgresql-9.5 initdb</em></p>
<p><font color="#00a48c">Step 4:</font> Start postgress with the command:&nbsp;<em>service postgresql-9.5 start</em></p>
<p>At this point, if you type <em>su - postgres</em> you will get a bash console, in there type in <em>psql </em></p>
<p>Thats it, you are good to go.</p>

<div id="logo2">
    <p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><!-- Company Logo text -->
</p>
<p>&nbsp;</p>
</div>