Faka i-PostgreSQL ku-Ubuntu

Pin
Send
Share
Send

I-PostgreSQL uhlelo lokuphathwa kwemininingwane yamahhala olusetshenziselwa amapulatifomu ahlukahlukene, kufaka phakathi iWindows neLinux. Ithuluzi lisekela inani elikhulu lezinhlobo zedatha, linolimi lokubhala olwakhelwe ngaphakathi futhi lisekela ukusetshenziswa kwezilimi zokuhlela zakudala. Ku-Ubuntu, i-PostgreSQL ifakiwe "Isiginali" usebenzisa amakhosombe asemthethweni noma womsebenzisi, futhi emva kwalokho, kwenziwa umsebenzi wokulungiselela, wokuhlola nowokwenza amatafula.

Faka i-PostgreSQL ku-Ubuntu

Amadokhumenti asetshenziswa emikhakheni ehlukahlukene, kepha uhlelo lokuphatha lunikeza ukuphathwa okuhlelekile. Abasebenzisi abaningi bayama ePostgreSQL, bayifaka ku-OS yabo bese beqala ukusebenza ngamatafula. Okulandelayo, singathanda ukwengeza isinyathelo ngesinyathelo sichaza yonke inqubo yokufaka, ukwethulwa kokuqala nokulungiswa kwethuluzi elishiwoyo.

Isinyathelo 1: Faka i-PostgreSQL

Vele, kufanele uqale ngokungeza wonke amafayela adingekayo nemitapo yolwazi ku-Ubuntu ukuze uqinisekise ukusebenza okujwayelekile kwePostgreSQL. Lokhu kwenziwa ngokusebenzisa i-console kanye nomsebenzisi noma amakhosombe asemthethweni.

  1. Gijima "Isiginali" nganoma iyiphi indlela elula, isibonelo, ngokusebenzisa imenyu noma ngokucindezela inhlanganisela yokhiye I-Ctrl + Alt + T.

  2. Okokuqala, siphawula amakhosombe abasebenzisi, ngoba izinguqulo zakamuva kakhulu zivame ukulayishwa lapho kuqala. Namathisela umyalo ensiminisudo sh -c 'echo "deb //apt.postgresql.org/pub/repos/apt/' lsb_release -cs'-pgdg main" >> /etc/apt/source.list.d/pgdg.list 'bese uqhafaza Ngena.

  3. Faka iphasiwedi ye-akhawunti yakho.

  4. Ngemuva kwalolo hlelowget -q //www.postgresql.org/media/keys/ACCC4CF8.asc -O - | Ukhiye we-sudo apt-key -ukufaka amaphakheji.

  5. Kuhlala kuphela ukuvuselela amalabhulali esistimu ngomyalo ojwayelekileukuvuselelwa kwesudo.

  6. Uma unesifiso sokuthola inguqulo yakamuva ye-PostgreSQL kusuka endaweni esemthethweni, udinga ukubhala kukhonsolisudo apt-uthole ukufaka postgresql postgresql -ribfuthi uqinisekise ukungezwa kwamafayela.

Lapho usuqede ukufakwa okuphumelelayo, ungaqhubeka ukwethula i-akhawunti ejwayelekile, uhlole uhlelo nokumiswa kokuqala.

Isinyathelo 2: Ukuqala i-PostgreSQL Isikhathi sokuqala

Ukuphathwa kwe-DBMS efakiwe nakho kwenzeka "Isiginali" sisebenzisa imiyalo efanele. Ucingo oluya kumsebenzisi olwenziwe ngokuzenzakalelayo lubukeka kanjena:

  1. Faka umyalosudo su - ama-postgresbese uqhafaza Ngena. Isenzo esinjalo sizokuvumela ukuthi ushintshele kwabaphathi egameni le-akhawunti ezenzakalelayo, esebenza njengeyokuqala.

  2. Ukungena kwikhonsoli yokuphatha ngaphansi koshicilelo lwephrofayili esetshenziswayo kwenziwai-psql. Ukwenza kusebenze kuzokusiza ukubhekana nemvelo.usizo-izokhombisa yonke imiyalo nezimpikiswano ezikhona

  3. Ukubuka ulwazi mayelana neseshini ye-PostgreSQL yamanje kwenziwa xhuma.

  4. Phumani imvelo kuzosiza iqembu q.

Manje usuyazi ukuthi ungene kanjani ngemvume ku-akhawunti yakho bese uya kukhonsoli yokuphatha, ngakho-ke isikhathi sokuqhubekela phambili ekudaleni umsebenzisi omusha kanye nedatha yakhe.

Isinyathelo 3: Dala Umsebenzisi neDatabase

Akuvamile ngaso sonke isikhathi ukusebenza nge-akhawunti ejwayelekile ekhona, futhi akudingeki njalo ngaso sonke isikhathi. Kungakho sihlongoza ukubheka inqubo yokwakha iphrofayili entsha nokuxhumanisa i-database ehlukile kuyo.

  1. Ukuba phakathi kwekhonsoli ngaphansi kokuphathwa kwephrofayili izingqwembe (iqembusudo su - ama-postgres) bhalaumakhi - osebenzayo, bese uyinika igama elifanele ngokubhala izinhlamvu emgqeni ofanele.

  2. Okulandelayo, bonisa ukuthi ngabe uyafuna yini ukunikela amalungelo okusebenzisa okuphezulu womsebenzisi ukufinyelela zonke izinsiza zohlelo. Mane ukhethe inketho efanelekile bese uqhubeka.

  3. Kungcono ukubiza i-database igama elifanayo ne-akhawunti eyaqanjwa ngalo, ngakho kufanele usebenzise umyaloama-lbics aqanjwekuphi ama-lumpics - Igama lomsebenzisi.

  4. Ukushintshwa kokusebenza ngedatha ecacisiwe kwenzekaI-psql -d lumpicskuphi ama-lumpics - Igama database.

Isinyathelo 4: Ukwakha Ithebula nokusebenza ngemigqa

Sekuyisikhathi sokwenza itafula lakho lokuqala kudatha ebekiwe. Le nqubo yenziwa futhi nge-console, noma kunjalo, ngeke kube nzima ukubhekana nemiyalo eyinhloko, ngoba udinga okulandelayo kuphela:

  1. Ngemuva kokuya database, faka ikhodi elandelayo:

    DALA isivivinyo SAMABHODI (
    equip_id serial PRIMARY KEY,
    thayipha i-varchar (50) HAYI UNIVI,
    umbala varchar (25) HAYI NWI,
    indawo varchar (25) isheke (indawo e ('enyakatho', 'eningizimu', 'entshonalanga', 'empumalanga', 'enyakatho-mpumalanga', 'eningizimu-mpumalanga', 'eningizimu-ntshonalanga', 'enyakatho-ntshonalanga'),
    ukufaka_ usuku losuku
    );

    Igama lethebula kuqala isivivinyo (ungakhetha elinye igama). Ikholomu ngalinye lichazwe ngezansi. Sikhethe amagama thayipha i-varchar futhi umbala varchar ngokwesibonelo, ungafinyelela inkomba yanoma yikuphi okunye, kodwa kuphela ngokusebenzisa izinhlamvu zesiLatin. Izinombolo ezisebakaki zibhekele usayizi wekholomu, ohlobene ngqo nedatha ebekwe lapho.

  2. Ngemuva kokungena, kuhlala kuphela ukubonisa itafula esibukweni d.

  3. Ubona iphrojekthi elula engathathi imininingwane.

  4. Idatha entsha yengeziwe ngomyaloUkuhlolwa kwe-INSERT INTO (uhlobo, umbala, indawo, ukufaka_datha) AMAXHESI ('slide', 'blue', 'south', '2018-02-24');Igama lethebula liyakhonjiswa kuqala, kuthi thina isivivinyo, khona-ke wonke amakholomu afakwa kuhlu, futhi amanani aboniswa kumabazali, ahlala emamaki wezingcaphuno.

  5. Ngemuva kwalokho ungangeza omunye umugqa, ngokwesibonelo,Ukuhlolwa kwe-INSERT INTO (uhlobo, umbala, indawo, ukufaka_datha) AMAXHAMU ('swing', 'yellow', 'Northwest', '2018-02-24');

  6. Agijime itafulaKHETHA * KUVELA ovivinyweni;ukuhlola umphumela. Njengoba ukwazi ukubona, yonke into itholakala kahle nedatha ifakwe kahle.

  7. Uma udinga ukususa inani, likwenze ngomyaloKhipha ku-test WHERE hlobo = 'isilayidi';ngokucaphuna inkambu oyifunayo kumaki wokucaphuna.

Isinyathelo 5: Faka i-phpPgAdmin

Akulula ngaso sonke isikhathi ukuphatha imininingwane nge-console, ngakho-ke kungcono ukuyithuthukisa ngokufaka i-phpPgAdmin GUI ekhethekile.

  1. Ngokuyinhloko ngokusebenzisa "Isiginali" Landa izibuyekezo zakamuva zelabhulali ngeukuvuselelwa kwesudo.

  2. Faka i-Apache Web Serversudo apt-get ukufaka i-apache2.

  3. Ngemuva kokufaka, hlola ukusebenza kwayo ne-syntax usebenzisasudo apache2ctl ukucushwa. Uma kukhona okungahambanga kahle, funa iphutha encazelweni kwiwebhusayithi esemthethweni ye-Apache.

  4. Qala iseva ngokuthayiphasudo systemctl qala apache2.

  5. Manje njengoba iseva isebenza kahle, ungangeza imitapo yolwazi ye-phpPgAdmin ngokulanda ngokulanda okuvela ngokusemthethwenifaka i-sptpp ukufaka.

  6. Okulandelayo, udinga ukuguqula kancane ifayela lokucushwa. Yivule ngebhukwana elijwayelekile ngokuchazaI-gedit /etc/apache2/conf-ava available/phppgadmin.conf. Uma idokhumenti ifundwa kuphela, uzodinga umyalo ngaphambili gedit khombisa futhisudo.

  7. Ngaphambi komugqa "Dinga yasendaweni" beka#ukuyiguqula ibe amazwana, futhi kusukela phansi fakaVumela kusuka kukho konke. Manje ukufinyelela kukheli kuzovulelwa wonke amadivaysi kunethiwekhi, hhayi kwi-PC yendawo.

  8. Qala kabusha iseva yewebhusudo service apache2 ukuqalisa phansifuthi ungaqhubeka ngokusebenza ngokuphepha ne-PostgreSQL.

Kulesi sihloko, asihlolisanga kuphela i-PostgreSQL, kodwa nokufakwa kweseva yewebhu ye-Apache, esetshenziswa ekuhlanganiseni isoftware ye-LAMP. Uma unesifiso sokuqinisekisa ukusebenza ngokuphelele kwamasayithi akho namanye amaphrojekthi, sincoma ukuthi uzijwayeze nenqubo yokungeza ezinye izakhi ngokufunda enye i-athikili kusixhumanisi esilandelayo.

Bheka futhi: Ukufaka i-LAMP Software Suite ku-Ubuntu

Pin
Send
Share
Send

Okuthunyelwe Popular

https://eifeg.com 2024