Maitiro ekuisa PostgreSQL paUbuntu 18.04 LTS Bionic Beaver uye zvigadzirwa?

PostgreSQL chinhu chinotarisana nehukama hwehukama sisitimu manejimendi, ine simba, yepamusoro uye yepamusoro-kuita, PostgreSQL iri yemahara uye yakavhurwa sosi yakaburitswa pasi pePostgreSQL rezinesi, yakafanana neBSD kana MIT.

Zvishandiso uye inovandudza mutauro weSQL, pamwe nenhamba huru yezvinhu yekuchengetedzwa kwedata rakachengeteka uye manejimendi. Iyo inoshanda, yakavimbika, uye inokwenenzverwa pakubata yakawanda mavhoriyamu uye kugadzira bhizinesi-giredhi uye mhosho-inoremerera nharaunda, uku ichiona yakakwira data kuvimbika.

PostgreSQL iri zvakare rinotambanuka zvikuru nemaficha sema indexes, ivo vanouya nemaAPIs kuti iwe ugone kugadzira yako wega mhinduro kugadzirisa ako data rekuchengetedza matambudziko

Kunge mamwe akawanda akavhurwa sosi mapurojekiti, PostgreSQL budiriro haina kutarisirwa nekambani imwe kana munhu, asi inomhanya nharaunda yevagadziri vanoshanda mukuzvipira, kushaya hanya, vakasununguka kana kutsigirwa nemasangano ezvokutengeserana.

Iyi nharaunda inonzi iyo PGDG (PostgreSQL Global Development Group).

PostgreSQL kuisirwa paUbuntu 18.04 LTS uye zvigadzirwa

Kuti tigoisa chishandiso pane edu masisitimu, isu tinofanirwa kugadzira faira mu /etc/apt/source.list.d/pgdg.list iyo inochengeta iyo repository kumisikidzwa.

Tiri kuzovhura terminal neCtrl + Alt + T uye isu tichaita mairi:

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

Isu tinopinza kiyi yeruzhinji

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

Y isu tinoenderera mberi nekuisa iko kunyorera mune yedu system ne:

sudo apt update

sudo apt install postgresql-10 pgadmin4

Uye ndizvozvo, tichava nePostgreSQL yakaiswa pane yedu system.

Basa rekushandisa rinofanirwa kuitiswa roga mushure mekuzviisa, tinogona kuona izvi nekungoita unotevera kuraira:

sudo systemctl status postgresql.service

Mashandisiro ekushandisa PostgreSQL paUbuntu 18.04 LTS uye zvigadzirwa?

MuPostgreSQL, mutengi kusimbiswa kunodzorwa neyakagadziriswa faira /etc/postgresql/10/main/pg_hba.conf.

Iyo yekusimbisa yekusimbisa nzira ndeye "peer" yemukuru wedhatabhesi, zvinoreva kuti inogamuchira zita remushandisi reiyo system mutengi inoshanda system uye rinotarisa kana ichienderana neiri kukumbirwa zita rezita remushandisi kubvumidza kuwana, kwekubatana kwenzvimbo.

Iyi faira yekugadzirisa inogona kugadziriswa zvinoenderana nezvamunoda.

Kana zvese zvinhu zvagadziriswa, iyo account account inogona kuwanikwa nemutemo unotevera:

sudo -i -u postgres

psql

postgres=#

Inogona zvakare kuwanikwa neumwe uyu murairo zvakananga, pasina kutanga watanga kuwana iyo postgres account, yeizvi isu tinofanirwa chete kuita:

sudo -i -u postgres psql

Kuti tibude isu chete tinoita:

postgres=# \q

En PostgreSQL, basa uye mvumo sisitimu inoshandiswa, kupi mabasa zvinhu zvepasirese zvinokwanisa kuwana ese masumbu dhatabhesi (neropafadzo dzakakodzera).

Iwo mabasa akaparadzaniswa zvachose kubva kune vashandisi padanho rekushandisa, kunyangwe zviri nyore kuchengetedza tsamba pakati pavo.

Kuti utange dhatabhesi system, yega nyowani yekumisikidza inogara iine basa rakafanotaurwa.

Nzira yekugadzira mushandisi muPostgreSQL?

Para kugadzirwa kwebasa nyowani mudhatabhesi isu tinongofanirwa kuita iwo unotevera kuraira, watinongofanira kutsiva "mushandisi" nezita ratiri kuda kupa:

postgres=# CREATE ROLE usuario;

Iye zvino kana tichida kuwedzera hunhu hwekupinda padanho remushandisi, isu tinongofanirwa kuwedzera zvinotevera:

postgres=#CREATE ROLE usuario LOGIN;

Kana iyo inogona zvakare kugadzirwa seinotevera

postgres=#CREATE USER usuario;           

Nekugadzira izvi, isu tinofanirwa kupa password iyo yatinogona kuona nzira yekusimbisa nokudaro nekupa password yakavharidzirwa kana uchibatanidza kune dhatabhesi.

Tinogona kuita izvi nekutaipa unotevera kuraira:

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

Chekupedzisira iwe unogona kuwana akasiyana tutorials uye kubatsira mune akawanda maforamu uye mawebhusaiti kwavanogovana zvemukati pane kushandiswa uye manejimendi yePostgreSQL.