Yadda ake Sanya PgAdmin akan Rocky Linux da AlmaLinux

PgAdmin 4 buɗaɗɗen tushe ne, mai ƙarfi, kuma kayan aikin sarrafa bayanai na PostgreSQL na gaba. PgAdmin 4 yana bawa masu gudanarwa damar sarrafa bayanan bayanai na PostgreSQL ba tare da matsala ba daga mai binciken gidan yanar gizo da gudanar da tambayoyin SQL tsakanin sauran ayyukan bayanai. An rubuta shi a cikin Python da Javascript/JQuery kuma haɓaka ne na PgAdmin wanda ya gabace shi.

Fitattun siffofi sun haɗa da:

  • A syntax mai haskaka editan SQL.
  • Sake gyare-gyare da sabon fasalin mai amfani.
  • Kayan aikin tambaya na SQL Live don gyara bayanan kai tsaye.
  • Kayan aiki masu ƙarfi da sauƙin amfani don ayyukan gudanarwa na yau da kullun.
  • Maganganun yanar gizo mai amsawa, da ƙari.

A cikin wannan labarin, mun mai da hankali kan yadda zaku iya shigar da PgAdmin4 akan Rocky Linux da AlmaLinux.

A matsayin buƙatu, kuna buƙatar shigar da PostgreSQL. Tuni, muna da jagora kan yadda ake shigar da PostgreSQL akan Rocky Linux da AlmaLinux.

Mataki 1: Ƙara PgAdmin4 Repository akan Rocky Linux

Don shigar da PgAdmin4, matakin farko shine ƙara ma'ajiyar PgAdmin4. Amma da farko, shigar da kunshin yum-utils.

$ sudo dnf install yum-utils

Na gaba, musaki ma'ajin gama gari na PostgreSQL don shirya don shigar da sabbin fakitin PgAdmin4.

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

Da zarar umarnin ya gudana cikin nasara, shigar da ma'ajin PgAdmin4.

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

Mataki 2: Sanya PgAdmin4 akan Rocky Linux

Da zarar ma'ajiyar PgAdmin4 ta kasance, sabunta ma'ajiyar tsarin.

$ sudo dnf update

Na gaba, shigar da pgAdmin 4 ta hanyar aiwatar da umarnin:

$ sudo dnf install pgadmin4

Wannan yana shigar da pgAdmin4, sabar gidan yanar gizo na Apache tare da sauran abubuwan dogaro waɗanda PgAdmin4 ke buƙata. Latsa ‘Y’ lokacin da aka sa ka shigar da duk fakiti da abin dogaro.

Mataki 3: Fara kuma Kunna Apache Webserver

Kafin kafa PgAdmin4, muna buƙatar fara sabis ɗin sabar gidan yanar gizo na Apache. Wannan ya zama dole tunda PgAdmin4 yana gudana akan sabar gidan yanar gizo.

Don kunna sabar gidan yanar gizon Apache, gudanar da umarni:

$ sudo systemctl enable httpd

Da zarar an kunna, ci gaba kuma fara sabis ɗin Apache kamar haka.

$ sudo systemctl start httpd

Don tabbatar da cewa Apache yana gudana, aiwatar da umarnin:

$ sudo systemctl status httpd

Mataki 4: Saita PgAdmin4 a cikin Rocky Linux

Ci gaba, yanzu za mu iya ci gaba don saita PgAdmin4 ta hanyar gudanar da rubutun saitin PgAdmin4 kamar yadda aka nuna:

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

Rubutun yana saita PgAdmin4 a cikin yanayin gidan yanar gizo kuma yana haifar da cikakkun bayanai kamar adireshin imel da kalmar wucewa. Wadannan, daga baya, za a yi amfani da su don tantancewa. Don haka, samar da adireshin imel da kalmar wucewa, kuma danna ‘y’ don sake kunna sabar gidan yanar gizo ta Apache.

Kafin mu shiga GUI na PgAdmin4, muna buƙatar daidaita saitunan SELinux. Idan SELinux yana kan yanayin tilastawa, saita shi zuwa yanayin izini kamar yadda aka nuna.

$ sudo setenforce permissive

Muna kuma buƙatar saita Tacewar zaɓi don ba da izinin zirga-zirgar HTTP kamar yadda aka nuna.

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

Sannan sake kunnawa don aiwatar da canje-canje.

$ sudo firewall-cmd --reload

Mataki 5: Samun damar PgAdmin4 a cikin Rocky Linux

A ƙarshe, don shiga, buɗe burauzar ku kuma ziyarci URL:

http://server-ip/pgadmin4

Shigar da bayanan shiga, watau adireshin imel da kalmar sirri da kuka saita a baya, sannan ku danna maɓallin 'Login'.

Dashboard ɗin PgAdmin 4 zai zo dubawa.

Ta hanyar tsoho, babu uwar garken bayanan da aka haɗa a halin yanzu. Don haɗa zuwa sabon uwar garken bayanai, danna kan 'Ƙara Sabon Sabar' icon.

A sashin 'Gabaɗaya', samar da suna don uwar garken bayanan ku. A cikin yanayinmu, za mu samar da suna na sabani - tushen bayanan PostgreSQL na gida.

Sannan danna maballin 'Connection' sannan ka cika bayanan da ake bukata. Anan muna amfani da tsoffin bayanan Postgres da bayanan mai amfani. Kalmar wucewa ta mai amfani da postgres ce.

Sannan danna 'Ajiye'.

Bayan haɗin kai ya yi nasara, uwar garken bayanai za ta bayyana a gefen hagu. Danna kan shi don duba ƙarin bayanan bayanan bayanai da duba dashboards na aiki.

A cikin wannan jagorar, mun sami nasarar shigar da PgAdmin4 akan Rocky Linux da AlmaLinux kuma mun ƙara sabar bayanai don saka idanu akan ayyukan bayanan bayanai.