Otu esi etinye PgAdmin 4 Debian 10
pgAdmin bụ ihe mepere emepe, dị ike, yana njiri mara njirimara njirimara njirimara njirimara (GUI) njikwa na njikwa maka nchekwa data PostgreSQL. Ugbu a, ọ na-akwado PostgreSQL 9.2 ma ọ bụ mgbe e mesịrị, na-agba ọsọ na Unix na variants dị ka Linux, Mac OS X yana Windows arụ ọrụ.
Ọ na-enye ngwa ọrụ dị ike nke na-enyere gị aka ịmepụta, jikwaa, dokwaa na iji ihe nchekwa data, site na ndị mbido na ndị ọrụ Postgres nwere ahụmahụ.
pgAdmin 4 bụ nnukwu ntọhapụ (na idegharị zuru oke) nke pgAdmin, nke ejiri Python na Javascript/jQuery wuru, yana oge ojiri desktọpụ edere na C ++ nwere Qt. pgAdmin 4 na-akwalite nke ukwuu na pgAdmin 3 site na iji ihe njirimara emelitere (UI), nhọrọ ọtụtụ onye ọrụ/webụsaịtị, dashboards, yana imewe ọgbara ọhụrụ na nke mara mma.
N'ime edemede a, anyị ga-egosi gị otu esi etinye pgAdmin 4 na sistemụ Debian 10 iji nye nchekwa data PostgreSQL dị nchebe, nke dịpụrụ adịpụ.
Ntuziaka a na-eche na ị tinyelarị PostgreSQL 9.2 ma ọ bụ karịa ma hazie ya na sava Debian 10 gị, ma ọ bụghị iji wụnye ya, soro ntuziaka anyị: Otu esi etinye PostgreSQL 11 na Debian 10.
Ịwụnye pgAdmin 4 na Debian 10
Ụgbọ mmiri Debian 10 nwere pgAdmin 3 na ndabara. Iji tinye pgAdmin 4, ịkwesịrị ịme ka PostgreSQL Global Development Group (PGDG) APT nchekwa (nke nwere ngwugwu PostgreSQL maka Debian na Ubuntu) na sistemụ gị.
# apt-get install curl ca-certificates gnupg # curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -
Mepụta faịlụ nchekwa a na-akpọ /etc/apt/sources.list.d/pgdg.list.
# vim /etc/apt/sources.list.d/pgdg.list
Ma tinye ahịrị ndị a na faịlụ ahụ.
deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main
Chekwaa mgbanwe ndị ahụ wee pụọ na faịlụ ahụ.
Ugbu a melite cache ngwugwu APT (nke bụ usoro iwu kwadoro), ma wụnye ngwugwu pgAdmin 4 dị ka ndị a. Ngwungwu pgadmin4-apache2 bụ ngwa WSGI.
# apt-get update # apt-get install pgadmin4 pgadmin4-apache2
N'oge nrụnye ngwugwu, a ga-ajụ gị ka ịtọọ adreesị ozi-e maka akaụntụ njirimara mbụ pgAdmin webụ. Email a ga-arụ ọrụ dị ka aha akaụntụ, nye ya wee pịa Tinye.
A ga-ajụkwa gị ka ịtọọ paswọọdụ maka akaụntụ njirimara mbụ pgadmin4. Nye paswọọdụ echekwara ma sie ike, wee pịa Tinye ka ịga n'ihu.
Ozugbo etinyere ngwugwu ndị ahụ, onye nrụnye na-eme ka sistemu ahụ rụọ ọrụ iji malite ọrụ Apache2 ma mee ka ọ malite na akpaghị aka na mmalite sistemụ, oge ọ bụla ewegharịrị sistemụ ahụ.
Ị nwere ike ịlele ọkwa nke ọrụ ahụ site na iwu na-esonụ iji hụ na ọ na-arụ ọrụ.
# systemctl status apache2
Na Debian 10, a na-ahazi ngwa pgAdmin 4 WSGI ka ọ rụọ ọrụ na sava HTTP Apache site na ndabara site na iji faịlụ nhazi /etc/apache2/conf-available/pgadmin4.conf.
Tupu ịnweta pgadmin4 web interface, ọ bụrụ na ị nwere UFW firewall na-agba ọsọ (ọ na-enwekarị nkwarụ na ndabara), ịkwesịrị imepe ọdụ ụgbọ mmiri 80 (HTTP) iji kwe ka okporo ụzọ na-abata na ọrụ Apache dị ka ndị a.
# ufw allow 80 # ufw allow 443 # ufw status
Ịnweta Interface Weebụ pgAdmin 4
Ugbu a ị nwere ike ịnweta ihe ntanetị pgAdmin 4. Mepee ihe nchọgharị weebụ wee tụọ ya na adreesị na-esonụ wee pịa Tinye.
http://SERVER_IP/pgadmin4 OR http://localhost/pgadmin4
Ozugbo pgAdmin 4 webụ nbanye interface pụtara, tinye adreesị ozi-e na paswọọdụ ị debere na mbụ iji chọpụta. Wee pịa banye.
Mgbe ịbanyechara nke ọma, ị ga-abata na pgAdmin4 web interface dashboard ndabere. Iji jikọọ na ihe nkesa nchekwa data, pịa Tinye ọhụrụ nkesa.
Wee tinye aha njikọ nkesa ọhụrụ yana ikwu. Ma pịa na Njikọ Njikọ iji nye nkọwa njikọ ahụ bụ aha nnabata, aha nchekwa data, aha njirimara nchekwa data, na paswọọdụ dị ka egosiri na nseta ihuenyo na-esonụ. Ozugbo ịmechara, pịa Chekwa.
N'okpuru osisi ihe nchọgharị, ị kwesịrị ịnwe opekata mpe otu njikọ nkesa na-egosi aha njikọ, ọnụọgụ ọdụ data, ọrụ na oghere tebụl. Pịa na njikọ ọdụ data ugboro abụọ ka ịlele nyocha arụmọrụ nkesa n'okpuru Dashboard.
Ebe obibi pgAdmin: https://www.pgadmin.org/
Ọ gwụla! pgAdmin 4 na-emeziwanye nke ọma na pgAdmin 3 nwere ọtụtụ atụmatụ ọhụrụ, ndozi na ndozi ahụhụ. N'ime ntuziaka a, anyị gosipụtara otu esi etinye na hazie pgAdmin 4 na sava Debian 10. Ọ bụrụ na ị nwere ajụjụ ọ bụla, kpọtụrụ anyị site na ụdị nkọwa n'okpuru.