如何在 CentOS 7 上安裝postgresql用的GUI工具 pgAdmin4

Step 1: 新增 pgAdmin 4 repository

# yum install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-2-1.noarch.rpm

Step 2: 安裝 pgAdmin4

# yum install pgadmin4

Step 3: Configure pgAdmin 4 for apache

安裝時，如果是使用 apache 的...會直接幫你設定好，設定檔放在 /etc/httpd/conf.d/pgadmin4.conf

# /usr/pgadmin4/bin/setup-web.sh

QUOTE:

Setting up pgAdmin 4 in web mode on a Redhat based platform...
Creating configuration database...
NOTE: Configuring authentication for SERVER mode.

Enter the email address and password to use for the initial pgAdmin user account:

Email address: <input-email-address>
Password: <input-password>
Retype password: <Reenter-password>
pgAdmin 4 - Application Initialisation
======================================

Creating storage and log directories...

Agree for the configuration of Apache Web server.

QUOTE:

Configuring SELinux...
The Apache web server is not running. We can enable and start the web server for you to finish pgAdmin 4 installation. Continue (y/n)? y
Created symlink /etc/systemd/system/multi-user.target.wants/httpd.service → /usr/lib/systemd/system/httpd.service.
Apache successfully enabled.
Apache successfully started.
You can now start using pgAdmin 4 in web mode at http://127.0.0.1/pgadmin4

最後打開
http://[serverip_or_hostname]/pgadmin4

輸入剛剛設定的帳號密碼,就可以登入囉