CentOS PostgreSQL 12 安装
<h3>操作系统: CentOS 7</h3><h3>数据库: PostgreSQL 12</h3>
<p><strong>一、yum安装postgresql12</strong></p>
<p>1、安装存储库rpm包</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">yum</span> <span style="color: rgba(0, 0, 255, 1)">install</span> https:<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm</span></pre>
</div>
<p>2、安装客户端软件包</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">yum</span> <span style="color: rgba(0, 0, 255, 1)">install</span> postgresql12</pre>
</div>
<p>3、安装服务端软件包（可选）</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">yum</span> <span style="color: rgba(0, 0, 255, 1)">install</span> postgresql12-server</pre>
</div>
<p>4、初始化数据库并启用自动启动</p>
<div class="cnblogs_code">
<pre>/usr/pgsql-<span style="color: rgba(128, 0, 128, 1)">12</span>/bin/postgresql-<span style="color: rgba(128, 0, 128, 1)">12</span>-<span style="color: rgba(0, 0, 0, 1)">setup initdb
systemctl enable postgresql</span>-<span style="color: rgba(128, 0, 128, 1)">12</span><span style="color: rgba(0, 0, 0, 1)">
systemctl start postgresql</span>-<span style="color: rgba(128, 0, 128, 1)">12</span></pre>
</div>
<p>5、配置防火墙</p>
<div class="cnblogs_code">
<pre>firewall-cmd --permanent --add-port=<span style="color: rgba(128, 0, 128, 1)">5432</span>/<span style="color: rgba(0, 0, 0, 1)">tcp
firewall</span>-cmd --permanent --add-port=<span style="color: rgba(128, 0, 128, 1)">80</span>/<span style="color: rgba(0, 0, 0, 1)">tcp
firewall</span>-cmd --reload</pre>
</div>
<p>6、修改用户密码</p>
<div class="cnblogs_code">
<pre>#切换用户，执行后提示符会变为 <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">-bash-4.2$</span><span style="color: rgba(128, 0, 0, 1)">'</span>
<span style="color: rgba(0, 0, 255, 1)">su</span> -<span style="color: rgba(0, 0, 0, 1)"> postgres
#登录数据库，执行后提示符变为 </span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">postgres=#</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">
psql </span>-<span style="color: rgba(0, 0, 0, 1)">U postgres
#设置postgres用户密码为postgres
ALTER USER postgres WITH PASSWORD </span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">postgres</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">
# 退出数据库
\q </span></pre>
</div>
<p>7、开启远程访问</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">vi</span> /var/lib/pgsql/<span style="color: rgba(128, 0, 128, 1)">12</span>/data/<span style="color: rgba(0, 0, 0, 1)">postgresql.conf<br>
修改#listen_addresses </span>= <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">localhost</span><span style="color: rgba(128, 0, 0, 1)">'</span>为listen_addresses=<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">*</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">
当然，此处‘</span>*’也可以改为任何你想开放的服务器IP</pre>
</div>
<p>8、信任远程连接</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">vi</span> /var/lib/pgsql/<span style="color: rgba(128, 0, 128, 1)">12</span>/data/<span style="color: rgba(0, 0, 0, 1)">pg_hba.conf<br>
修改如下内容，信任指定服务器连接
# IPv4 local connections:
host all all </span><span style="color: rgba(128, 0, 128, 1)">127.0</span>.<span style="color: rgba(128, 0, 128, 1)">0.1</span>/<span style="color: rgba(128, 0, 128, 1)">32</span><span style="color: rgba(0, 0, 0, 1)"> trust
host all all </span><span style="color: rgba(128, 0, 128, 1)">192.168</span>.<span style="color: rgba(128, 0, 128, 1)">1.1</span>/<span style="color: rgba(128, 0, 128, 1)">32</span>（需要连接的服务器IP）trust</pre>
</div>
<p>9、操作</p>
<p> 安装后的数据库data目录</p>
<div class="cnblogs_code">
<pre>/var/lib/pgsql/<span style="color: rgba(128, 0, 128, 1)">12</span>/data</pre>
</div>
<p> 客户端程序目录</p>
<div class="cnblogs_code">
<pre>/usr/pgsql-<span style="color: rgba(128, 0, 128, 1)">12</span>/bin</pre>
</div>
<p> 启动数据库</p>
<div class="cnblogs_code">
<pre>./pg_ctl -D /var/lib/pgsql/<span style="color: rgba(128, 0, 128, 1)">12</span>/data start 或者 systemctl start postgresql-<span style="color: rgba(128, 0, 128, 1)">12</span></pre>
</div>
<p> 查看服务是否启动</p>
<p><img src="https://img2020.cnblogs.com/blog/1696771/202005/1696771-20200530092210931-2075403554.png" alt=""></p>
<p> </p>
<p> </p>
<p> </p>
<p> 操作连接数据库</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">.</span>/psql -Upostgres -dpostgres</pre>
</div>
<p><img src="https://img2020.cnblogs.com/blog/1696771/202005/1696771-20200530093453761-1088496922.png" alt=""></p>
<p> </p><br><br>
来源：https://www.cnblogs.com/VicLiu/p/12990940.html
頁:
[1]