白云阳光 發表於 2020-3-2 18:04:00

Debian安装PostgreSQL

<h1>参考</h1>
<p><span style="color: rgba(0, 0, 255, 1)"><em>https://www.postgresql.org/download/linux/debian/</em></span></p>
<h1>安装</h1>
<p>文档中说了postgresql已经存在于debian的源中，直接通过</p>
<div class="cnblogs_code">
<pre>apt-get <span style="color: rgba(0, 0, 255, 1)">install</span> postgresql-<span style="color: rgba(128, 0, 128, 1)">11</span></pre>
</div>
<p>就可以安装</p>
<h1>配置</h1>
<p>安装完成后，postgresql，默认只能本地访问，需要修改配置</p>
<h2>编辑/etc/postgresql/11/main/pg_hba.conf</h2>
<p>把<br><br># IPv4 local connections:<br><span style="color: rgba(0, 0, 0, 1)">host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: rgba(255, 0, 0, 1)">127.0.0.1/32</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; md5<br><br>修改成<br><br>host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: rgba(255, 0, 0, 1)">0.0.0.0/0</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; md5<br><br>这个文档上面有介绍，0.0.0.0/0表示允许所有ip</span></p>
<h2><span style="color: rgba(0, 0, 0, 1)">编辑/etc/postgresql/11/main/postgresql.conf</span></h2>
<p><span style="color: rgba(0, 0, 0, 1)">把</span></p>
<p><span style="color: rgba(0, 0, 0, 1)">#------------------------------------------------------------------------------<br># CONNECTIONS AND AUTHENTICATION<br>#------------------------------------------------------------------------------<br><br># - Connection Settings -<br><br><span style="color: rgba(255, 0, 0, 1)"># listen_addresses = 'localhost'</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # what IP address(es) to listen on;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # comma-separated list of addresses;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # defaults to 'localhost'; use '*' for all<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # (change requires restart)<br>修改为<br></span></p>
<p><span style="color: rgba(255, 0, 0, 1)">listen_addresses = '*'</span></p>
<p><span style="color: rgba(0, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)">把注释去掉，改localhost为星号。文档已经说了，默认是监听本地，如果需要监听其他连接，改成星号(*)，表示监听所有，需要重启服务或系统</span></span></p>
<h2><span style="color: rgba(0, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)">增加数据库密码</span></span></h2>
<p><span style="color: rgba(0, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)">postgresql安装的时候没有要求输入密码，默认是空密码</span></span> </p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">#进入postgres默认用户
</span><span style="color: rgba(0, 0, 255, 1)">sudo</span> <span style="color: rgba(0, 0, 255, 1)">su</span> -<span style="color: rgba(0, 0, 0, 1)"> postgres

#进入数据库
psql

#修改密码
\password postgres</span></pre>
</div>
<p>&nbsp;</p>
<p>这样就可以正常访问postgresql数据库了</p>
<p>&nbsp;</p>

</div>
<div id="MySignature" role="contentinfo">
    <div id="MySignature" style="display: block; text-align: center">
        <h2>版权声明：本文版权归作者所有，如需转载，请标明出处</h2>
</div><br><br>
来源：https://www.cnblogs.com/studywithallofyou/p/12397107.html
頁: [1]
查看完整版本: Debian安装PostgreSQL