Otu esi etinye PgAdmin na Rocky Linux na AlmaLinux

PgAdmin 4 bụ ihe mepere emepe, dị ike, yana ngwa nchịkwa nchekwa data PostgreSQL dị n'ihu. PgAdmin 4 na-enye ndị nchịkwa ohere ijikwa ọdụ data PostgreSQL n'enweghị nsogbu site na ihe nchọgharị weebụ wee mee ajụjụ SQL n'etiti ọrụ nchekwa data ndị ọzọ. Edere ya na Python na Javascript/JQuery ma bụrụ nkwalite nke PgAdmin onye bu ya ụzọ.

Atụmatụ pụtara ìhè gụnyere:

  • syntax na-eme ka onye ndezi SQL pụta ìhè.
  • Ihe nrụgharị ọrụ emegharịrị na nke ọhụrụ.
  • Ngwa ajụjụ ajụjụ SQL dị ndụ maka idezi data ozugbo.
  • Ngwa dị ike ma dị mfe iji maka ọrụ nhazi nchekwa data kwa ụbọchị.
  • Mmetụta webụ na-anabata, yana ọtụtụ ndị ọzọ.

N'isiokwu a, anyị na-elekwasị anya ka ị ga-esi tinye PgAdmin4 na Rocky Linux na AlmaLinux.

Dịka achọrọ, ịkwesịrị itinye PostgreSQL. Ugbua, anyị nwere ntuziaka maka otu esi etinye PostgreSQL na Rocky Linux na AlmaLinux.

Kwụpụ 1: Tinye ebe nchekwa PgAdmin4 na Rocky Linux

Iji tinye PgAdmin4, nzọụkwụ mbụ ga-abụ ịgbakwunye ebe nchekwa PgAdmin4. Mana buru ụzọ wụnye ngwugwu yum-utils.

$ sudo dnf install yum-utils

Na-esote, gbanyụọ ebe nchekwa PostgreSQL maka ịkwado maka ntinye nke ngwugwu PgAdmin4 kachasị ọhụrụ.

$ sudo yum-config-manager --disable pgdg-common

Ozugbo iwu ahụ mechara nke ọma, wụnye ebe nchekwa PgAdmin4.

$ sudo rpm -i https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-2-1.noarch.rpm

Kwụpụ 2: Wụnye PgAdmin4 na Rocky Linux

Ozugbo ebe nchekwa PgAdmin4 dị, melite ebe nchekwa sistemụ.

$ sudo dnf update

Na-esote, wụnye pgAdmin 4 site na ịme iwu:

$ sudo dnf install pgadmin4

Nke a na-etinye pgAdmin4, Apache webụsaịtị yana ndabere ndị ọzọ PgAdmin4 chọrọ. Pịa ‘Y’ mgbe kpaliri itinye ngwungwu na ndabere niile.

Kwụpụ 3: Malite na Kwado Webserver Apache

Tupu ịtọlite PgAdmin4, anyị kwesịrị ịmalite ọrụ sava weebụ Apache. Nke a dị mkpa ebe PgAdmin4 na-agba na sava weebụ.

Iji mee ka sava weebụ Apache rụọ ọrụ, mee iwu a:

$ sudo systemctl enable httpd

Ozugbo enyere ya aka, gaba n'ihu wee malite ọrụ Apache dị ka ndị a.

$ sudo systemctl start httpd

Iji nyochaa na Apache na-agba ọsọ, mebie iwu:

$ sudo systemctl status httpd

Kwụpụ 4: Tọọ PgAdmin4 na Rocky Linux

N'ịga n'ihu, anyị nwere ike ịga n'ihu ịhazi PgAdmin4 site na ịmegharị edemede ntọlite PgAdmin4 dị ka egosiri:

$ sudo /usr/pgadmin4/bin/setup-web.sh

Edemede ahụ na-edozi PgAdmin4 na ọnọdụ webụ wee kpalie maka nkọwa dịka adreesị ozi-e na paswọọdụ. A ga-eji ihe ndị a emechaa mee nyocha. Ya mere, nye adreesị ozi-e na paswọọdụ gị, wee pịa ’y’ ka ịmalitegharịa sava weebụ Apache.

Tupu anyị abanye GUI webụ PgAdmin4, anyị kwesịrị ịgbanwe ntọala SELinux anyị. Ọ bụrụ na SELinux nọ na ọnọdụ mmanye, tọọ ya ka ọ bụrụ ọnọdụ ikike ka egosiri.

$ sudo setenforce permissive

Anyị kwesịkwara ịhazi firewall iji kwe ka okporo ụzọ HTTP dị ka egosiri.

$ sudo firewall-cmd --permanent --add-service=http

Mgbe ahụ, bugharịa ka ọ mee mgbanwe ndị ahụ.

$ sudo firewall-cmd --reload

Kwụpụ 5: Nweta PgAdmin4 na Rocky Linux

N'ikpeazụ, ịbanye, malite ihe nchọgharị gị wee gaa na URL:

http://server-ip/pgadmin4

Tinye nzere nbanye, i.e. adreesị ozi-e na okwuntughe nke i debere na mbụ, wee pịa bọtịnụ 'Nbanye'.

Dashboard PgAdmin 4 ga-abịa ilele.

Site na ndabara, ọ nweghị ihe nkesa nchekwa data ejikọrọ ugbu a. Iji jikọọ na ihe nkesa nchekwa data ọhụrụ, pịa akara ngosi 'Tinye New Server'.

Na ngalaba 'General', nye aha maka ihe nkesa nchekwa data gị. N'ọnọdụ anyị, anyị ga-enye aha aka ike - nchekwa data PostgreSQL mpaghara.

Wee pịa taabụ 'njikọ' wee dejupụta nkọwa achọrọ. N'ebe a, anyị na-eji nchekwa data Postgres ndabara yana nzere onye ọrụ. Okwuntughe bụ nke onye ọrụ postgres.

Wee pịa 'Chekwa'.

Mgbe njikọ gachara, ihe nkesa nchekwa data ga-apụta n'akụkụ aka ekpe. Pịa ya ka ịlele nkọwa nchekwa data ndị ọzọ wee lelee dashboards arụmọrụ.

N'ime ntuziaka a, anyị rụnyere PgAdmin4 nke ọma na Rocky Linux na AlmaLinux wee gbakwunye ihe nkesa nchekwa data iji nyochaa arụmọrụ nke ọdụ data.