Yadda ake Shigar PostgreSQL da pgAdmin a cikin RHEL 8
Pgadmin4 kayan aiki ne na bude yanar gizo don gudanar da bayanan bayanan PostgreSQL. Yana da aikace-aikacen yanar gizo mai tushen Python wanda aka haɓaka ta amfani da tsarin flask a bayanta da HTML5, CSS3, da Bootstrap akan gaba. Pgadmin4 shine sake rubuta Pgadmin 3 wanda aka rubuta a C ++ kuma jiragen ruwa tare da waɗannan sanannun fasalulluka:
- Sanya ido da sake fasalin yanar gizo tare da goge gumaka da bangarori.
- Tsarin gidan yanar gizo mai cikakken amsa tare da dashbod don kulawa na ainihin lokaci.
- Live SQL kayan aikin tambaya/edita tare da haskaka tsarin magana.
- Tattaunawar gudanarwa mai ƙarfi da kayan aiki don ɗawainiya ɗaya.
- Bayani mai amfani don farawa.
- Kuma fiye da haka.
A cikin wannan labarin, zaku koyi yadda ake girka PostgreSQL tare da pagAdmin4 a yanayin uwar garken da ke gudana a bayan Apache webserver ta amfani da tsarin WSGI akan RHEL 8.
Shigar da PostgreSQL akan RHEL 8
Mataki na farko a girka PgAdmin4 shine shigar da uwar garken gidan bayanan PostgreSQL. Ana samun PostgreSQL a cikin wurin ajiyar Appstream cikin nau'uka daban-daban. Kuna iya zaɓar ku ta hanyar ba da damar kunshin da kuka fi so ta amfani da manajan kunshin dnf.
Don lissafa wadatattun kayayyaki don PostgreSQL, gudanar da umarnin:
# dnf module list postgresql
Sakamakon ya nuna cewa akwai nau'ikan guda 3 da za'a iya amfani dasu don zazzagewa daga wurin ajiyar AppStream: sigar 9.6, 10, da 12. Hakanan zamu iya ganin cewa tsoffin sigar ita ce Postgresql 10 kamar yadda alamar [d] ta nuna . Wannan shine abin da zaku girka ta hanyar aiwatar da umarnin da ke ƙasa.
# dnf install postgresql-server
Koyaya, muna son girka sabuwar sigar, wacce ita ce PostgreSQL 12. Saboda haka, za mu ba da damar wannan ƙirar kuma mu rinjayi tsoho mai amfani. Don yin haka, gudanar da umarni:
# dnf module enable postgresql:12
Da zarar kun kunna tsarin don Postgresql 12, ci gaba da shigar da Postgresql 12 tare da masu dogaro kamar yadda aka nuna.
# dnf install postgresql-server
Kafin komai, kuna buƙatar ƙirƙirar tarin bayanan. Ungiya ta ƙunshi tarin bayanai waɗanda ake sarrafa su ta hanyar misalin sabar. Don ƙirƙirar tarin bayanai, kira umarnin:
# postgresql-setup --initdb
Idan komai ya tafi daidai, ya kamata ku sami fitarwa a ƙasa.
Da zarar an ƙirƙiri tari, yanzu zaku iya farawa da kunna misalin PostgreSQL ɗinku kamar yadda aka nuna:
# systemctl start postgresql # systemctl enable postgresql
Don tabbatar da cewa Postgresql yana gudana kuma yana gudana, aiwatar da:
# systemctl status postgresql
Shigar da Pgadmin4 a cikin RHEL 8
Don shigar da Pgadmin4, da farko, ƙara ma'ajiyar waje da aka nuna a ƙasa.
# rpm -i https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm
Na gaba, gudanar da umarnin da ke ƙasa don shigar pgadmin4 a cikin yanayin sabar.
# dnf install pgadmin4-web
Na gaba, girka abubuwan kunshin siyasa wanda ke samar da manyan abubuwan amfani da SELinux ke buƙata.
$ sudo dnf install policycoreutils-python-utils
Da zarar an girka, sai a fara rubutun saitin Pgadmin4 kamar yadda aka nuna. Wannan zai ƙirƙiri asusun mai amfani na pgadmin, adanawa da kundin adireshi, saita SELinux sannan kuma juya Apache webserver wanda pgAdmin4 zai gudana.
# /usr/pgadmin4/bin/setup-web.sh
Lokacin da aka sa ka, samar da bayanan da ake buƙata kuma latsa Y don fara Apache webserver.
Idan kana da katangar wuta da ke gudana, buɗe tashar 80 don ba da izinin zirga-zirgar sabis na yanar gizo.
# firewall-cmd --add-port=80/tcp --permanent # firewall-cmd --reload
Na gaba, saita SELinux kamar yadda aka nuna:
# setsebool -P httpd_can_network_connect 1
Don samun damar pgadmin4, ƙaddamar da burauzarku kuma bincika URL ɗin da aka nuna.
http://server-ip/pgadmin4
Tabbatar shiga ta amfani da adreshin imel da kalmar sirri da kuka bayar yayin gudanar da rubutun saiti.
Wannan yana baka damar zuwa dashboard na Pgadmin4 kamar yadda aka nuna a ƙasa.
Kuma wannan shine yadda zaka shigar Pgadmin4 a cikin yanayin uwar garke. Yanzu zaku iya ƙirƙira da sarrafa bayanan PostgreSQL ta amfani da editan SQL kuma saka idanu kan aikin su ta amfani da dashboards ɗin da aka bayar. Wannan ya kawo mu karshen wannan jagorar.