Momwe mungakhalire PostgreSQL pa Ubuntu 18.04 LTS Bionic Beaver ndi zotumphukira?

PostgreSQL ndi njira yokhazikitsira zinthu zofananira, yamphamvu, yotsogola komanso yogwira ntchito kwambiri, PostgreSQL ndi Gwero laulere komanso lotseguka lotulutsidwa pansi pa chiphaso cha PostgreSQL, ofanana ndi BSD kapena MIT.

Zimagwiritsa ntchito ndikuwongolera chilankhulo cha SQL, komanso ziwonetsero zambiri posungira ndi kasungidwe kotetezedwa. Ndizothandiza, zodalirika, komanso zotheka kusamalira ma voliyumu ambiri ndikupanga magwiridwe antchito ndi malo olekerera zolakwika, ndikuwonetsetsa kukhulupirika kwakukulu.

PostgreSQL imakhudzanso kwambiri ndi mawonekedwe monga ma index, amabwera ndi ma API kuti muthe kupanga mayankho anu kuti muthane ndi zovuta zosunga deta yanu.

Monga ntchito zina zambiri zotseguka, Kukula kwa PostgreSQL sikuyendetsedwa ndi kampani imodzi kapena munthu, koma imayendetsedwa ndi gulu la opanga omwe amagwira ntchito modzipereka, modzipereka, momasuka kapena kuthandizidwa ndi mabungwe azamalonda.

Dera lino limatchedwa PGDG (PostgreSQL Global Development Group).

Kuika PostgreSQL ku Ubuntu 18.04 LTS ndi zotumphukira

Kuti tithe kukhazikitsa chida ichi pamakina athu, tiyenera kupanga fayilo mu /etc/apt/source.list.d/pgdg.list yomwe imasungira kasungidwe kake.

Titsegula terminal ndi Ctrl + Alt + T ndipo tichita mmenemo:

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

Timatumiza chinsinsi pagulu

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

Y tikupitiliza kukhazikitsa pulogalamuyi ndi:

sudo apt update

sudo apt install postgresql-10 pgadmin4

Ndizomwezo, tidzakhala ndi PostgreSQL yoyikidwa pamakina athu.

Ntchito yothandizira iyenera kuchitidwa pokhapokha titaiyika, titha kutsimikizira izi potsatira lamulo ili:

sudo systemctl status postgresql.service

Momwe mungagwiritsire ntchito PostgreSQL pa Ubuntu 18.04 LTS ndi zotumphukira?

Mu PostgreSQL, kutsimikizira kasitomala kumayang'aniridwa ndi fayilo yosintha /etc/postgresql/10/main/pg_hba.conf.

Njira yotsimikizika ndiyo "anzawo" kwa woyang'anira nkhokwe, zomwe zikutanthauza kuti imalandira dzina la ogwiritsa ntchito kachitidwe kasitomala ndikuwunika ngati ikugwirizana ndi dzina logwiritsa ntchito nkhokwe yolola kuti izitha kulumikizidwa, kulumikizana kwanuko.

Fayiloyi ingasinthidwe malinga ndi zosowa zanu.

Chilichonse chikakonzedwa, akauntiyi ikhoza kupezeka ndi lamulo ili:

sudo -i -u postgres

psql

postgres=#

Itha kupezekanso ndi lamuloli mwachindunji, osafunikira koyamba kupeza akaunti ya postgres, chifukwa ichi tiyenera kuchita:

sudo -i -u postgres psql

Kutuluka timangopanga:

postgres=# \q

En PostgreSQL, gawo ndi chilolezo chimagwiritsidwa ntchito, kuti maudindo ndi zinthu zapadziko lonse lapansi zomwe zimatha kupeza magawo onse amgulu (ndi mwayi woyenera).

Udindowu ndiwosiyana kwambiri ndi ogwiritsa ntchito pamachitidwe opangira, ngakhale zili bwino kukhalabe makalata pakati pawo.

Poyambitsa dongosolo la database, kukhazikitsa kwatsopano nthawi zonse kumakhala ndi gawo lokonzedweratu.

Momwe mungapangire wosuta ku PostgreSQL?

Para kukhazikitsidwa kwa gawo latsopano mu database yomwe timangofunika kuchita lamulo lotsatirali, momwe timangofunika m'malo mwa "wosuta" ndi dzina lomwe tikufuna kutipatsa:

postgres=# CREATE ROLE usuario;

Tsopano ngati tikufuna kuwonjezera malingaliro olowera paudindo wa wogwiritsa ntchito, tiyenera kuwonjezera izi:

postgres=#CREATE ROLE usuario LOGIN;

Kapena itha kupangidwanso motere

postgres=#CREATE USER usuario;           

Popanga izi, Tiyenera kupereka mawu achinsinsi omwe titha kutsimikizira kuti ndi njira yotsimikizika potero amapereka achinsinsi obisika mukalumikiza ku database.

Titha kuchita izi polemba lamulo ili:

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

Pomaliza mutha kupeza maphunziro osiyanasiyana ndikuthandizira m'mafamu ambiri ndi masamba omwe amagawana nawo zomwe zili pakugwiritsa ntchito ndi kuwongolera PostgreSQL.