Yadda ake Shigar PostgreSQL da pgAdmin4 a cikin Ubuntu 20.04

Wannan jagorar zai bi ku ta hanyar umarnin don girka tsarin PostgreSQL 12 mai dangantaka da daidaitaccen tsarin kula da tsarin bayanai da pgAdmin4, kayan aikin gidan yanar gizo na PostgreSQL sabar kayan aikin uwar garken. Zamu nuna yadda ake girka sabuwar pgAdmin4 wacce take v4.23.

• Ubuntu 20.04 Sabis na shigarwa
• Ubuntu 20.04 shigarwar tebur

Bari mu fara…

Shigar da PostgreSQL a cikin Ubuntu 20.04

Shiga cikin tsarin Ubuntu ɗin ku kuma sabunta abubuwan fakitin tsarin ta amfani da umarni mai dacewa.

$ sudo apt update

Yanzu shigar da sabon sigar PostgreSQL daga tsoffin wuraren ajiye Ubuntu.

$ sudo apt install postgresql

Yayin shigarwa, mai shigarwar zai kirkiri wani sabon rukunin PostgreSQL (tarin bayanan bayanan da za'a gabatar dasu ta hanyar misali guda daya), saboda haka ya kirkiro bayanan. Tsoffin bayanan bayanai shine/var/lib/postgresql/12/babba kuma ana adana fayilolin daidaitawa a cikin/sauransu/postgresql/12/babban kundin adireshi.

Bayan an shigar da PostgreSQL, zaku iya tabbatar da cewa sabis ɗin PostgreSQL yana aiki, yana gudana kuma ana kunna shi a ƙarƙashin tsarin amfani da waɗannan umarnin systemctl masu zuwa:

$ sudo systemctl is-active postgresql
$ sudo systemctl is-enabled postgresql
$ sudo systemctl status postgresql

Hakanan, tabbatar cewa uwar garken Postgresql a shirye take don karɓar haɗi daga abokan ciniki kamar haka:

$ sudo pg_isready

Irƙirar Bayanai a cikin PostgreSQL

Don ƙirƙirar sabon rumbun adana bayanai a cikin PostgreSQL, kuna buƙatar samun damar shirin matattarar bayanan PostgreSQL (psql) . Da farko, canza zuwa asusun mai amfani na postgres kuma gudanar da umarnin psql kamar haka:

$ sudo su - postgres
$ psql
postgres=# 

Yanzu ƙirƙirar sabon rumbun adana bayanai da mai amfani ta amfani da waɗannan umarnin.

postgres=# CREATE USER tecmint WITH PASSWORD '[email ';
postgres=# CREATE DATABASE tecmintdb;
postgres=# GRANT ALL PRIVILEGES ON DATABASE tecmintdb to tecmint;
postgres=# \q

Tattaunawa game da Tabbacin Abokin Cinikin PostgreSQL

PostgreSQL yana amfani da amincin abokin ciniki don yanke shawarar wane asusun mai amfani zai iya haɗawa da waɗancan rumbun adana bayanai daga waɗanda masu masaukai kuma wannan ana sarrafa su ta hanyar saituna a cikin fayil ɗin tabbatar da ingancin abokin ciniki, wanda akan Ubuntu yake a /etc/postgresql/12/main/pg_hba.conf.

Buɗe wannan fayil ɗin ta yin amfani da editan rubutun da kuka fi so kamar yadda aka nuna.

$ sudo vim /etc/postgresql/12/main/pg_hba.conf

PostgreSQL yana amfani da nau'ikan yawancin hanyoyin tabbatar da abokin ciniki ciki har da takwarorina, ID, kalmar sirri, da md5 (karanta bayanan PostgreSQL 12 don cikakken bayani game da kowace hanya).

md5 shine mafi amintacce kuma an ba da shawara saboda yana buƙatar abokin ciniki ya samar da kalmar sirri mai sau biyu-MD5 don tabbatarwa. Don haka, tabbatar da cewa shigarwar da ke ƙasa suna da md5 azaman ƙarkashin hanyar:

host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                	md5

Bayan yin canje-canje a cikin fayil ɗin sanyi na Abokin Ciniki, kuna buƙatar sake farawa sabis na PostgreSQL.

$ sudo systemctl restart postgresql

Shigar pgAdmin4 a cikin Ubuntu

pgAdmin4 ba a cikin ɗakunan ajiya na Ubuntu ba. Muna buƙatar shigar da shi daga ma'ajin APT na pgAdmin4. Fara da kafa wurin ajiye man. Keyara maɓallin jama'a don ajiyar kuma ƙirƙirar fayil ɗin daidaitawa.

 
$ curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
$ sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

Sannan shigar pgAdmin4,

$sudo apt install pgadmin4

Umurnin da ke sama zai girka fakiti da yawa da ake buƙata gami da Apache2 webserver don hidimar pgadmin4-aikin yanar gizo a yanayin yanar gizo.

Da zarar an gama girke-girke, gudanar da rubutun saitin yanar gizo wanda ke jigila tare da pgdmin4 binary kunshin, don daidaita tsarin don gudanar da yanayin yanar gizo. Za a sa ka ƙirƙiri imel na shiga na pgAdmin4 da kalmar wucewa kamar yadda aka nuna a cikin hoton da ke ƙasa.

Wannan rubutun zai daidaita Apache2 don hidimar pgAdmin4 aikace-aikacen yanar gizo wanda ya haɗa da kunna tsarin WSGI da daidaita aikace-aikacen pgAdmin don hawa a pgadmin4 akan rukunin yanar gizo don ku sami dama gare shi a:

http://SERVER_IP/pgadmin4

Hakanan ya sake farawa sabis na Apache2 don amfani da canje-canje kwanan nan.

Ka tuna maye gurbin [email tare da adireshin imel ɗinka kuma saita kalmar sirri mai ƙarfi kuma:

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

Samun damar Intanet na pgAdmin4

Don samun damar haɗin yanar gizo na pgAdmin4, buɗe gidan yanar gizo, kuma yi amfani da adireshin da ke gaba don kewaya:

http://SERVER_IP/pgadmin4

Da zarar shafin shiga ya loda, shigar da adireshin imel da kalmar wucewa da kuka ƙirƙira a sashin da ya gabata yayin daidaita pgAdmin4 don gudana cikin yanayin yanar gizo.

Bayan nasarar shiga, za ku kasance ƙasa a cikin dashboard aikace-aikacen gidan yanar gizo na pgAdmin4. Don haɗawa zuwa sabar, danna Addara Sabon Sabar kamar yadda aka haskaka a cikin hoton da ke tafe.

Na gaba, shigar da haɗin a cikin Saitunan Gabaɗaya (Suna, Serverungiyar Sabis, da tsokaci). Sannan danna Haɗawa kamar yadda aka haskaka a cikin hoton allo mai zuwa.

Na gaba, shigar da sunan uwar garke/adireshin uwar garken PostgreSQL, sunan Port/lambar Port (barin 5432 don amfani da tsoho), zaɓi Maintenance data (wanda yakamata ya zama postgres), shigar da sunan mai amfani da kalmar wucewa.

Idan takaddun bayanan isa ga bayanai suna da kyau kuma daidaitaccen sahihan uwar garken ya kasance, pgAdmin4 yakamata yayi nasarar haɗuwa da sabar bayanan.

Shi ke nan! Don ƙarin bayani, duba pgAdmin 4 takardun. Ka tuna ka raba tunaninka tare da mu ta ɓangaren sharhi da ke ƙasa.