Otu esi etinye PostgreSQL na pgAdmin na RHEL 8
Pgadmin4 bụ ngwa ọrụ njikwa webụ mepere emepe maka ijikwa ọdụ data PostgreSQL. Ọ bụ ngwa weebụ dabeere na Python mepụtara site na iji flask framework na backend na HTML5, CSS3, na Bootstrap na frontend. Pgadmin4 bụ ndegharị nke Pgadmin 3 nke edere na C++ yana ụgbọ mmiri nwere atụmatụ ndị a ama ama:
- Mmetụta webụ mara mma ma megharịa ya nwere akara ngosi na paịlụ a na-egbu maramara.
- Nhazi webụ na-anabata nke ọma yana dashboard maka nleba anya ozugbo.
- Ngwaọrụ ajụjụ ajụjụ SQL dị ndụ nwere nkọwa syntax.
- Mkparịta ụka njikwa dị ike na akụrụngwa maka ọrụ nkịtị.
- Ndụmọdụ bara uru iji malite.
- Na ọtụtụ ihe ndị ọzọ.
N'isiokwu a, ị ga-amụta ka esi etinye PostgreSQL na pagAdmin4 na ọnọdụ nkesa na-agba ọsọ n'azụ webserver Apache site na iji modul WSGI na RHEL 8.
Wụnye PostgreSQL na RHEL 8
Nzọụkwụ mbụ na ịwụnye PgAdmin4 bụ ịwụnye ihe nkesa nchekwa data PostgreSQL. PostgreSQL dị na ebe nchekwa Appstream na ụdị dị iche iche. Ị nwere ike ịme nhọrọ gị site n'ịkwalite ngwugwu ọkacha mmasị gị site na iji njikwa ngwugwu dnf.
Ka ịdepụta modul dị maka PostgreSQL, mee iwu:
# dnf module list postgresql
Ihe mmepụta ahụ na-egosi na e nwere ụdị 3 dị maka nbudata na ebe nchekwa AppStream: ụdị 9.6, 10, na 12. Anyị nwekwara ike ịhụ na ụdị ndabara bụ Postgresql 10 dị ka akara [d] gosipụtara. . Nke a bụ ihe ị ga-arụnye site na-agba ọsọ iwu n'okpuru.
# dnf install postgresql-server
Otú ọ dị, anyị chọrọ ịwụnye ụdị kachasị ọhụrụ, nke bụ PostgreSQL 12. Ya mere, anyị ga-eme ka modul ahụ ma kpochapụ iyi modul ndabara. Iji mee nke a, gbanye iwu:
# dnf module enable postgresql:12
Ozugbo ịmechara modul maka Postgresql 12, gaba n'ihu ma wụnye Postgresql 12 n'akụkụ ndabere ya dịka egosiri.
# dnf install postgresql-server
Tupu ihe ọ bụla ọzọ, ịkwesịrị ịmepụta ụyọkọ nchekwa data. Otu ụyọkọ nwere nchịkọta ọdụ data nke ihe nkesa na-ejikwa. Iji mepụta ụyọkọ nchekwa data, kpọọ iwu a:
# postgresql-setup --initdb
Ọ bụrụ na ihe niile gara nke ọma, ị ga-enweta nsonaazụ n'okpuru.
Ozugbo emepụtara ụyọkọ ahụ, ị nwere ike ịmalite ugbu a wee mee ka ihe atụ PostgreSQL gị dị ka egosiri:
# systemctl start postgresql # systemctl enable postgresql
Iji gosi na Postgresql na-arụ ọrụ, mebie:
# systemctl status postgresql
Ịwụnye Pgadmin4 na RHEL 8
Iji wụnye Pgadmin4, nke mbụ, tinye ebe nchekwa mpụga egosiri n'okpuru.
# rpm -i https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm
Na-esote, gbaa iwu dị n'okpuru ka ịwụnye pgadmin4 na ọnọdụ nkesa.
# dnf install pgadmin4-web
Na-esote, wụnye ngwugwu policycoreutils nke na-enye ihe ndị bụ isi nke SELinux chọrọ.
$ sudo dnf install policycoreutils-python-utils
Ozugbo etinyere ya, gbaa script ntọlite Pgadmin4 dị ka egosiri. Nke a ga-emepụta akaụntụ onye ọrụ pgadmin, nchekwa na ndekọ ndekọ aha, hazie SELinux wee tụgharịa sava weebụ Apache nke pgAdmin4 ga-arụ ọrụ.
# /usr/pgadmin4/bin/setup-web.sh
Mgbe kpaliri, nye ozi achọrọ wee kụọ Y ka ịmalite sava weebụ Apache.
Ọ bụrụ na ị nwere firewall na-agba ọsọ, mepee ọdụ ụgbọ mmiri 80 iji kwe ka okporo ụzọ webụ rụọ ọrụ.
# firewall-cmd --add-port=80/tcp --permanent # firewall-cmd --reload
Na-esote, hazie SELinux dị ka egosiri:
# setsebool -P httpd_can_network_connect 1
Iji nweta pgadmin4, malite ihe nchọgharị gị wee chọgharịa URL egosiri.
http://server-ip/pgadmin4
Jide n'aka na iji adreesị ozi-e na okwuntughe nke ị nyere mgbe ị na-eji edemede ntọlite ba na-abanye.
Nke a na-eduga gị na dashboard Pgadmin4 dị ka egosiri n'okpuru.
Ma nke ahụ bụ otu esi etinye Pgadmin4 na ọnọdụ nkesa. Ị nwere ike ịmepụta ma jikwaa ọdụ data PostgreSQL site na iji nchịkọta akụkọ SQL wee nyochaa arụmọrụ ha site na iji dashboards nyere. Nke a na-eduga anyị na njedebe nke ntuziaka a.