PS:不同系统安装不同postgresql版本,参考PostgreSQL: Downloads
1.编辑安装postgresql脚本
# vim install_postgresql.sh
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum install -y postgresql12-server
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12
2.运行安装postgresql脚本
# bash install_postgresql.sh
...
已安装:
postgresql12-server.x86_64 0:12.15-1PGDG.rhel7
作为依赖被安装:
postgresql12.x86_64 0:12.15-1PGDG.rhel7 postgresql12-libs.x86_64 0:12.15-1PGDG.rhel7
完毕!
Initializing database ... OK
3.验证postgresql 5432端口是否打开
# ss -ntl|grep 5432
LISTEN 0 128 127.0.0.1:5432 *:*
LISTEN 0 128 [::1]:5432 [::]:*
4.运行命令postgresql查看版本
# sudo -u postgres psql -c "SELECT version();"
could not change directory to "/root": 权限不够
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 12.15 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)
5.切换postgres用户,运行psql工具
# su - postgres
# psql
psql (12.15)
输入 "help" 来获取帮助信息.
postgres=#