Yadda ake girka PostgreSQL akan Ubuntu 18.04 LTS Bionic Beaver da abubuwan banbanci?

PostgreSQL tsari ne na daidaitaccen tsarin kula da bayanai, mai iko, ci gaba da aiki sosai, PostgreSQL ne kyauta da budewa da aka saki a ƙarƙashin lasisin PostgreSQL, kama da BSD ko MIT.

Yana amfani da inganta harshen SQL, tare da adadi mai yawa na fasali don amintaccen adana bayanai da gudanarwa. Yana da inganci, abin dogaro, kuma mai iya daidaitawa don sarrafa babban juzu'i da ƙirƙirar yanayin kamfanoni da yanayin haƙuri, yayin tabbatar da cikakken ƙimar bayanai.

PostgreSQL kuma ana iya bayyana shi da fasali kamar fihirisa, sun zo da APIs don haka za ku iya inganta hanyoyinku don warware matsalolin ajiyar bayananku.

Kamar sauran ayyukan buɗe ido, Ci gaban PostgreSQL ba ya gudana ta kamfani ɗaya ko mutum, amma ƙungiyar masu haɓakawa ce ke gudanar da shi waɗanda ke aiki a cikin rashin son kai, son kai, kyauta ko ƙungiyoyin kasuwanci ke tallafawa.

Wannan al'umma ana kiranta PGDG (PostgreSQL Global Development Group).

Shigar PostgreSQL akan Ubuntu 18.04 LTS da abubuwan banbanci

Don shigar da wannan kayan aikin akan tsarinmu, dole ne mu ƙirƙiri fayil a ciki /etc/apt/sources.list.d/pgdg.list wanda ke adana kayan ajiyar ajiya.

Za mu bude tashar tare da Ctrl + Alt + kuma za mu aiwatar a ciki:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

sudo apt install wget ca-certificates

Muna shigo da madannin jama'a

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add –

Y mun ci gaba shigar da aikace-aikacen a cikin tsarinmu tare da:

sudo apt update

sudo apt install postgresql-10 pgadmin4

Kuma hakane, zamu sanya PostgreSQL akan tsarinmu.

Ya kamata a aiwatar da aikin aikace-aikacen ta atomatik bayan mun girka shi, za mu iya tabbatar da hakan ta hanyar aiwatar da wannan umarnin:

sudo systemctl status postgresql.service

Yaya ake amfani da PostgreSQL akan Ubuntu 18.04 LTS da abubuwan banƙyama?

A cikin PostgreSQL, Fayil ɗin daidaitawa yana sarrafa ikon tabbatar da abokin ciniki /etc/postgresql/10/main/pg_hba.conf.

Hanyar tantance bayanan tsoho ita ce "tsara" ga mai kula da bayanai, wanda ke nufin cewa yana karɓar sunan mai amfani na tsarin tsarin abokin ciniki kuma yana bincika idan ya dace da sunan mai amfani da bayanan da aka nema don ba da damar shiga, don haɗin gida.

Za'a iya gyara wannan fayil ɗin daidaitawa gwargwadon buƙatunku.

Da zarar an daidaita komai, ana iya samun damar asusun asusun tare da umarnin mai zuwa:

sudo -i -u postgres

psql

postgres=#

Hakanan za'a iya samun damar ta tare da wannan sauran umarnin kai tsaye, ba tare da fara isa ga asusun postgres ba, don wannan kawai zamu aiwatar:

sudo -i -u postgres psql

Don fita kawai muna aiwatarwa:

postgres=# \q

En PostgreSQL, ana amfani da tsarin aiki da izini, inda Matsayi abubuwa ne na duniya waɗanda zasu iya samun damar duk bayanan tarin jama'a (tare da abubuwan da suka dace).

Matsayin ya banbanta da masu amfani a matakin tsarin aiki, kodayake yana da sauƙi don kula da wasiƙa tsakanin su.

Don fara aiwatar da tsarin tattara bayanai, kowane sabon shigarwa koyaushe yana ƙunshe da sanannen rawar.

Yaya ake ƙirƙirar mai amfani a PostgreSQL?

para ƙirƙirar sabon matsayi a cikin rumbun adana bayanai kawai zamu aiwatar umarni mai zuwa, wanda kawai zamu maye gurbin "mai amfani" da sunan da muke son sanyawa:

postgres=# CREATE ROLE usuario;

Yanzu idan muna so mu ƙara sifofin shiga don rawar mai amfani, dole ne kawai mu ƙara da masu zuwa:

postgres=#CREATE ROLE usuario LOGIN;

Ko kuma ana iya ƙirƙirar shi kamar haka

postgres=#CREATE USER usuario;           

Ta ƙirƙirar wannan, dole ne mu sanya kalmar sirri wanda za mu iya tabbatar da hanyar tantancewa game da shi samar da rufaffen kalmar sirri a lokacin da a haɗa zuwa database.

Zamu iya yin hakan ta hanyar buga umarni mai zuwa:

postgres=#CREATE ROLE usuario PASSWORD 'contraseña'

A ƙarshe zaku iya samun koyarwa daban-daban da taimako a cikin majallu da yawa kuma shafukan yanar gizo inda suke raba abun ciki akan amfani da gudanarwa na PostgreSQL.