Otu esi etinye PostgreSQL na Rocky Linux na AlmaLinux

PostgreSQL bụ sistemu njikwa nchekwa data nchekwa data mepere emepe (RDBMS) na-ewu ewu nke dị kemgbe ihe karịrị afọ 30. Ọ na-enye nkwado asụsụ SQL nke a na-eji maka ijikwa ọdụ data yana ịrụ ọrụ CRUD (Mepụta Hichapụ Mmelite Ọgụgụ).

[I nwekwara ike ịmasị gị: Weebụsaịtị 10 bara uru maka ịmụ Sistemụ nchekwa data PostgreSQL]

PostgreSQL enwetala onwe ya aha siri ike maka ike ya, mgbanwe na arụmọrụ ya. Ọ bụ ebe nchekwa data izizi maka ọtụtụ ngwa weebụ na nyocha. Ndị dike zuru ụwa ọnụ na-adabere na PostgreSQL gụnyere Spotify, Instagram, Trivago, Uber, na Netflix.

N'oge edere ntuziaka a, ụdị kachasị ọhụrụ bụ PostgreSQL 13 na n'isiokwu a, anyị na-egosi otu esi etinye PostgreSQL na Rocky Linux na AlmaLinux.

Kwụpụ 1: Tinye ebe nchekwa PostgreSQL

Ụdị ndabara nke PostgreSQL na ebe nchekwa Appstream bụ PostgreSQL 10.

$ sudo dnf module list postgresql

Site na mmepụta, anyị nwere ike ịhụ nke ọma na iyi PostgreSQL ndabara - nke akara [ d ] bụ PostgreSQL 10.

Iji wụnye ụdị PostgreSQL kachasị ọhụrụ, anyị kwesịrị, nke mbụ, tinye ebe nchekwa PostgreSQL YUM na sistemụ anyị dịka egosiri.

$ sudo dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Kwụpụ 2: Wụnye PostgreSQL 13 na Rocky Linux

Site na ebe nchekwa PostgreSQL YUM dị, nzọụkwụ ọzọ bụ imelite nchekwa nchekwa Linux Rocky. Naanị gbaa iwu a ka imezu nke a

$ sudo dnf update

Na-esote, gbanyụọ modul ndabara nke, dị ka anyị hụrụ na mbụ, bụ PostgreSQL 10.

$ sudo dnf -qy module disable postgresql

Ozugbo modul ndabara kwụsịrị, gaa n'ihu ma wụnye PostgreSQL 13 ahịa na ihe nkesa dị ka egosiri.

$ sudo dnf install postgresql13 postgresql13-server

Pịnye Y wee kụọ ENTER oge ọ bụla a kpaliri gị ibubata igodo GPG.

Iwu a na-etinye ihe nkesa PostgreSQL na onye ahịa n'akụkụ ndị ọzọ dabere. Na njedebe nke nrụnye, ị ga-egosipụta nsonaazụ nke na-egosi na etinyere ngwugwu niile nke ọma.

Ị nwere ike kwado ụdị nke PostgreSQL arụnyere site na iji iwu:

$ psql -V

psql (PostgreSQL) 13.4

Kwụpụ 3: Malite na Kwado Ọrụ PostgreSQL

Ozugbo etinyere PostgreSQL, nzọụkwụ ọzọ bụ ịmalite ọrụ ahụ wee hụ na ihe nkesa nchekwa data na-agba ọsọ. Mana tupu nke ahụ, mee ka PostgreSQL malite na oge buut.

$ sudo systemctl enable postgresql-13

Mgbe nke ahụ gasịrị, malite ihe nkesa nchekwa data PostgreSQL.

$ sudo systemctl start postgresql-13

Iji gosi na PostgreSQL na-arụ ọrụ, mebie:

$ sudo systemctl status postgresql-13

Site na mmepụta, o doro anya na ihe nkesa nchekwa data anyị na-agba ọsọ dịka anyị ga-atụ anya ya.

Kwụpụ 4: Malite ebe nchekwa data PostgreSQL

Tupu anyị aga n'ihu, anyị kwesịrị ibido nchekwa data initdb nke na-ahụ maka ịmepụta ụyọkọ PostgreSQL ọhụrụ. Ụyọkọ bụ otu ma ọ bụ nchịkọta ọtụtụ ọdụ data nke otu ụyọkọ na-achịkwa.

Yabụ, ka ibido nchekwa data, mee iwu:

$ sudo /usr/pgsql-*/bin/postgresql-*-setup initdb

Kwụpụ 5: Jikọọ na ọdụ data PostgreSQL

Mgbe etinyere PostgreSQL, a na-emepụta onye ọrụ nchekwa data a na-akpọ postgres. Ọ dịghị achọ nyocha ọ bụla, ya mere, ọ dịghị mkpa ka ịbanye na paswọọdụ. Na nzọụkwụ ọzọ, anyị ga-emepụta paswọọdụ maka onye ọrụ postgres maka ihe nchekwa.

Maka ugbu a, anyị ga-abanye na shei PostgreSQL site na mbugharị na onye ọrụ postgres.

$ sudo su - postgres

Ozugbo ị gbanwere na onye ọrụ postgresql, nweta ngwa ngwa nchekwa data site na iji iwu:

$ psql

Kwụpụ 6: Tọọ paswọọdụ maka onye ọrụ Postgres

N'ikpeazụ, anyị ga-eji paswọọdụ chekwaa onye ọrụ postgres maka ihe nchekwa. Dịka onye ọrụ sudo, mee iwu a:

$ sudo passwd postgres

Nye paswọọdụ ọhụrụ wee gosi. Ugbu a banye ọzọ dị ka onye ọrụ Postgres.

$ su - postgres

Ma gbaa iwu egosiri.

psql -c "ALTER USER postgres WITH PASSWORD 'your-password';"

Oge ọzọ ị nwara iji onye ọrụ postgres banye, a ga-achọrọ ka ị mata ya.

$ su - postgres

Na nke ahụ bụ naanị banyere ya. Anyị ejegharịla gị site na ntinye nke PostgreSQL na Rocky Linux na AlmaLinux