Yadda ake Shigar PgAdmin 4 Debian 10

pgAdmin buɗaɗɗen tushe ne, mai ƙarfi, kuma mai wadataccen fasali mai amfani da keɓaɓɓen kayan aiki (GUI) da kayan aikin gudanarwa don bayanan PostgreSQL. A halin yanzu, yana tallafawa PostgreSQL 9.2 ko kuma daga baya, kuma yana gudana akan Unix da ire-irensa kamar Linux, Mac OS X da kuma tsarin aiki na Windows.

Yana bayar da ƙirar mai amfani mai ƙarfi wanda zai baka damar ƙirƙirar, sarrafawa, kiyayewa da amfani da abubuwan ajiyar bayanai, ta masu farawa da ƙwararrun masu amfani da Postgres iri ɗaya.

pgAdmin 4 babban saki ne (kuma cikakken sake rubutawa) na pgAdmin, wanda aka gina ta amfani da Python da Javascript/jQuery, da lokacin aikin tebur da aka rubuta a C ++ tare da Qt. pgAdmin 4 haɓakawa sosai akan pgAdmin 3 tare da abubuwan sabunta ƙirar mai amfani (UI), zaɓuɓɓukan masu amfani da yawa/aikawar yanar gizo, dashboards, da ƙirar zamani da ta dace.

A cikin wannan labarin, za mu nuna muku yadda ake girka pgAdmin 4 akan tsarin Debian 10 don samar da amintacciyar hanya mai nisa ga rumbun adana bayanan PostgreSQL.

Wannan jagorar yana ɗauka cewa kuna da PostgreSQL 9.2 ko sama da haka an girka kuma an saita shi akan sabar Debian 10, in ba haka ba don girka shi, bi jagorarmu: Yadda ake Shigar PostgreSQL 11 akan Debian 10.

Shigar pgAdmin 4 a cikin Debian 10

Debian 10 jiragen ruwa tare da pgAdmin 3 ta tsohuwa. Don shigar da pgAdmin 4, kuna buƙatar kunna wurin ajiyar APT na PostgreSQL Global Development Group (PGDG) (wanda ya ƙunshi fakitin PostgreSQL na Debian da Ubuntu) akan tsarinku.

# apt-get install curl ca-certificates gnupg
# curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -

Sannan ƙirƙirar fayil ɗin ajiya mai suna /etc/apt/sources.list.d/pgdg.list.

# vim /etc/apt/sources.list.d/pgdg.list

Kuma ƙara layi mai zuwa a cikin fayil ɗin.

deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main

Adana canje-canje kuma fita daga fayil ɗin.

Yanzu sabunta APT kunshin cache (wanda shine matakin tilas), kuma girka pgAdmin 4 kunshin kamar haka. Kunshin pgadmin4-apache2 shine aikace-aikacen WSGI.

# apt-get update
# apt-get install pgadmin4  pgadmin4-apache2

Yayin shigarwar kunshin, za a umarce ku da saita adireshin imel don pgAdmin yanar gizo mai amfani da asusun mai amfani na farko. Wannan imel ɗin zaiyi aiki azaman sunan asusu, samar dashi kuma latsa Shigar dashi.

Hakanan za'a tambaye ku don saita kalmar sirri don asusun mai amfani na farko pgadmin4. Bayar da amintaccen kuma kalmar sirri mai ƙarfi, sannan danna Shigar don ci gaba.

Da zarar an shigar da fakitin, mai shigarwar zai kunna tsarin don fara sabis ɗin Apache2 kuma ya ba shi damar farawa ta atomatik a farawa tsarin, duk lokacin da aka sake tsarin.

Kuna iya bincika matsayin sabis ɗin tare da umarni mai zuwa don tabbatar da cewa yana aiki da gudana.

# systemctl status apache2 

A Debian 10, an saita pgAdmin 4 WSGI aikace-aikacen don aiki tare da uwar garken Apache HTTP ta tsohuwa ta amfani da fayil ɗin sanyi /etc/apache2/conf-available/pgadmin4.conf.

Kafin ka sami damar shiga shafin yanar gizo na pgadmin4, idan kana da Tacewar zaɓi ta UFW da ke gudana (yawanci ana kashe ta ta tsohuwa), kana buƙatar buɗe tashar jiragen ruwa 80 (HTTP) don ba da damar zirga-zirga masu shigowa kan sabis ɗin Apache kamar haka.

# ufw allow 80
# ufw allow 443
# ufw status

Samun damar shiga yanar gizo na pgAdmin 4

Yanzu zaku iya samun damar haɗin yanar gizon pgAdmin 4. Bude burauzar gidan yanar gizo ka nuna ta ga adireshi mai zuwa ka latsa Shigar.

http://SERVER_IP/pgadmin4
OR
http://localhost/pgadmin4

Da zarar shafin shiga na pgAdmin 4 ya bayyana, shigar da adireshin imel da kalmar wucewa da ka saita tun farko don tantancewa. Sannan danna shiga.

Bayan nasarar shiga, za ku sauka a dgaburin tsoho na yanar gizo na pgAdmin4. Don haɗawa zuwa sabar tarin bayanai, danna Addara Sabon Sabar.

Sannan ƙara sabon sunan haɗin sabar da tsokaci. Kuma latsa Tab ɗin Haɗin don samar da cikakkun bayanan haɗi I sunan mai masauki, sunan bayanai, sunan mai amfani na bayanai, da kalmar wucewa kamar yadda aka nuna a cikin hoton da ke gaba. Da zarar ka gama, danna Ajiye.

A karkashin bishiyar Browser, yanzu yakamata ku sami aƙalla haɗi ɗaya na sabar da ke nuna sunan haɗi, adadin bayanan bayanai, matsayi, da kuma tebur. Danna sau biyu akan mahaɗin bayanan don duba aikin aikin sabar a ƙarƙashin Dashboard.

shafin farko na pgAdmin: https://www.pgadmin.org/

Shi ke nan! pgAdmin 4 ya inganta sosai akan pgAdmin 3 tare da sabbin abubuwa da yawa, haɓakawa, da gyaran bug. A cikin wannan jagorar, mun nuna yadda ake girkawa da saita pgAdmin 4 akan sabar Debian 10. Idan kuna da kowace tambaya, ku isa gare mu ta hanyar fom ɗin da ke ƙasa.