Yadda ake Sanya PostgreSQL da pgAdmin a cikin RHEL 9
Taƙaice: A cikin wannan labarin, za ku koyi yadda ake shigar da sabar bayanai ta PostgreSQL 15 da pgAdmin 4 a cikin RHEL 9 Linux rarraba.
PostgreSQL mai ƙarfi ne, ana amfani da shi sosai, buɗe tushen, dandamali da yawa, da ingantaccen tsarin bayanai na alaƙa da abu wanda aka sani don ingantaccen tsarin gine-gine, amintacce, amincin bayanai, saiti mai ƙarfi, da haɓakawa.
pgAdmin ci gaba ne, buɗaɗɗen tushe, cikakken fasali, da gudanarwa na tushen yanar gizo da kayan aiki don sabar bayanan PostgreSQL.
Mu fara…
Mataki 1: Sanya PostgreSQL akan RHEL 9
1. Na farko, musaki ginannen tsarin PostgreSQL ta hanyar gudanar da umarnin dnf mai zuwa.
# dnf -qy module disable postgresql
2. Na gaba, ba da damar ma'ajin PostgreSQL Yum na hukuma kamar yadda aka nuna.
# dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
3. Na gaba, shigar da uwar garken PostgreSQL 15 da fakitin abokin ciniki.
# dnf install -y postgresql15-server
4. Da zarar an gama shigarwa, sai a fara bayanan PostgreSQL, sannan fara sabis ɗin PostgreSQL-15 kuma ba da damar farawa ta atomatik a boot boot. Sannan duba idan sabis ɗin yana aiki kuma yana aiki kamar yadda aka nuna.
# /usr/pgsql-15/bin/postgresql-15-setup initdb # systemctl start postgresql-15 # systemctl enable postgresql-15 # systemctl status postgresql-15 # systemctl is-enabled postgresql-15
Mataki 2: Amintacce kuma Sanya Bayanan Bayanan PostgreSQL
5. Na gaba, kiyaye asusun mai amfani na Postgres da asusun mai amfani da bayanai. Fara da ƙirƙirar kalmar sirri don asusun mai amfani da tsarin Postgres ta amfani da mai amfani passwd kamar yadda aka nuna.
# passwd postgres
6. Sannan canza zuwa asusun tsarin Postgres kuma ƙirƙirar amintaccen kalmar sirri mai ƙarfi don mai amfani/rawar bayanai na PostgreSQL kamar haka.
# su - postgres $ psql -c "ALTER USER postgres WITH PASSWORD '[email ';" $ exit
7. Yanzu saita yadda uwar garken Postgres zata tantance abokan ciniki kamar pgAdmin. Hanyoyin tabbatarwa da aka goyan bayan sun haɗa da ingantaccen tushen kalmar sirri wanda ke amfani da ɗayan waɗannan hanyoyin: md5, crypt, ko kalmar sirri.
Don wannan jagorar, za mu saita hanyar tabbatar da md5 a cikin fayil /var/lib/pgsql/15/data/pg_hba.conf.
# vi /var/lib/pgsql/15/data/pg_hba.conf
Nemo layukan da ke biyowa kuma canza hanyar tantancewa zuwa md5 kamar yadda aka yi alama a cikin hoton allo.
host all all 127.0.0.1/32 md5 host all all ::1/128 md5
8. Bayan adana fayil ɗin, don amfani da canje-canjen kwanan nan a cikin tsarin Postgres, sake kunna sabis na Postgres.
# systemctl restart postgresql-15
Mataki 3: Shigar da pgAdmin4 a cikin RHEL 9
9. Yanzu za mu shigar da pgAdmin 4 don sarrafa bayanan PostgreSQL daga gidan yanar gizon. Da farko, kuna buƙatar kunna maajiyar EPEL da pgAdmin yum waɗanda ke ɗauke da wasu abubuwan dogaro.
# subscription-manager repos --enable codeready-builder-for-rhel-9-$(arch)-rpms # dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm # dnf install -y https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-2-1.noarch.rpm
10. Yanzu gina cache don sabbin ma'ajin pgAdmin da EPEL sannan ka shigar da pgAdmin ta amfani da umarni masu zuwa.
# dnf makecache # yum install pgadmin4
11. Bayan haka, fara sabis ɗin httpd kuma kunna shi don farawa ta atomatik a tsarin boot, sannan a duba ko yana aiki kamar yadda aka nuna.
# systemctl start httpd # systemctl enable httpd # systemctl status httpd
Mataki 4: Saita pgAdmin 4 a cikin RHEL 9
12. Kunshin pgadmin4 ya zo tare da rubutun da za a iya daidaitawa don saita sabis na gidan yanar gizon pgAdmin, wanda zai haifar da asusun mai amfani da aka yi amfani da shi don tantancewa a cikin mahallin yanar gizon, saita manufofin SELinux da Apache webserver don ƙaddamar da sabis na yanar gizo na pgAdmin.
# /usr/pgadmin4/bin/setup-web.sh
Setting up pgAdmin 4 in web mode on a Redhat-based platform... Creating configuration database... NOTE: Configuring authentication for SERVER mode. Enter the email address and password to use for the initial pgAdmin user account: Email address: [email Password: Retype password: pgAdmin 4 - Application Initialisation ====================================== Creating storage and log directories... Configuring SELinux... The Apache web server is running and must be restarted for the pgAdmin 4 installation to complete. Continue (y/n)? y Apache successfully restarted. You can now start using pgAdmin 4 in web mode at http://127.0.0.1/pgadmin4
13. Idan kana da sabis na Firewalld yana kunna kuma yana gudana, buɗe tashoshin jiragen ruwa 80 da 443 a cikin Tacewar zaɓi don ba da damar zirga-zirga zuwa sabar gidan yanar gizon HTTPD kamar yadda aka nuna.
# firewall-cmd --permanent --zone public --add-port 80/tcp # firewall-cmd --permanent --zone public --add-port 443/tcp # firewall-cmd --reload
Mataki 5: Shiga pgAdmin Web Interface
14. Don samun damar haɗin yanar gizon pgAdmin, buɗe mashigar yanar gizo kuma kewaya ta amfani da URL mai zuwa.
http://SERVER_IP/pgadmin4 OR http://localhost/pgadmin4
Da zarar mahaɗin shiga ya yi lodi, yi amfani da adireshin imel da kalmar sirri da kuka ƙirƙira a mataki na 12 na sama don shiga.
15. Na gaba, ƙara sabon haɗin yanar gizo ta danna kan \Ƙara Sabon Sabar.
16. Sannan a ƙarƙashin \General tab, shigar da sunan uwar garken saitunan da ke gaba kuma zaɓin barin sharhi don kwatanta haɗin.
17. Sa'an nan kuma ayyana bayanin martaba ta hanyar cika waɗannan abubuwa:
- Mai watsa shiri – adireshin IP na uwar garken PostgreSQL.
- Tsarin tashar jiragen ruwa - ba ta dace ba zuwa 5432.
- Tsarin Bayanan Kulawa - Abubuwan da ba za a iya bi ba su zama Postgres. Sunan mai amfani – sunan mai amfani da bayanai. Kuna iya amfani da Postgres.
- Password – kalmar sirri don mai amfani na sama.
Sannan danna Ajiye.
18. Sabuwar uwar garken ya kamata yanzu ta bayyana a ƙarƙashin jerin sabobin kamar yadda aka nuna a cikin hoton da ke gaba.
19. Lokacin da ka danna sunan uwar garken, halayensa ya kamata su yi lodi a ƙarƙashin Dashboard kamar yadda aka nuna a cikin hoton da ke gaba.
Can kuna da shi! Kun sami nasarar shigar da Postgresql 15 da pgAdmin 4 a cikin RHEL 9. Ku same mu ta hanyar bayanan da ke ƙasa don kowane tunani da tambayoyi.
Kuna iya samun ƙarin bayani a cikin takaddun pgAdmin.