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連接測試看是否可以進行遠程連接了**