CentOS 7安装指定版本的数据库postgresql

怼烎@ 2022-05-18 06:47 173阅读 0赞

安装指定版本的数据库postgresql（centos7.4）

网上搜索Linux安装postgresql有很多教程，主要是下载rpm包在线安装：

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

但是使用此方法安装数据库现在最新版已是postgresql10.4的版本，而环境需要指定安装10.3的版本，因此可选择解压版安装。

首先下载压缩包：[https://www.postgresql.org/ftp/source/v10.3/][https_www.postgresql.org_ftp_source_v10.3]，选择 [postgresql-10.3.tar.gz][]下载

![70][]

上传到/usr/data/postgresql10.3/ ,解压

tar -zxvf postgresql-10.3.tar.gz

进入postgresql10.3目录输入命令检查环境

./configure

如果出现以下错误

configure: error: in `/root/postgresql-10.3':
    configure: error: no acceptable C compiler found in $PATH
    
    See `config.log' for more details

缺少编译环境，执行命令，安装对应的包

yum –y install gcc

成功之后再次输入

./configure

又报错

configure: error: readline library not found
    If you have readline already installed, see config.log for details on the
    failure.  It is possible the compiler isn't looking in the proper directory.
    
    Use --without-readline to disable readline support.

安装readline support

yum -y install -y readline-devel

成功之后再次输入

./configure

再次报错

configure: error: zlib library not found
    If you have zlib already installed, see config.log for details on the
    failure.  It is possible the compiler isn't looking in the proper directory.
    
    Use --without-zlib to disable zlib support.

安装zlib-devel

yum -y install zlib-devel

终于不再报错，总之缺少什么就安装什么

执行编译

make && make install

需要大概10分钟，出现如下信息则编译成功

![70 1][]

以上内容参考：[https://blog.csdn.net/qq\_35267557/article/details/79788703][https_blog.csdn.net_qq_35267557_article_details_79788703]

接下来添加用户

![70 2][]

创建一个data文件夹用于存储数据

mkdir /usr/local/pgsql/data
    chown postgres /usr/local/pgsql/data  
    chmod 700 /usr/local/pgsql/data

切换用户为postgresql并初始化数据库

su postgres
    /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

![70 3][]

到bin目录下

cd /usr/local/pgsql/bin/

启动数据库

su postgres
    ./pg_ctl start  -D /usr/local/pgsql/data/

![70 4][]

查看下状态

./pg_ctl status  -D /usr/local/pgsql/data/

![70 5][]

接下来修改下配置文件，便于远程连接

cd /usr/local/pgsql/data/

vim pg_hba.conf

![70 6][]

vim postgresql.conf

![70 7][]

重启数据库

su postgres
    ./pg_ctl restart  -D /usr/local/pgsql/data/

即可远程连接啦！

[https_www.postgresql.org_ftp_source_v10.3]: https://www.postgresql.org/ftp/source/v10.3/
[postgresql-10.3.tar.gz]: https://ftp.postgresql.org/pub/source/v10.3/postgresql-10.3.tar.gz
[70]: /images/20220518/0b01a9971edc44db9ec19dd28ca936e5.png
[70 1]: /images/20220518/574b6e3d5f1846b890d46728630530ef.png
[https_blog.csdn.net_qq_35267557_article_details_79788703]: https://blog.csdn.net/qq_35267557/article/details/79788703
[70 2]: /images/20220518/cec88fb6384541c5857c1d01dab199b5.png
[70 3]: /images/20220518/a66349c891fc4f689898d62ce1924d87.png
[70 4]: /images/20220518/d77c6d5e1396495abb8c4ec9175f9874.png
[70 5]: /images/20220518/e179bd24e7754201a21bbcde7eec263d.png
[70 6]: /images/20220518/452fa768dd9441b59ad15526dd0a52cc.png
[70 7]: /images/20220518/e9acc7fa46254cf8ad1a67a37177b606.png