Otu esi etinye pgAdmin4 na CentOS 7

PgAdmin4 dị mfe iji webụsaịtị maka ijikwa ọdụ data PostgreSQL. Enwere ike iji ya n'ọtụtụ nyiwe dị ka Linux, Windows na Mac OS X. Na pgAdmin 4 enwere mbugharị site na bootstrap 3 gaa na bootstrap 4.

N'ime nkuzi a, anyị ga-etinye pgAdmin 4 na sistemụ CentOS 7.

Mara: Nkuzi a na-eche na ị tinyelarị PostgreSQL 9.2 ma ọ bụ karịa na CentOS 7 gị. Maka ntuziaka ka esi etinye ya, ị nwere ike soro ntuziaka anyị: Otu esi etinye PostgreSQL 10 na CentOS na Fedora.

Otu esi etinye pgAdmin 4 na CentOS 7

Ekwesịrị ịmechara usoro a na ntinye nke PostgreSQL, mana ọ bụrụ na i mebeghị, ị nwere ike iji:

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

Ugbu a ị dịla njikere iji wụnye pgAdmin na:

# yum -y install pgadmin4

N'oge echichi, n'ihi ịdabere na ya, a ga-etinyekwa abụọ ndị a - pgadmin4-web na sava weebụ httpd.

Otu esi ahazi pgAdmin 4 na CentOS 7

Enwere obere mgbanwe nhazi ole na ole achọrọ ka emee ka pgAdmin4 na-agba ọsọ. Nke mbụ, anyị ga-atụgharị aha faịlụ conf sample site na pgadmin4.conf.sample ka ọ bụrụ pgadmin4.conf:

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

Hazie faịlụ ahụ ka ọ dị ka nke a:

<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>

Ọzọ anyị ga-emepụta ndekọ na akwụkwọ ndekọ aha maka pgAdmin4 wee tọọ ikike ha:

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

Ma mgbe ahụ, anyị nwere ike ịgbatị ọdịnaya nke anyị config_distro.py.

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

Tinyekwa ahịrị ndị a:

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'

N'ikpeazụ, anyị ga-emepụta akaụntụ onye ọrụ anyị, nke anyị ga-eji nyochaa ya na interface weebụ. Iji mee nke a, gbaa ọsọ:

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

Ugbu a ị nwere ike ịnweta http://ip-address/pgadmin4 ma ọ bụ http://localhost/pgadmin4 iji ruo pgAdmin4 interface:

Ọ bụrụ na ịnweta njehie 403 mgbe ị na-enweta interface PgAdmin4, ịkwesịrị ịtọ ntọala SELinux ziri ezi na faịlụ ndị a.

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

Iji chọpụta, jiri adreesị ozi-e na paswọọdụ ị jirila mbụ. Ozugbo enwetara ya, ị ga-ahụ interface pgAdmin4:

Na nbanye mbụ gị, ị ga-achọ ịgbakwunye sava ọhụrụ iji jikwaa. Pịa na Tinye ọhụrụ nkesa Ị ga-mkpa ịhazi njikọ PostgresQL na nke mbụ taabụ \General, tinye ntọala ndị a:

Aha – nye aha nkesa ị na-ahazi.
Nkwupụta – hapụ okwu iji nye nkọwa nke ihe atụ.

Taabụ nke abụọ njikọ dị mkpa karịa, ebe ị ga-abanye:

Ọbịa – onye ọbịa/adreesị IP nke ihe atụ PostgreSQL.
Port – ọdụ ụgbọ mmiri bụ 5432.
nchekwa data nchekwa - nke a kwesịrị ịbụ postgres.
Aha njirimara – aha njirimara nke ga-ejikọ. Ị nwere ike iji onye ọrụ postgres.
Paswọọdụ – okwuntughe maka onye ọrụ dị n’elu.

Mgbe ịmechara ihe niile, Chekwa mgbanwe ndị ahụ. Ọ bụrụ na njikọ ahụ gara nke ọma, ị ga-ahụ ibe a:

Nke a bụ ya. Ntinye pgAdmin4 gị ezuola ma ị nwere ike ịmalite ijikwa nchekwa data PostgreSQL gị.