CentOS7 PostgreSQL安装、配置、使用详解
<p><strong>CentOS7 PostgreSQL安装</strong></p>
<p>
Install</p>
<p>
安装</p>
<p>
使用yum安装</p>
<p>
<span>yum install http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm<br>
yum install postgresql94-server postgresql94-contrib</span></p>
<p>
<strong>设置开机启动</strong></p>
<p>
<span>systemctl enable postgresql-9.4.service<br>
systemctl start postgresql-9.4.service</span></p>
<p>
初始化数据库</p>
<p>
<span>/usr/pgsql-9.4/bin/postgresql94-setup initdb</span></p>
<p>
开启远程访问</p>
<p>
<span>/var/lib/pgsql/9.4/data/postgresql.conf</span></p>
<p>
<span>listen_addresses ='*'</span></p>
<p>
/var/lib/pgsql/9.4/data/pg_hba.conf</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_752286">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments"># IPv4 local connections:</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">host all all 127.0.0.1</code><code class="bash plain">/32</code> <code class="bash plain">trust</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">host all all 192.168.117.1</code><code class="bash plain">/32</code> <code class="bash plain">trust</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash comments"># IPv6 local connections:</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">host all all ::1</code><code class="bash plain">/128</code> <code class="bash plain">trust</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
修改用户密码</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_586045">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">su</code> <code class="bash plain">postgres</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">psql -U postgres</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">ALTER USER postgres WITH PASSWORD </code><code class="bash string">'P0stgres'</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">\q</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
防火墙</p>
<p>
新建文件/usr/lib/firewalld/services/postgres94.xml</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterxml" id="highlighter_529267">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="xml plain"><?</code><code class="xml keyword">xml</code> <code class="xml color1">version</code><code class="xml plain">=</code><code class="xml string">"1.0"</code> <code class="xml color1">encoding</code><code class="xml plain">=</code><code class="xml string">"utf-8"</code><code class="xml plain">?></code>
</div>
<div class="line number2 index1 alt1">
<code class="xml plain"><</code><code class="xml keyword">service</code><code class="xml plain">></code>
</div>
<div class="line number3 index2 alt2">
<code class="xml spaces"> </code><code class="xml plain"><</code><code class="xml keyword">short</code><code class="xml plain">>Postgres 9.4 Database service</</code><code class="xml keyword">short</code><code class="xml plain">></code>
</div>
<div class="line number4 index3 alt1">
<code class="xml spaces"> </code><code class="xml plain"><</code><code class="xml keyword">description</code><code class="xml plain">>Postgres</</code><code class="xml keyword">description</code><code class="xml plain">></code>
</div>
<div class="line number5 index4 alt2">
<code class="xml spaces"> </code><code class="xml plain"><</code><code class="xml color1">portprotocol</code><code class="xml plain">=</code><code class="xml string">"tcp"</code><code class="xml color1">port</code><code class="xml plain">=</code><code class="xml string">"5432"</code><code class="xml plain">/></code>
</div>
<div class="line number6 index5 alt1">
<code class="xml plain"></</code><code class="xml keyword">service</code><code class="xml plain">></code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
修改防火墙设定</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_712004">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">firewall-cmd --permanent --add-service=postgres94</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">firewall-cmd --reload</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！</p>
頁:
[1]