Otu esi etinye PostgreSQL na RHEL 8

PostgreSQL, nke a makwaara dị ka Postgres, bụ usoro njikwa nchekwa data dị ike, mepere emepe nke na-eji ma na-agbasa asụsụ SQL yana ọtụtụ atụmatụ na-echekwa ma na-ebuwanye ibu ọrụ data kachasị mgbagwoju anya.

Ụgbọ mmiri PostgreSQL nwere ọnụ ọgụgụ njirimara ezubere iji nyere ndị mmemme aka ịmepụta ngwa, ndị nchịkwa iji chekwaa iguzosi ike n'ezi data na ịmepụta gburugburu ebe mmejọ na-adịghị mma, ma nyere gị aka ijikwa data gị n'agbanyeghị nnukwu ma ọ bụ obere dataset.

Na mgbakwunye na ịbụ onye nweere onwe ya na ebe mepere emepe, PostgreSQL nwere ike ịpụpụ nke ukwuu. Dịka ọmụmaatụ, ịnwere ike ịgbakwunye ụdị data nke gị, mepụta ọrụ omenala, ọbụna dee koodu site na asụsụ mmemme dị iche iche na-enweghị achịkọta nchekwa data gị!

  1. RHEL 8 nwere Nwụnye Opekempe
  2. RHEL 8 nwere ndebanye aha RedHat
  3. RHEL 8 nwere Adreesị IP Static

N'isiokwu a, anyị ga-akọwa otu esi etinye, chekwaa na hazie usoro nlekọta nchekwa data PostgreSQL na nkesa RHEL 8 Linux.

Ịwụnye ngwugwu PostgreSQL

1. A na-etinye PostgreSQL na nchekwa ndabara nke RHEL 8, a pụkwara itinye ya site na iji iwu dnf na-esonụ, nke ga-etinye ihe nkesa PostgreSQL 10, ọba akwụkwọ na ọnụọgụ ndị ahịa.

# dnf install @postgresql

Mara: Iji wụnye ngwugwu PostgreSQL 11 na sistemụ RHEL 8 gị, ịkwesịrị ịwụnye ebe nchekwa PostgreSQL RPM, nke nwere ọtụtụ ngwugwu dị iche iche dị ka sava PostgreSQL, ọnụọgụ abụọ nke ndị ahịa, na mgbakwunye ndị ọzọ.

# dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# dnf update
# dnf install postgresql11-server postgresql11  postgresql11-contrib

Bido ebe nchekwa data PostgreSQL

2. Ozugbo i tinyechara ngwugwu PostgreSQL, nzọụkwụ ọzọ bụ ịmalite ụyọkọ nchekwa data PostgreSQL ọhụrụ site na iji /usr/bin/postgresql-setup utility, dị ka ndị a.

# /usr/bin/postgresql-setup --initdb

3. Ugbu a na-ebido ụyọkọ PostgreSQL, ịkwesịrị ịmalite ọrụ PostgreSQL, maka ugbu a, mee ya ka ọ malite na-amalite na boot boot na nyochaa ọnọdụ ya site na iji usoro systemctl.

# systemctl start postgresql
# systemctl enable postgresql
# systemctl status postgresql

Chekwaa ma hazie ọdụ data PostgreSQL

Na ngalaba a, anyị ga-egosi otu esi echekwa akaụntụ onye ọrụ Postgres yana akaụntụ onye ọrụ nchịkwa. Mgbe ahụ, anyị ga-ekpuchi otu esi ahazi PostgreSQL, karịsịa ka esi edozi njirimara ndị ahịa.

4. Mepụta paswọọdụ maka akaụntụ onye ọrụ sistemụ postgres site na iji passwd utility dị ka ndị a.

# passwd postgres

5. Na-esote, gbanwee gaa na akaụntụ onye ọrụ postgres ma chekwaa akaụntụ onye ọrụ nchekwa data PostgreSQL site na ịmepụta paswọọdụ maka ya (cheta ịtọ paswọọdụ siri ike na echekwara).

$ su - postgres
$ psql -c "ALTER USER postgres WITH PASSWORD 'adminpasswdhere123';"

6. Enwere ike ịchọta faịlụ nhazi PostgreSQL dị iche iche na /var/lib/pgsql/data/ koodu> ndekọ. Iji lelee usoro ndekọ aha, ị nwere ike iji osisi (wụnye ya site na iji dnf install tree) iwu.

# tree -L 1 /var/lib/pgsql/data/

Isi faịlụ nhazi ihe nkesa bụ /var/lib/pgsql/data/postgresql.conf. Enwere ike ịhazi njirimara onye ahịa site na iji /var/lib/pgsql/data/pg_hba.conf.

7. Ọzọ, ka anyị leba anya ka esi ahazi njirimara ndị ahịa. Sistemụ nchekwa data PostgreSQL na-akwado ụdị nyocha dị iche iche gụnyere nyocha dabere na paswọọdụ. N'okpuru njirimara dabere na paswọọdụ, ịnwere ike iji otu n'ime ụzọ ndị a: md5, crypt, ma ọ bụ paswọọdụ (na-eziga paswọọdụ na ederede doro anya).

Ọ bụ ezie na ụzọ njirimara paswọọdụ dị n'elu na-arụ ọrụ n'otu ụzọ ahụ, nnukwu ọdịiche dị n'etiti ha bụ: otu esi echekwa paswọọdụ onye ọrụ (na ihe nkesa) wee ziga ya na njikọ ahụ, mgbe onye ọrụ banyere.

Iji gbochie imirikiti okwuntughe site n'aka ndị na-awakpo ma zere ịchekwa okwuntughe na sava na ederede dị larịị, a na-atụ aro ka iji md5 dịka egosiri. Ugbu a mepee faịlụ nhazi njirimara onye ahịa.

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

Ma chọọ ahịrị ndị a ma gbanwee usoro nyocha ka md5.

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

8. Ugbu a malitegharịa ọrụ Postgres iji tinye mgbanwe ndị na-adịbeghị anya na nhazi ahụ.

# systemctl reload postgresql

9. N'oge a, ntinye ihe nkesa nchekwa data PostgreSQL dị ugbu a. Ị nwere ike ịgbanwe gaa na akaụntụ postgres wee malite ịrụ ọrụ na PostgreSQL.

# su - postgres
$ psql

Ị nwere ike ịgụ akwụkwọ PostgreSQL gọọmentị (cheta na ịhọrọ docs maka ụdị ị rụnyere) iji ghọta ka PostgreSQL si arụ ọrụ yana otu esi eji ya maka ịmepụta ngwa.

Nke ahụ bụ ihe niile ugbu a! N'ime ntuziaka a, anyị egosila otu esi etinye, chekwaa na hazie usoro nchịkwa nchekwa data PostgreSQL na RHEL 8. Cheta na ị nwere ike ịnye anyị nzaghachi site na ụdị nzaghachi n'okpuru.