Isa postgresql muUbuntu

Postgresql is a free control system yedhisiki dzakasiyana-siyana dzakashandiswa nemapuratifomu akasiyana, kusanganisira windows naLinux. Chishandiso chinotsigira huwandu hukuru hwemhando dze data, ine mutauro wakavakirwa-muRugwaro uye unotsigira kushandiswa kwemitauro yakasarudzika yekuronga. Ubuntu postgresql yakaiswa kuburikidza neiyo terminal uchishandisa zvivakwa zvepamutemo kana mushandisi wekubhadhara, uye mushure meiyo basa rekugadzirira, kuyedza uye kugadzira matafura anoitwa.

Isa postgresql muUbuntu

Dhatabhasi anoshandiswa munzvimbo dzakasiyana siyana, asi maneja ekunyaradza anopa hurongwa hwekudzora. Vazhinji vashandisi vanomira paPostgresql, chiise mu OS yavo uye tanga kushanda nematafura. Tevere, isu tinoda kuyambuka nhanho kurondedzera iyo yese yekuisa maitiro, yekutanga kutanga uye kuisa chishandiso chakataurwa.

Nhanho 1: Isa postgresql

Ehezve, iwe unofanirwa kutanga nekuwedzera kwemafaira ese anodiwa uye maraibhurari muUbuntu kuve nechokwadi chekushanda kwakajairika kwe postgresql. Izvi zvinoitwa uchishandisa console uye tsika kana repamutemo repositories.

1. Vhura iyo "terminal" mune chero nzira iri nyore, semuenzaniso, kuburikidza nemenyu kana pini yeiyo CTRL + ALT + T KURUSING.



2. Kutanga, tinocherekedza zvivakwa zvekuchengetedza mushandisi, nekuti ikoko kazhinji kazhinji vaburitse shanduro dzichangopfuura. Isa Sudo Sh -c 'Echo Command in the Command http://pt.Postgresql.org/Postgresql.org/Postgresql.org/Postgresql.org/Postgsql.org/Post/ `` lsb_release -csc Main ">> Pgdg.list ', uye wobva wadzvanya pinda.



3. Isa password kubva kuaccount yako.



4. Mushure meizvozvo, shandisa wget -q https://www.Posostgresql.org/keya/Chok/ccc4CF8.asc -o - | Sudo apt-kiyi wedzera - kuwedzera mapakeji.



5. Iyo inoramba ichingogadzirisa iyo mararaibhurari ehurongwa hweSudo Sugo APT-Tora Upment Command.



6. Kana iwe uchifarira kuwana iyo yazvino inowanikwa postgresql shanduro kubva kune yepamutemo repository

Kana wapedza kuiswa kwakabudirira, iwe unogona kuchinjisa kune yekutanga account account, kutarisa kushanda kwehurongwa uye kwekutanga kugadzirisa.

Nhanho yechipiri: Kutanga kumhanya postgresql

Management of yakaiswa dbms inoitika zvakare kuburikidza ne "terminal" uchishandisa mirairo yakakodzera. Kukwirira kumushandisi wekutendeuka anotaridzika seizvi:

1. Isa iyo Sudo Su - Postgres Command uye tinya pane Enter. Chiito chakadai chinokutendera kuti uenderere mberi nekugadzirisa iyo default account yakagadzirwa neiyo default account, iyo parizvino inoita seyakanyanya.



2. Iyo yekuisa muChinyorwa Console pasi pemhando yebrofile inoshandiswa inoitwa kuburikidza nePSQL. Activation rubatsiro inokubatsira iwe kubata nenzvimbo - icharatidza mirairo yese iripo uye nharo.



3. Kuona ruzivo nezvechirongwa chazvino chikamu chinoitwa kuburikidza \ conninfo.



4. Chikwata \ q zvichabatsira kubuda kunze kwenzvimbo.

Iye zvino iwe unoziva nzira yekupinda muakaunti uye uende kune consoter console, saka inguva yekutamira kune yakasikwa yemushandisi mutsva uye database yayo.

Nhanho 3: Kugadzira mushandisi uye database

Izvo hazvisi nyore nguva dzose kushanda neiyo iripo account account, uye hazviwanzo kuve madikanwa. Ndokusaka tichifunga nezve maitiro ekugadzira chimiro chitsva uye achisunga iyo database yakaparadzana.

1. Kuve mune console pasi peiyo postgres mbiri (sudo su-postgres muchirairo), nyora gadzira, uye wozotaura zita rakakodzera, mavara ekutarisa mune yakakodzera tambo.



2. Tevere, sarudza kana iwe uchida kupa mushandisi nemutemo wekutarisa kuti uwane zvese zve system zviwanikwa. Ingosarudza sarudzo yakakodzera uye enda mberi.



3. Iyo database inonzi yakanakisa zita rakafanana neiyo nhoroondo, saka yakakodzera kushandisa yakagadzirirwa lumpics Command, uko marobhoti izita rezita.



4. Shanduko yekushanda neiyo database yakataurwa inoitika kuburikidza nePSQL -D Lumpics, uko mapopoma izita re database.

Nhanho 4: Kugadzira tafura uye kushanda nemitsara

Iyi inguva yekugadzira yako yekutanga tafura mune yakagadziriswa chigadziko. Maitiro aya anoitwawo kuburikidza nekunyaradza, zvisinei, zvichave nyore kubata nemirairo yekutanga, nekuti iwe unongoda zvinotevera:

1. Mushure mekutamira kune database, pinda iyo kodhi yakadai:

   Gadzira bvunzo yetafura (

   Zvishongedzo_ID Serial Primary kiyi,

   Type Varchar (50) kwete Null,

   Color varchar (25) kwete null,

   Nzvimbo Varchar (25) cheki (nzvimbo mu ('kuchamhembe', 'kumaodzanyemba', 'kumabvazuva', 'kuchamhembe kwakadziva kumadokero', 'kuSouthwest'))

   Isa_date zuva.

   );

   

   Kutanga, iyo bvunzo yetafura yezita inotaurwa (unogona kusarudza rimwe zita). Izvi zvinotevera zvinotsanangura mutsara wega wega. Isu takasarudza mazita emhando Varchar uye mavara Vachar chete semuenzaniso, iwe zvakare uchave nechiratidzo chevamwe, asi chete nekushandiswa kwemavara echiLatin. Nhamba dziri mumabhureki vane mhosva yehukuru hwekisimusi, iyo yakanangana nedata yakaiswa ipapo.

2. Mushure mekupinda, iyo inoramba ichingoratidzira tafura kune iyo skrini ichishandisa \ d.



3. Iwe unoona chirongwa chakareruka icho chisina chero ruzivo rwechiripo.



4. Iyo itsva data inowedzerwa kuburikidza neiyo Insert Peckt Test Command (Type, Ruvara, Nzvimbo, isa_date) tsika ('Slide', 'bhuruu', 'South', '2018-02'); Kutanga ratidza zita retafura, kuti isu muyedzo, ipapo makoramu ese akanyorwa, uye tsika dzakataurwa mumabhureki.



5. Unogona kuwedzera imwe mutsara, semuenzaniso, isa muedzo (mhando, ruvara, nzvimbo, kuisa_ding ',' kuchamhembe "," kuchamhembe kwakadziva kumadokero ',' 2018-02-2014 ');



6. Mhanya tafura kuburikidza nesarudzo * kubva muyedzo ;, kufungidzira mhedzisiro yacho. Sezvauri kuona, zvese zvinoiswa nenzira kwayo uye iyo data inoitwa nemazvo.



7. Kana iwe uchida kudzima chero kukosha, zviite kuburikidza nekudzima kubva pamuedzo uko mhando = 'Slide' kuraira ;, nekutsanangura iyo inodiwa munda.

Nhanho 5: Isa Phpgadmin

Kwete nguva dzose kudzora kweiyo database inoitwa nyore nyore kuburikidza ne console, saka zvakanakira kukwidziridza, kurongedza nzvimbo inokosha Phpgadmin graphical interface.

1. Chekutanga usati "terminal", tora zvinyorwa zvazvino zvekuverenga mararaibhurari kuburikidza neSudo apt-tora update.



2. Isa iyo Apache Sudo Apt-Tora Isa Apache2 Web Server.



3. Mushure mekuisa, kuyedza nekuita uye kururamisa kweiyo syntax uchishandisa sudo apache2ctl glastl. Kana chimwe chinhu chikatadza, tsvaga chikanganiso mune tsananguro pane iyo yebhusaiti yeApache Apache.



4. Mhanya seva nekupinda Suo Suo Systemctl Start Apache2.



5. Iye zvino kuti kushanda kwakakodzera kweseva kunopihwa, unogona kuwedzera iyo popgadmin yekuraira nekuvatengesa kubva kuSudige Kuchengetedza kuburikidza neSudo Apt Isa Phpgadmin.



6. Tevere, iwe unofanirwa kushandura iyo faira yekugadziriswa zvishoma. Vhura iyo kuburikidza neiyo standard notepad nekutsanangura Gedit /etc/apache2/conf-wanikwa/Phpggadmin.conf. Kana gwaro rakaverengerwa chete, iwe uchafanirwa kutsanangura sudo pamberi peGedit.



7. Pamberi peiyo "inoda low low" mutsara, isa # kuRodha iyo mukutaura, wobva wapinda bvudzi kubva kune vese. Iye zvino kuwana kero iyo ichavhurwa kune ese midziyo yetiweki, uye kwete nekuda kwePC yeko.



8. Kutangazve Sudo Service Apache2 Restart Web Server uye inogona kuenda zvakachengeteka kuenda kubasa ne postgresql.

Munyaya ino, isu takataridzira kwete chete postgresql, asi zvakare kuiswa kwemapepa eApache Webhusaiti anoshandiswa mune rampu software inosanganisa. Kana iwe uchifarira kuona kuzere kwesangano rako uye mamwe mapurojekiti, tinokupa zano kuti uzivewo maitiro ekuwedzera zvimwe zvikamu nekuverenga imwe nyaya pane inotevera link.

Onawo: Kuisa mapurogiramu emwenje muUbuntu