sonarqube-8.9.6 要求必须是PostgreSQL9.6及以上版本。 PostgreSQL官网：https://www.postgresql.org/download/linux/redhat/ **** **1. 安装PostgreSQL 12** ```shell (1)安装存储库RPM文件 sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm (2)安装安装PostgreSQL sudo yum install -y postgresql12-server (3)验证是否安装成功 # rpm -aq | grep postgres postgresql12-libs-12.9-1PGDG.rhel7.x86_64 postgresql12-12.9-1PGDG.rhel7.x86_64 postgresql12-server-12.9-1PGDG.rhel7.x86_64 (4)初始化数据库 /usr/pgsql-12/bin/postgresql-12-setup initdb (5)设置开机自启动，并启动PostgreSQL服务 # systemctl enable postgresql-12 # systemctl start postgresql-12 # systemctl status postgresql-12 ● postgresql-12.service - PostgreSQL 12 database server Loaded: loaded (/usr/lib/systemd/system/postgresql-12.service; enabled; vendor preset: disabled) Active: active (running) ``` **2. 配置防火墙** ```shell --查询5432端口是否开放 # firewall-cmd --query-port=5432/tcp no --开放5432端口（5432为PostgreSQL默认端口） # firewall-cmd --zone=public --add-port=5432/tcp --permanent # firewall-cmd --reload # firewall-cmd --query-port=5432/tcp yes ``` **3. 初始化用户名和密码** ```shell (1)切换到用户postgres，初始化postgresql数据库时默认自动创建postgres用户 --postgresql数据库不能以root用户登录 # su - postgres -bash-4.2$ (2)登录数据库 -bash-4.2$ psql -U postgres psql (12.9) Type "help" for help. postgres=# (3)设置密码，设置postgres用户密码为postgres postgres=# ALTER USER postgres WITH PASSWORD 'postgres'; (4)退出数据库 postgres=# \q -bash-4.2$ exit ``` **4. 修改配置文件，配置远程访问** ```shell cd /var/lib/pgsql/12/data # vim postgresql.conf listen_addresses = '*' # vim pg_hba.conf # IPv4 local connections: host all all 127.0.0.1/32 ident host all all 0.0.0.0/0 md5 # IPv6 local connections: host all all ::1/128 ident host all all 0.0.0.0/0 md5 ``` **5. 切换到`root`用户，重启数据库** ```shell # systemctl restart postgresql-12 # systemctl status postgresql-12 ● postgresql-12.service - PostgreSQL 12 database server Loaded: loaded (/usr/lib/systemd/system/postgresql-12.service; enabled; vendor preset: disabled) Active: active (running) ``` **6. 可以用Navicat Premium连接测试看是否可以进行远程连接了**