Faka i-Postgresql e-Ubuntu

I-Postgresql yinkqubo yokulawula yasimahla yeenkcukacha ezahlukeneyo ezisetyenziswa kumaqonga ahlukileyo, kubandakanya iWindows kunye neLinux. Esi sixhobo sixhasa inani elikhulu leentlobo zedatha, linolwimi olubhaliweyo-loLwimi olwenziweyo kwaye ixhasa ukusetyenziswa kweelwimi zenkqubo yeklasi. I-Ubuntu Postgresql ifakwe kwi-terminal isebenzisa iindawo zokugcina okanye zomsebenzisi, kwaye emva komsebenzi wokulungiselela, uvavanyo kunye nokudala iitafile zenziwa.

Faka i-Postgresql e-Ubuntu

Ugcino lweenkcukacha lusetyenziswa kwiindawo ezahlukeneyo, kodwa ulawulo lwentuthuzelo lubonelela ngenkqubo yolawulo. Abasebenzisi abaninzi bayamisa kwi-postgresql, bayifaka kwi-OS yabo kwaye baqale ukusebenza neetafile. Okulandelayo, singathanda ukunyuka ngenyathelo ukuchaza inkqubo yonke yokufaka, ukuqalwa kokuqala nokubeka isixhobo esikhankanyiweyo.

Inyathelo loku-1: Faka i-PostgresQl

Ewe kunjalo, kuya kufuneka uqale ngongezwa kwazo zonke iifayile ezifanelekileyo kunye neelayibrari e-Ubuntu ukuqinisekisa ukusebenza kwesiqhelo sePostgresql. Oku kwenziwa kusetyenziswa iConsole kunye neSiko okanye iReport Report.

1. Qalisa "i-terminal" ngayo nayiphi na indlela efanelekileyo, umzekelo, ngemenyu okanye kwi-pinch ye-CTRL + Alt + T



2. Okokuqala, siphawula iindawo zokugcina soMsebenzisi, kuba apho kuhlala kuphinda kubekho iinguqulelo zamvanje. Faka umthetho weSudo Sh -c I-PGDG.List ', kwaye emva koko ucofe u-Enter.



3. Ngenisa iphasiwedi kwiakhawunti yakho.



4. Emva koko, sebenzisa i-WGET -Q i-http: I-Sudo Apt-Isitshixo songeza-ukongeza iiphakheji.



5. Ihlala kuphela ekuhlaziyeni iilayibrari zenkqubo nguMgangatho oPhakamileyo Sudo Apt-Get How.



6. Ukuba unomdla wokufumana ingxelo ekhoyo yeposi ye-postgresql evela kwindawo esemthethweni, kufuneka ubhale kwi-sudo apt-fatha ukufaka i-Postgresql Postgreql-Igalelo kwaye uqinisekise ukongezwa kweefayile.

Emva kokugqitywa kokufakwa ngempumelelo, unokutshintshela ekuqaliseni i-akhawunti esemgangathweni, ukujonga ukusebenza kwenkqubo kunye noqwalaselo lokuqala.

Inyathelo 2: Okokuqala ruggresql

Ulawulo lwe-DBMs efakiweyo lenzeka nge "terminal" usebenzisa imiyalelo efanelekileyo. Isibheno kumsebenzisi ongagqibekanga ujongeka ngolu hlobo:

1. Ngenisa i-sudo su - umyalelo weposi kwaye ucofe u-Enter. Intshukumo enjalo iya kukuvumela ukuba uqhubeke ukuze ulawule i-akhawunti emiselweyo eyenziwe yiakhawunti engagqibekanga, esebenza ngoku njengeyona iphambili.



2. Igalelo kwi-console yolawulo phantsi kohlobo lweprofayili esetyenzisiweyo iqhutywa nge-psql. Uncedo lokuSebenza luya kukunceda ukujongana nendalo-iya kuyibonisa yonke imiyalelo ekhoyo kunye neengxoxo.



3. Ukujonga ulwazi malunga ne-postgresql yeseshini yangoku yenziwa kwi-\ conninfo.



4. Iqela \ Q liya kunceda ukuphuma kwindalo esingqongileyo.

Ngoku uyayazi indlela yokungena kwiakhawunti kwaye uye kwiConsole yoLawulo, ngoko lixesha lokuba siye kwindalo yomsebenzisi omtsha kunye nedatha yayo.

Inyathelo 3: Ukwenza umsebenzisi kunye nedatha

Akusoloko kufanelekile ukusebenza neakhawunti ekhoyo, kwaye ayisoloko iyimfuneko. Kungenxa yoko le nto sicebisa ukuba siqwalasele inkqubo yokwenza iprofayile entsha kwaye ibophelele kwindawo eyahlukileyo.

1. Ukuba kwi-console phantsi kweprofayili ye-POSGRES (Sudo Sulgres), bhala i-Dralemrier -Inter, kwaye uchaze igama elifanelekileyo, abalinganiswa abahloliweyo kwintambo efanelekileyo.



2. Okulandelayo, yenza isigqibo sokuba uyafuna ukunika umsebenzisi ngolawulo lolawulo lokufikelela kuzo zonke izixhobo zenkqubo. Khetha ngokulula ukhetho olufanelekileyo kwaye uhambe ngakumbi.



3. Iziko ledatha libizwa ngokuba ligama elifanayo njengoko i-akhawunti yabizwa ngokuba yi-akhawunti, ke kufanelekile ukusebenzisa umyalelo we-Destb Lumpleb, apho i-gumpics ligama lomsebenzisi.



4. Inguqu yokusebenza kunye nedatha echaziweyo yenzeka nge-psql -d maillics, apho i-gurpics ligama ledatha.

Inyathelo 4: Ukudala itafile kunye nomsebenzi kunye nemigca

Lixesha lokuba wenze itafile yakho yokuqala kwisiseko esichongiweyo. Le nkqubo yenziwa ngekhonsole, nangona kunjalo, kuya kuba lula ukujongana nemiyalelo ephambili, kuba ufuna oku kulandelayo:

1. Emva kokufudukela kwiziko ledatha, faka ikhowudi enjalo:

   Yenza uvavanyo lwetafile (

   Ukuxhobisa i-Erial Primary Primary,

   Chwetheza i-qualchar (50) hayi null,

   I-varchar yombala (25) ayisebenzi,

   Indawo i-Vablir (25) Jonga (Indawo ngo ('North', 'South', 'Mzantsi', 'Mzantsi-ntshona'),

   Faka umhla wokufaka.

   );

   

   Okokuqala, igama letafile yovavanyo lichaziwe (unokukhetha elinye igama). Oku kulandelayo kuchaza ikholamu nganye. Sikhethe amagama ohlobo lwe-qualchar kunye nophawu lombala kuphela, uya kuba nesalathiso sayo nayiphi na enye into, kodwa kuphela ngokusetyenziswa kwabalinganiswa baseLatin. Amanani kwiibakaki anoxanduva lobukhulu bekholamu, enxulumene ngqo nedatha ebekwe apho.

2. Emva kokungena, uhlala kuphela ukubonisa itafile kwisikrini usebenzisa \ d.



3. Ubona iprojekthi elula engenayo nayiphi na ingcaciso okwangoku.



4. Idatha entsha yongezwa ngokusebenzisa umthetho wokufaka i-faka (uhlobo, umbala, indawo, faka i-Slide_Date), 'Somlomo', 'Mzantsi' ,.); Okokuqala bonakalisa igama letafile, kwimeko yethu kuvavanyo, zonke iikholamu zidwelisiwe, kwaye amaxabiso achazwe kwizibiyeli.



5. Unokongeza emva koko, umzekelo, faka kuvavanyo (uhlobo, umbala, indawo, faka i-'Shente ',' Mzantsi ',' 20182-24 ');



6. Qhuba itafile ngokukhetha * kuvavanyo;, ukuqikelela iziphumo. Njengoko ubona, yonke into iseti ngokuchanekileyo kwaye idatha yenziwe ngokuchanekileyo.



7. Ukuba ufuna ukucima nayiphi na ixabiso, lenze ngokucimayo ukusuka kuvavanyo apho uhlobo = 'isilayidi');

Inyathelo 5: Faka i-phppgadmin

Akusoloko kulawula i-database yenziwa ngokulula ngokusebenzisa i-console, ngoko kungcono ukuphucula, ukumisela i-phppgadmin ekhethekileyo.

1. Okokuqala ngaphambi "kwe-terminal", ukhuphele uhlaziyo lwamva nje lwamathala eencwadi nge-sudo alt-hlaziyo.



2. Faka i-Apache Sude-Fumana ukufaka iseva ye-Apache2 yewebhu.



3. Emva kokufaka, ukumvavanya ngokusebenza nokuchaneka kwe-syntax usebenzisa i-sudoache2ctl yoqoqosho. Ukuba kukho into engahambanga kakuhle, jonga impazamo kwinkcazo kwiwebhusayithi ye-Apache esemthethweni.



4. Qhuba iseva ngokufaka i-sudo scroctl qala iapache2.



5. Ngoku ukuba ukusebenza ngokuchanekileyo kweseva kubonelelwe, ungongeza iilayibrari ze-phppgadmine ngokukhuphela kuzo ekugcinweni ngokusesikweni kwi-fedpgadmin.



6. Okulandelayo, kuya kufuneka utshintshe ifayile yoqwalaselo kancinci. Yivule ngencwadana esemgangathweni ngokwazisa i-gedit /etc/tapa -/confbled/confppgadmin.conf. Ukuba uxwebhu lufundwa kuphela, kuya kufuneka uchaze isundu phambi kweGdit.



7. Phambi kwe "ndifuna umgca" wasekhaya, faka # ukulungisa kwakhona kwinkcazo, emva koko ungenise ukuvumela kubo bonke. Ngoku ukufikelela kwidilesi kuya kuvulelwa zonke izixhobo zenethiwekhi, kwaye kungekuphela kwiPC yendawo.



8. Qalisa kwakhona i-SUDO YENKONZO YENKONZO YENKONZO YENKONZO KAPAH2

Kweli nqaku, asikhange siqwalasele kuphela i-postgresql, kodwa nokufakwa kweseva yewebhu ye-Apache esetyenziselwa ukudityaniswa kwesoftware. Ukuba unomdla wokuqinisekisa ukusebenza ngokupheleleyo kweesayithi zakho kunye nezinye iiprojekthi, sikucebisa ukuba uqhelene nenkqubo yokongeza ezinye izinto ngokufunda elinye inqaku ngeli nqaku.

Bona: Ukuseta iinkqubo zeLamps e-Ubuntu