postgresql12安装（1）

下载地址

核心3个包按顺序安装

postgresql12-libs-12.6-1PGDG.rhel7.x86_64.rpm

postgresql12-12.6-1PGDG.rhel7.x86_64.rpm

postgresql12-server-12.6-1PGDG.rhel7.x86_64.rpm

https://yum.postgresql.org/12/redhat/rhel-7-x86_64/repoview/postgresqldbserver12.group.html

安装

rw-r--r--. 1 root root 1684252 Mar 22 23:22 postgresql12-12.6-1PGDG.rhel7.x86_64.rpm -rw-r--r--. 1 root root  625740 Mar 22 23:22 postgresql12-contrib-12.6-1PGDG.rhel7.x86_64.rpm -rw-r--r--. 1 root root  379296 Mar 22 23:22 postgresql12-libs-12.6-1PGDG.rhel7.x86_64.rpm -rw-r--r--. 1 root root 5306792 Mar 22 23:22 postgresql12-server-12.6-1PGDG.rhel7.x86_64.rpm [root@pg2 ~]# rpm -ivh postgresql12-libs-12.6-1PGDG.rhel7.x86_64.rpm warning: postgresql12-libs-12.6-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY Preparing...                          ################################# [100%] Updating / installing...    1:postgresql12-libs-12.6-1PGDG.rhel################################# [100%] [root@pg2 ~]# rpm -ivh postgresql12-12.6-1PGDG.rhel7.x86_64.rpm warning: postgresql12-12.6-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY Preparing...                          ################################# [100%] Updating / installing...    1:postgresql12-12.6-1PGDG.rhel7    ################################# [100%] [root@pg2 ~]# rpm -ivh postgresql12-server-12.6-1PGDG.rhel7.x86_64.rpm warning: postgresql12-server-12.6-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY Preparing...                          ################################# [100%] Updating / installing...    1:postgresql12-server-12.6-1PGDG.rh################################# [100%] [root@pg2 ~]#

初始化

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb

sudo systemctl enable postgresql-12

sudo systemctl start postgresql-12

PGHOME设置

PGDATA路径已给了

Vi .bash_profile

PGDATA=/var/lib/pgsql/12/data

PGHOME=/usr/pgsql-12

PATH=$PGHOME/bin:$PATH

export PGDATA

export PGHOME

export PATH