Bii o ṣe le Fi pgAdmin4 sori ẹrọ ni CentOS 7

PgAdmin4 jẹ irọrun lati lo wiwo wẹẹbu fun iṣakoso awọn apoti isura data PostgreSQL. O le ṣee lo lori awọn iru ẹrọ lọpọlọpọ bii Lainos, Windows ati Mac OS X. Ni pgAdmin 4 iṣilọ wa lati bootstrap 3 si bootstrap 4.

Ninu ẹkọ yii a yoo fi pgAdmin 4 sori ẹrọ lori eto CentOS 7 kan.

Akiyesi: Ikẹkọ yii dawọle pe o ti ni PostgreSQL 9.2 tabi loke ti fi sori ẹrọ lori CentOS 7. Fun awọn itọnisọna bi o ṣe le fi sii, o le tẹle itọsọna wa: Bii o ṣe le fi sori ẹrọ PostgreSQL 10 lori CentOS ati Fedora.

Bii o ṣe le Fi pgAdmin 4 sori ẹrọ ni CentOS 7

Igbese yii yẹ ki o ti pari lori fifi sori PostgreSQL, ṣugbọn ti o ko ba ṣe bẹ, o le pari rẹ pẹlu:

# yum -y install https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Bayi o ti ṣetan lati fi sori ẹrọ pgAdmin pẹlu:

# yum -y install pgadmin4

Lakoko fifi sori ẹrọ, nitori awọn igbẹkẹle, awọn meji wọnyi ni yoo fi sori ẹrọ daradara - pgadmin4-web ati olupin ayelujara httpd.

Bii o ṣe le Tunto pgAdmin 4 ni CentOS 7

Awọn ayipada iṣeto kekere diẹ wa ti o nilo lati ṣe lati ni pgAdmin4 ṣiṣẹ. Ni akọkọ a yoo fun lorukọ mii faili conf ayẹwo lati pgadmin4.conf.sample si pgadmin4.conf:

# mv /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf
# vi /etc/httpd/conf.d/pgadmin4.conf

Satunṣe faili naa ki o dabi eleyi:

<VirtualHost *:80>
LoadModule wsgi_module modules/mod_wsgi.so
WSGIDaemonProcess pgadmin processes=1 threads=25
WSGIScriptAlias /pgadmin4 /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.wsgi

<Directory /usr/lib/python2.7/site-packages/pgadmin4-web/>
        WSGIProcessGroup pgadmin
        WSGIApplicationGroup %{GLOBAL}
        <IfModule mod_authz_core.c>
                # Apache 2.4
                Require all granted
        </IfModule>
        <IfModule !mod_authz_core.c>
                # Apache 2.2
                Order Deny,Allow
                Deny from All
                Allow from 127.0.0.1
                Allow from ::1
        </IfModule>
</Directory>
</VirtualHost>

Nigbamii ti a yoo ṣẹda awọn akọọlẹ ati awọn ilana lib fun pgAdmin4 ati ṣeto ohun-ini wọn:

# mkdir -p /var/lib/pgadmin4/
# mkdir -p /var/log/pgadmin4/
# chown -R apache:apache /var/lib/pgadmin4
# chown -R apache:apache /var/log/pgadmin4

Ati lẹhinna a le faagun awọn akoonu ti config_distro.py wa.

# vi /usr/lib/python2.7/site-packages/pgadmin4-web/config_distro.py

Ati ṣafikun awọn ila wọnyi:

LOG_FILE = '/var/log/pgadmin4/pgadmin4.log'
SQLITE_PATH = '/var/lib/pgadmin4/pgadmin4.db'
SESSION_DB_PATH = '/var/lib/pgadmin4/sessions'
STORAGE_DIR = '/var/lib/pgadmin4/storage'

Lakotan a yoo ṣẹda akọọlẹ olumulo wa, pẹlu eyiti a yoo jẹrisi ni wiwo wẹẹbu. Lati ṣe eyi, ṣiṣe:

# python /usr/lib/python2.7/site-packages/pgadmin4-web/setup.py

Bayi o le wọle si olupin rẹ http:// ip-adirẹsi/pgadmin4 tabi http:// localhost/pgadmin4 lati de ọdọ wiwo pgAdmin4:

Ti o ba gba aṣiṣe 403 lakoko ti o wọle si wiwo PgAdmin4, o nilo lati ṣeto ọrọ SELinux ti o tọ lori awọn faili atẹle.

# chcon -t httpd_sys_rw_content_t /var/log/pgadmin4 -R
# chcon -t httpd_sys_rw_content_t /var/lib/pgadmin4 -R

Lati jẹrisi, lo adirẹsi imeeli ati ọrọ igbaniwọle ti o ti lo tẹlẹ. Lọgan ti o jẹri, o yẹ ki o wo wiwo pgAdmin4:

Ni iwọle akọkọ rẹ, iwọ yoo nilo lati ṣafikun olupin tuntun lati ṣakoso. Tẹ lori\"Ṣafikun Olupin Tuntun". Iwọ yoo nilo lati tunto asopọ PostgresQL. Ni taabu akọkọ\"Gbogbogbo", tẹ awọn eto wọnyi:

Orukọ - fun orukọ olupin ti o n ṣatunṣe.
Ọrọìwòye - fi asọye silẹ lati fun apejuwe apeere naa.

Taabu keji\"Asopọ" jẹ ọkan pataki diẹ sii, bi iwọ yoo ni lati tẹ:

Gbalejo - adirẹsi/adiresi IP ti apẹẹrẹ PostgreSQL.
Ibudo - ibudo aiyipada ni 5432.
Ibi ipamọ data itọju - eyi yẹ ki o jẹ postgres.
Orukọ olumulo - orukọ olumulo ti yoo sopọ. O le lo olumulo postgres.
Ọrọigbaniwọle - ọrọ igbaniwọle fun olumulo ti o wa loke.

Nigbati o ba ti kun ohun gbogbo, Fipamọ awọn ayipada. Ti asopọ naa ba ṣaṣeyọri, o yẹ ki o wo oju-iwe atẹle:

Eyi ni o. Fifi sori ẹrọ pgAdmin4 rẹ ti pari ati pe o le bẹrẹ ṣiṣakoso ibi ipamọ data PostgreSQL rẹ.