install postgresql 10 on redhat linux 7 Redhat 安装 postgresql 10

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

---恢复内容开始---

1. install linux

2. 切换mirror

a. 备份原来的repo 文件， [root@localhost ~]# mv /etc/yum.repos.d/redhat.repo /etc/yum.repos.d/redhat.repo.backup

b. 查询本机的yum 版本：

[root@localhost ~]# rpm -qa|grep yum
yum-rhn-plugin-2.0.1-6.el7.noarch
yum-langpacks-0.4.2-7.el7.noarch
yum-metadata-parser-1.1.4-10.el7.x86_64
yum-3.4.3-150.el7.noarch
PackageKit-yum-1.0.7-6.el7.x86_64
yum-utils-1.1.31-40.el7.noarch

c. 卸载这些自带的

rpm -qa|grep yum|xargs rpm -e --nodeps

d. 下载

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/yum-rhn-plugin-2.0.1-10.el7.noarch.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/yum-langpacks-0.4.2-7.el7.noarch.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/yum-metadata-parser-1.1.4-10.el7.x86_64.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/yum-3.4.3-158.el7.centos.noarch.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/PackageKit-yum-1.1.5-1.el7.centos.x86_64.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/yum-utils-1.1.31-45.el7.noarch.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/python-urlgrabber-3.10-8.el7.noarch.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/rpm-4.11.3-32.el7.x86_64.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.31-45.el7.noarch.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/rpm-python-4.11.3-32.el7.x86_64.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/rpm-build-libs-4.11.3-32.el7.x86_64.rpm

wget https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/rpm-libs-4.11.3-32.el7.x86_64.rp --此刻我已经崩溃啦。。

7. 安装

一堆依赖，根据提示，去下载rpm包，

rpm -Uvh rpm-libs-4.11.3-32.el7.x86_64.rpm rpm-build-libs-4.11.3-32.el7.x86_64.rpm rpm-python-4.11.3-32.el7.x86_64.rpm rpm-4.11.3-32.el7.x86_64.rpm

rpm -ivh yum-metadata-parser-1.1.4-10.el7.x86_64.rpm

rpm -ivh yum-3.4.3-158.el7.centos.noarch.rpm yum-plugin-fastestmirror-1.1.31-45.el7.noarch.rpm

rpm -ivh yum-*

8.下载 repo 文件，修改参数

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo，

vim /etc/yum.repos.d/CentOS-Base.repo ,将文件里面的所有 $releasever 换成7，我手工一个一个改的，因为我的版本是 el7, 所以写成7

:1,$s/$releasever/7/g --命令模式，从第一行开始，把所有的$releasever 换成7

9. yum clean all -- 清除缓存

10. yum makecache --新建缓存，要是第八步里面 $releasever 没有换成7，就会报错，

11.Install the repository RPM -

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm 12. 修改pgdg-10-redhat.repo,该文件位于 /etc/yum.repos.d 将文件里面的 $releasever 换成7 :1,$s/$releasever/7/g
13.创建client

yum install postgresql10
14. install server --创建server

yum install postgresql10-server

15. 配置服务自动启动

/usr/pgsql-10/bin/postgresql-10-setup initdb
systemctl enable postgresql-10
systemctl start postgresql-1016. su - postgres - 切换用户
17. psql

-bash-4.2$ createuser bmf --创建用户，此处是在shell 不连接数据库

-bash-4.2$ createdb sqlexp --创建用户，此处是在shell 不连接数据库
-bash-4.2$ psql --进入postgresql
psql (10.4)
Type "help" for help.

postgres=# alter user bmf with password 'sqlexp' --修改用户密码
postgres-# ;
ALTER ROLE

----------------配置远程连接------------

18. 修改配置文件 pg_hba.conf --记得先备份这个文件 mv /var/lib/pgsql/10/data/pg_hba.conf /var/lib/pgsql/10/data/pg_hba.conf.bak

directory: /var/lib/pgsql/10/data/pg_hba.conf, 我是直接打开文件，直接编辑，在IPV4下面加一行这个记录，然后保存

# TYPE DATABASE USER ADDRESS METHOD
host all all 0.0.0.0/0 MD5

19. 修改配置文件 postgresql.conf --记得备份，