Otu esi etinye PostgreSQL na pgAdmin4 na Ubuntu 20.04

Ntuziaka a ga-ejegharị gị site na ntuziaka ka ịwụnye PostgreSQL 12 sistemu njikwa nchekwa data dabere na ihe yana pgAdmin4, ngwa ọrụ nchịkwa nchekwa data PostgreSQL na-ejikarị webụ. Anyị ga-egosi otu esi etinye pgAdmin4 kachasị ọhụrụ nke bụ v4.23.

• Nwụnye nkesa nke Ubuntu 20.04
• Ubuntu 20.04 Desktop Ntinye

Ka anyị bido…

Ịwụnye PostgreSQL na Ubuntu 20.04

Banye n'ime sistemụ Ubuntu gị wee melite ngwungwu ngwanrọ sistemụ site na iji iwu dabara adaba.

$ sudo apt update

Ugbu a wụnye ụdị PostgreSQL kachasị ọhụrụ site na ebe nchekwa Ubuntu ndabara.

$ sudo apt install postgresql

N'oge nrụnye, onye nrụnye ga-emepụta ụyọkọ PostgreSQL ọhụrụ (nchịkọta ọdụ data nke otu ihe nkesa ga-ejikwa), si otú ahụ bido nchekwa data. Akwụkwọ ndekọ data ndabara bụ /var/lib/postgresql/12/isi na echekwara faịlụ nhazi na /etc/postgresql/12/isi ndekọ.

Mgbe etinyere PostgreSQL, ị nwere ike ikwenye na ọrụ PostgreSQL na-arụ ọrụ, na-agba ọsọ ma na-enyere ya aka n'okpuru sistemu site na iji iwu systemctl ndị a:

$ sudo systemctl is-active postgresql
$ sudo systemctl is-enabled postgresql
$ sudo systemctl status postgresql

Ọzọkwa, gosi na ihe nkesa Postgresql dị njikere ịnakwere njikọ n'aka ndị ahịa dị ka ndị a:

$ sudo pg_isready

Ịmepụta database na PostgreSQL

Iji mepụta nchekwa data ọhụrụ na PostgreSQL, ị ga-enwerịrị mmemme shei nchekwa data PostgreSQL (psql). Nke mbụ, gbanwee gaa na akaụntụ onye ọrụ sistemụ postgres wee mee iwu psql dị ka ndị a:

$ sudo su - postgres
$ psql
postgres=# 

Ugbu a mepụta nchekwa data ọhụrụ na onye ọrụ site na iji iwu ndị a.

postgres=# CREATE USER tecmint WITH PASSWORD '[email ';
postgres=# CREATE DATABASE tecmintdb;
postgres=# GRANT ALL PRIVILEGES ON DATABASE tecmintdb to tecmint;
postgres=# \q

Na-ahazi nyocha ndị ahịa PostgreSQL

PostgreSQL na-eji nkwenye ndị ahịa kpebie nke akaụntụ onye ọrụ nwere ike jikọọ na ọdụ data nke ndị ọbịa na nke a na-achịkwa site na ntọala na faịlụ nhazi njirimara ndị ahịa, nke dị na Ubuntu dị na /etc/postgresql/12/main/pg_hba.conf.

Mepee faịlụ a site na iji ndezi ederede ọkacha mmasị gị dị ka egosiri.

$ sudo vim /etc/postgresql/12/main/pg_hba.conf

PostgreSQL na-eji ọtụtụ ụdị ụzọ njirimara ndị ahịa gụnyere ọgbọ, njirimara, paswọọdụ, na md5 (gụọ akwụkwọ PostgreSQL 12 maka nkọwa zuru ezu nke usoro ọ bụla).

md5 bụ nke kacha echekwabara na akwadoro n'ihi na ọ chọrọ ka onye ahịa weta paswọọdụ hashed ugboro abụọ MD5 maka nyocha. Yabụ, hụ na ndenye dị n'okpuru nwere md5 dị ka usoro n'okpuru:

host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                	md5

Mgbe ịmechara mgbanwe na faịlụ nhazi njirimara ndị ahịa, ị ga-achọ ịmalitegharị ọrụ PostgreSQL.

$ sudo systemctl restart postgresql

Ịwụnye pgAdmin4 na Ubuntu

pgAdmin4 adịghị na ebe nchekwa Ubuntu. Anyị kwesịrị ịwụnye ya na ebe nchekwa pgAdmin4 APT. Malite site na ịtọ ntọala ebe nchekwa. Tinye igodo ọha maka ebe nchekwa wee mepụta faịlụ nhazi nchekwa.

 
$ curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
$ sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

Wee tinye pgAdmin4,

$sudo apt install pgadmin4

Iwu a dị n'elu ga-etinye ọtụtụ ngwugwu achọrọ gụnyere Apache2 webserver iji jeere ngwa pgadmin4-web na ọnọdụ weebụ.

Ozugbo echichi ahụ mechara, mee ihe ederede ntọala webụ nke na-ebu ngwungwu ọnụọgụ abụọ pgdmin4, iji hazie sistemụ ka ọ na-agba ọsọ na ọnọdụ weebụ. A ga-akpali gị ịmepụta pgAdmin4 nbanye email na paswọọdụ dị ka egosiri na nseta ihuenyo dị n'okpuru.

Edemede a ga-ahazi Apache2 iji jeere ngwa webụ pgAdmin4 nke gụnyere ime ka modul WSGI na ịhazi ngwa pgAdmin ka ọ gbagoro na pgadmin4 na sava weebụ ka ị nwee ike nweta ya na:

http://SERVER_IP/pgadmin4

Ọ na-amalitekwa ọrụ Apache2 iji tinye mgbanwe ndị na-adịbeghị anya.

Cheta iji adreesị ozi-e gị dochie [email echebe] wee tọọ paswọọdụ echekwara siri ike:

$ sudo /usr/pgadmin4/bin/setup-web.sh

Ịnweta Interface Weebụ pgAdmin4

Iji nweta interface ngwa webụ pgAdmin4, mepee ihe nchọgharị weebụ, wee jiri adreesị a ka ịnyagharịa:

http://SERVER_IP/pgadmin4

Ozugbo ibe nbanye ahụ buru ibu, tinye adreesị email na paswọọdụ ị mepụtara na ngalaba gara aga ka ị na-ahazi pgAdmin4 ka ọ na-agba ọsọ na ọnọdụ weebụ.

Mgbe ịbanyechara nke ọma, ị ga-abanye na dashboard ngwa webụ pgAdmin4. Iji jikọọ na ihe nkesa, pịa Tinye New Server dị ka egosipụtara na nseta ihuenyo na-esonụ.

Na-esote, tinye njikọ na ntọala izugbe (Aha, otu nkesa, na ikwu okwu). Wee pịa Njikọ dị ka agbapụtara na nseta ihuenyo na-esonụ.

Na-esote, tinye PostgreSQL nchekwa data nkesa aha nnabata/adreesị, Port number (hapụ 5432 iji ndabara), họrọ nchekwa data nchekwa (nke kwesịrị ịbụ postgres), tinye aha njirimara na paswọọdụ nchekwa data.

Ọ bụrụ na nzere ịnweta nchekwa data dị mma yana nhazi nyocha nke ihe nkesa-onye ahịa dịkwa, pgAdmin4 kwesịrị ijikọ nke ọma na sava nchekwa data.

Ọ gwụla! Maka ozi ndị ọzọ, hụ akwụkwọ pgAdmin 4. Cheta ịkọrọ anyị echiche gị site na ngalaba nkọwa n'okpuru.