CentOS安装PostgreSQL
<p>版本信息：</p><p> CentOS版本：CentOS-7-x86_64-Minimal-1810</p>
<p> PostgreSQL版本： PostgreSQL 10.10, 64-bit</p>
<p> </p>
<p><span style="color: rgba(0, 0, 255, 1)"><strong>第一部分：PostgresSQL的安装</strong></span></p>
<p>1、安装rpm文件</p>
<div class="cnblogs_code">
<pre>yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm</pre>
</div>
<p>2、安装客户端</p>
<div class="cnblogs_code">
<pre>yum install postgresql10</pre>
</div>
<p>3、安装服务端</p>
<div class="cnblogs_code">
<pre>yum install postgresql10-server</pre>
</div>
<p>4、初始化</p>
<div class="cnblogs_code">
<pre>/usr/pgsql-10/bin/postgresql-10-setup initdb</pre>
</div>
<p>5、设置自动启动并且启动postgresql服务</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">systemctl enable postgresql-10
systemctl start postgresql-10</span></pre>
</div>
<p>postgresql的安装比较简单，官网上有明确的操作步骤</p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829210825015-1979605442.png"></p>
<p> </p>
<p><span style="color: rgba(0, 0, 255, 1)"><strong>第二部分：创建用户和数据库</strong></span></p>
<p>1、使用postgres用户登录（PostgresSQL安装后会自动创建postgres用户，无密码）</p>
<div class="cnblogs_code">
<pre>su - postgres</pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829211350173-1221292938.png"></p>
<p>2、登录postgresql数据库</p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829211540206-215103639.png"></p>
<p>3、创建用户和数据库并授权</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">create user test_user with password 'abc123'; // 创建用户
create database test_db owner test_user; // 创建数据库
grant all privileges on database test_db to test_user; // 授权</span></pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829211826792-543737710.png"></p>
<p>4、退出psql（输入 \q 再按回车键即可）</p>
<div class="cnblogs_code">
<pre>\q</pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829212411391-312823789.png"></p>
<p> </p>
<p><strong><span style="color: rgba(0, 0, 255, 1)">第三部分：开启远程访问</span></strong></p>
<p>1、修改/var/lib/pgsql/10/data/postgresql.conf文件，取消 listen_addresses 的注释，将参数值改为“*”</p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829213313257-1228645678.png"></p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829213530702-1254443859.png"></p>
<p> 2、修改/var/lib/pgsql/10/data/pg_hba.conf文件，增加下图红框部分内容</p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829213842831-1355465913.png"></p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829213808483-468067164.png"></p>
<p>3、切换到root用户，重启postgresql服务</p>
<div class="cnblogs_code">
<pre>systemctl restart postgresql-10.service</pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829214304345-649880858.png"></p>
<p>4、使用数据库连接工具测试连接</p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829214402149-100192136.png"></p>
<p> </p>
<p> <img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829214434052-1172680179.png"></p>
<p><strong><span style="color: rgba(0, 0, 255, 1)">第四部分：额外补充</span></strong></p>
<p>1、修改默认生成的 postgres 用户密码（此postgres非上面的postgres用户，此为数据库的用户，上面的为操作系统的用户）</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">su - postgres<br>psql -U postgres
alter user postgres with encrypted password '1';</span></pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829215622192-1673870049.png"></p>
<p> </p>
<p><img src="https://img2018.cnblogs.com/blog/1031555/201908/1031555-20190829215948137-1238814146.png"></p>
<p>2、服务启动、关闭、重启、查看状态命令</p>
<div class="cnblogs_code">
<pre>systemctl start postgresql-<span style="color: rgba(128, 0, 128, 1)">10</span>.service <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 启动服务</span>
systemctl stop postgresql-<span style="color: rgba(128, 0, 128, 1)">10</span>.service <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 关闭服务</span>
systemctl restart postgresql-<span style="color: rgba(128, 0, 128, 1)">10</span>.service <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 重启服务</span>
systemctl status postgresql-<span style="color: rgba(128, 0, 128, 1)">10</span>.service <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 查看状态</span></pre>
</div>
<p> </p><br><br>
来源：https://www.cnblogs.com/zhi-leaf/p/11432054.html
頁:
[1]