Yadda ake Shigar PostgreSQL da pgAdmin a cikin CentOS 8
PostgreSQL ƙaƙƙarfan abu ne, wanda aka yi amfani da shi sosai, tushen buɗewa, dandamali da yawa, kuma ingantaccen tsarin tsarin haɗin bayanai wanda aka sanshi da ingantaccen tsarin gini, amintacce, amincin bayanai, tsayayyar fasalin fasali, da ƙari.
pgAdmin ingantacce ne, buɗaɗɗen tushe, mai cikakken fasali, da kayan gudanarwar yanar gizo da kayan aikin gudanarwa don uwar garken gidan bayanan PostgreSQL.
A cikin wannan labarin, zaku koyi yadda ake girka uwar garken gidan yanar gizo na PostgreSQL 12 da pgAdmin 4 a cikin rarraba CentOS 8 Linux.
Mataki 1: Shigar PostgreSQL akan CentOS 8
1. Na farko, musaki ginannen tsarin PostgreSQL ta hanyar aiwatar da umarnin dnf mai zuwa.
# dnf -qy module disable postgresql
2. Na gaba, bawa hukuma PostgreSQL Yum Wurin adana kamar yadda aka nuna.
# dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
3. Na gaba, shigar da sabar PostgreSQL 12 da kunshin abokin ciniki.
# dnf install postgresql12 postgresql12-server
4. Da zarar an gama girkawa, fara bayanan PostgreSQL, sai a fara aikin PostgreSQL-12 sannan a bashi damar fara aiki kai tsaye a boot system. Sannan duba idan sabis ɗin yana aiki kuma yana aiki, kuma an kunna shi kamar yadda aka nuna.
# /usr/pgsql-12/bin/postgresql-12-setup initdb # systemctl start postgresql-12 # systemctl enable postgresql-12 # systemctl status postgresql-12 # systemctl is-enabled postgresql-12
Mataki na 2: Amintacce kuma Sanya bayanan bayanan PostgreSQL
5. Na gaba, amintar da asusun mai amfani na Postgres da kuma asusun mai amfani na gudanarwa. Fara ta ƙirƙirar kalmar wucewa don asusun mai amfani da tsarin Postgres ta amfani da passwd mai amfani kamar yadda aka nuna.
# passwd postgres
6. Sannan ka canza zuwa tsarin tsarin Postgres ka kuma kirkiro amintaccen kuma kalmar sirri mai karfi don mai amfani da matsayin mai amfani na gudanarwa na PostgreSQL/matsayin kamar haka.
# su - postgres $ psql -c "ALTER USER postgres WITH PASSWORD '[email ';" $ exit
7. Yanzu saita yadda sabar Postgres zata tabbatar da kwastomomi kamar su pgAdmin. Hanyoyin ingantaccen hanyoyin sun haɗa da ingantaccen kalmar sirri wanda ke amfani da ɗayan waɗannan hanyoyin: md5, crypt, ko kalmar wucewa.
Don wannan jagorar, zamu saita hanyar tabbatar da md5 a cikin fayil /var/lib/pgsql/12/data/pg_hba.conf.
# vi /var/lib/pgsql/12/data/pg_hba.conf
Nemo layuka masu zuwa kuma canza hanyar tabbatarwa zuwa md5 kamar yadda aka haskaka a cikin sikirin.
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 daidaitawar Postgres, sake kunna sabis ɗin Postgres.
# systemctl restart postgresql-12
Mataki na 3: Shigar pgAdmin4 a cikin CentOS 8
9. Yanzu zamu girka pgAdmin 4 don sarrafa bayanan PostgreSQL daga yanar gizo. Da farko, kuna buƙatar kunna wuraren ajiya na EPEL da pgAdmin Yum waɗanda ke ƙunshe da wasu abubuwan dogaro.
# dnf install epel-release # dnf install -y https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm
akan Fedora Linux, gudu:
# dnf install -y https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-fedora-repo-1-1.noarch.rpm
10. Na gaba, kuna buƙatar cire wuraren aikin PostgreSQL na yum domin shigar da sabon salo na pgAdmin daga pgAdmin official yum repository.
# dnf remove -y pgdg-redhat-repo
11. Yanzu gina cache don sabbin shigar pgAdmin da wuraren ajiyar EPEL kuma girka pgAdmin ta amfani da wadannan dokokin.
# dnf makecache # yum install pgadmin4
12. Na gaba, fara hidimar httpd saika bashi damar farawa da kansa a system boot, saika bincika idan yana sama kuma yana aiki kamar yadda aka nuna.
# systemctl start httpd # systemctl enable httpd # systemctl status httpd
Mataki na 4: Saitin pgAdmin 4 a CentOS 8
13. Kunshin pgadmin4 ya zo tare da rubutaccen rubutun don daidaita sabis ɗin yanar gizon pgAdmin, wanda zai ƙirƙiri asusun mai amfani da aka yi amfani da shi don tabbatarwa a cikin haɗin yanar gizon, saita manufofin SELinux da Apache webserver don tura sabis ɗin yanar gizon 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
14. Idan kana da sabis na kashe gobara da kunnawa, buɗe mashigai 80 da 443 a cikin Tacewar zaɓi don ba da damar zirga-zirga zuwa sabar yanar gizo ta 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 na 5: Samun damar Intanet na pgAdmin
15. Don samun damar shiga yanar gizo na pgAdmin, buɗe burauzar kuma yi amfani da URL mai zuwa.
http://SERVER_IP/pgadmin4 OR http://localhost/pgadmin4
Da zarar login shiga ya shiga, yi amfani da adreshin imel da kalmar sirri da kuka ƙirƙira a mataki na 15 a sama don shiga.
16. Na gaba, ƙara sabon haɗin sabar ta danna kan\"Newara Sabon Sabar".
17. Sannan a karkashin shafin "" Gaba ɗaya ", shigar da sunan uwar garken saitunan masu zuwa kuma a zaɓi barin tsokaci don bayyana haɗin.
18. Sa'an nan kuma ayyana bayanan haɗin yanar gizon ta hanyar cika abubuwa masu zuwa:
- Mai watsa shiri - mai masaukin baki/adireshin IP na uwar garken PostgreSQL.
- Port - tsoffin abubuwa zuwa 5432.
- Database na Kulawa - tsoffin bayanan su zama Postgres.
- Sunan mai amfani - sunan mai amfani na bayanai. Kuna iya amfani da Postgres.
- Kalmar wucewa - kalmar sirri don mai amfani da ke sama.
Sannan danna Ajiye.
19. Sabuwar sabar ya kamata yanzu ta bayyana a ƙarƙashin jerin sabobin kamar yadda aka haskaka a cikin hoton da ke tafe.
20. Lokacin da ka latsa sunan sabar, ya kamata halayensa suyi lodin ƙarƙashin Dashboard kamar yadda aka nuna a cikin hoton da ke gaba.
A can kuna da shi! Kun yi nasarar shigar da Postgresql 12 da pgAdmin 4 a cikin CentOS 8. Ku isa gare mu ta hanyar fom ɗin da ke ƙasa don kowane tunani da tambayoyi. Kuna iya samun ƙarin bayani a cikin pgAdmin takardun.