Otu esi etinye PostgreSQL na pgAdmin na RHEL 9


Nkọwa: N'isiokwu a, ị ga-amụta ka esi etinye ihe nkesa nchekwa data PostgreSQL 15 na pgAdmin 4 na nkesa RHEL 9 Linux.

PostgreSQL bụ ihe dị ike, nke a na-ejikarị eme ihe, ebe mepere emepe, ọtụtụ nyiwe, yana sistemụ nchekwa data mmekọrịta ihe dị elu mara maka ụkpụrụ ụlọ egosipụtara, ntụkwasị obi, iguzosi ike n'ezi ihe data, njiri mara siri ike, na extensibility.

pgAdmin bụ ihe dị elu, mepere emepe, nke zuru oke, yana njikwa na njikwa webụ maka sava nchekwa data PostgreSQL.

Ka anyị bido…

Kwụpụ 1: Wụnye PostgreSQL na RHEL 9

1. Nke mbụ, gbanyụọ modul PostgreSQL arụnyere site n'ịgbaso iwu dnf na-esonụ.

# dnf -qy module disable postgresql

2. Na-esote, mee ka ụlọ ọrụ PostgreSQL Yum Repository dị ka egosiri.

# dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

3. Ọzọ, wụnye ihe nkesa PostgreSQL 15 na ngwugwu ndị ahịa.

# dnf install -y postgresql15-server

4. Ozugbo echichi zuru ezu, bido nchekwa data PostgreSQL, wee malite ọrụ PostgreSQL-15 wee mee ka ọ malite na-akpaghị aka na boot system. Wee lelee ma ọrụ a na-arụ ọrụ, wee gbanye ya dịka egosiri.

# /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

Kwụpụ 2: Chekwaa ma hazie ọdụ data PostgreSQL

5. Na-esote, chekwaa akaụntụ onye ọrụ Postgres na akaụntụ onye ọrụ nchekwa data. Malite site na ịmepụta paswọọdụ maka akaụntụ onye ọrụ sistemụ Postgres site na iji passwd utility dị ka egosiri.

# passwd postgres

6. Mgbe ahụ gbanwee gaa na akaụntụ sistemụ Postgres wee mepụta paswọọdụ echekwara na siri ike maka onye ọrụ/ọrụ nchịkwa PostgreSQL dị ka ndị a.

# su - postgres
$ psql -c "ALTER USER postgres WITH PASSWORD '[email ';"
$ exit

7. Ugbu a hazie ka ihe nkesa Postgres ga-esi mata ndị ahịa dị ka pgAdmin. Ụzọ nyocha akwadoro gụnyere nkwenye dabere na paswọọdụ nke na-eji otu n'ime ụzọ ndị a: md5, crypt, ma ọ bụ paswọọdụ.

Maka ntuziaka a, anyị ga-ahazi usoro nyocha md5 na faịlụ /var/lib/pgsql/15/data/pg_hba.conf.

# vi /var/lib/pgsql/15/data/pg_hba.conf

Chọta ahịrị ndị a wee gbanwee usoro nnwapụta ka ọ bụrụ md5 ka esi pụta ìhè na nseta ihuenyo.

host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

8. Mgbe ịchekwaa faịlụ ahụ, iji tinye mgbanwe ndị na-adịbeghị anya na nhazi Postgres, malitegharịa ọrụ Postgres.

# systemctl restart postgresql-15

Kwụpụ 3: Wụnye pgAdmin4 na RHEL 9

9. Ugbu a, anyị ga-etinye pgAdmin 4 iji jikwaa nchekwa data PostgreSQL site na webụ. Nke mbu, ikwesiri ime ka ebe nchekwa EPEL na pgAdmin yum nke nwere ufodu dabere.

# 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. Ugbu a wulite cache maka ebe nchekwa pgAdmin na EPEL arụnyere ọhụrụ wee wụnye pgAdmin site na iji iwu ndị a.

# dnf makecache
# yum install pgadmin4

11. Na-esote, malite ọrụ httpd ma mee ka ọ malite ịmalite na boot system, wee lelee ma ọ dị elu ma na-agba ọsọ dị ka egosiri.

# systemctl start httpd
# systemctl enable httpd
# systemctl status httpd

Kwụpụ 4: Na-ahazi pgAdmin 4 na RHEL 9

12. Ihe ngwugwu pgadmin4 na-abịa na ederede nhazi iji hazie ọrụ weebụ pgAdmin, nke ga-emepụta akaụntụ onye ọrụ na-eji nyochaa na interface weebụ, hazie SELinux atumatu na Apache webserver iji tinye ọrụ weebụ 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. Ọ bụrụ na ị nwere ọrụ firewalld na-arụ ọrụ ma na-agba ọsọ, mepee ọdụ ụgbọ mmiri 80 na 443 na firewall iji kwe ka okporo ụzọ gaa na sava weebụ HTTPD dị ka egosiri.

# firewall-cmd --permanent --zone public --add-port 80/tcp
# firewall-cmd --permanent --zone public --add-port 443/tcp
# firewall-cmd --reload

Kwụpụ 5: Ịnweta Interface webụ pgAdmin

14. Iji nweta web interface pgAdmin, mepee ihe nchọgharị wee gaa URL na-esonụ.

http://SERVER_IP/pgadmin4
OR
http://localhost/pgadmin4

Ozugbo interface nbanye ahụ buru ibu, jiri adreesị ozi-e na paswọọdụ ị mepụtara na nzọụkwụ 12 dị n'elu iji banye.

15. Ọzọ, tinye njikọ ọhụrụ site na ịpị \Tinye ọhụrụ nkesa.

16. Mgbe ahụ, n'okpuru taabụ \General, tinye aha nkesa ntọala wee hapụ ikwu okwu iji kọwaa njikọ ahụ.

17. Mgbe ahụ kọwapụta profaịlụ njikọ site na dejupụta ihe ndị a:

  • Onye ọbịa – adreesị IP nke ihe nkesa PostgreSQL.
  • Ọdụ ụgbọ mmiri – adabaghị na 5432.
  • Ebe nchekwa data nchekwa - ihe ndabara kwesịrị ịbụ Postgres.
  • Aha njirimara – aha njirimara nchekwa data. Ị nwere ike iji Postgres.
  • Paswọọdụ – okwuntughe maka onye ọrụ dị n’elu.

Wee pịa Chekwa.

18. Ihe nkesa ọhụrụ kwesịrị ịpụta ugbu a n'okpuru ndepụta nke sava dị ka egosipụtara na nseta ihuenyo na-esonụ.

19. Mgbe ị pịrị aha nkesa, àgwà ya kwesịrị ibu n'okpuru Dashboard dị ka e gosiri na-esonụ nseta ihuenyo.

Ebe ị nwere ya! Ị tinyela Postgresql 15 na pgAdmin 4 nke ọma na RHEL 9. Nweta anyị site na mpempe nzaghachi n'okpuru maka echiche na ajụjụ ọ bụla.

Ị nwere ike ịchọta ozi ndị ọzọ na akwụkwọ pgAdmin.