Yadda ake Sanya pgAdmin4 a cikin CentOS 7

PgAdmin4 abu ne mai sauƙi don amfani da haɗin yanar gizo don sarrafa bayanan bayanan PostgreSQL. Ana iya amfani da shi akan dandamali da yawa kamar Linux, Windows da Mac OS X. A cikin pgAdmin 4 akwai ƙaura daga bootstrap 3 zuwa bootstrap 4.

A cikin wannan koyawa za mu shigar da pgAdmin 4 akan tsarin CentOS 7.

Lura: Wannan koyawa tana ɗauka cewa an riga an shigar da PostgreSQL 9.2 ko sama akan CentOS 7. Don umarnin yadda ake shigar da shi, zaku iya bin jagoranmu: Yadda ake shigar PostgreSQL 10 akan CentOS da Fedora.

Yadda ake Sanya pgAdmin 4 a cikin CentOS 7

Ya kamata a kammala wannan matakin akan shigarwa na PostgreSQL, amma idan ba ku yi ba, zaku iya kammala shi da:

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

Yanzu kun shirya don shigar da pgAdmin tare da:

# yum -y install pgadmin4

Yayin shigarwa, saboda abubuwan dogaro, za a shigar da waɗannan biyun kuma - pgadmin4-web da sabar gidan yanar gizo na httpd.

Yadda ake saita pgAdmin 4 a cikin CentOS 7

Akwai ƴan ƙananan canje-canjen sanyi waɗanda ake buƙatar yi don samun pgAdmin4 yana gudana. Da farko za mu sake suna samfurin conf fayil daga pgadmin4.conf.sample zuwa pgadmin4.conf:

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

Daidaita fayil ɗin don yayi kama da haka:

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

Na gaba za mu ƙirƙiri rajistan ayyukan rajista da kundayen adireshi na pgAdmin4 kuma mu saita mallakin su:

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

Sannan za mu iya tsawaita abubuwan da ke cikin config_distro.py.

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

Kuma ƙara wadannan layukan:

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'

A ƙarshe za mu ƙirƙiri asusun mai amfani da mu, wanda da shi za mu tantance a cikin mahallin yanar gizo. Don yin wannan, gudu:

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

Yanzu za ku iya samun dama ga uwar garken ku http://ip-address/pgadmin4 ko http://localhost/pgadmin4 don isa wurin haɗin pgAdmin4:

Idan kun karɓi kuskuren 403 yayin samun damar dubawar PgAdmin4, kuna buƙatar saita mahallin SELinux daidai akan fayilolin masu zuwa.

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

Don tantancewa, yi amfani da adireshin imel da kalmar wucewa da kuka yi amfani da su a baya. Da zarar an tabbatar, ya kamata ku ga haɗin pgAdmin4:

A farkon shigar ku, kuna buƙatar ƙara sabon uwar garken don sarrafa. Danna Ƙara Sabon Sabar Kuna buƙatar saita haɗin PostgresQL. A cikin shafin farko \General, shigar da saitunan masu zuwa:

Sunan – ba da sunan uwar garken da kake saitawa.
Comment - bar sharhi don ba da bayanin misalin.

Shafi na biyu \Haɗin kai shine mafi mahimmanci ɗaya, saboda dole ne ka shigar:

Mai watsa shiri - adireshin IP na misalin PostgreSQL.
Port – tsohowar tashar jiragen ruwa ita ce 5432.
Bayanai na Kulawa - wannan yakamata ya zama postgres.
Password – kalmar sirri don mai amfani na sama.

Lokacin da kuka cika komai, Ajiye canje-canje. Idan haɗin ya yi nasara, ya kamata ku ga shafi mai zuwa:

Wannan shi ne. Shigar da pgAdmin4 ɗinku ya cika kuma zaku iya fara sarrafa bayananku na PostgreSQL.