Yadda za'a sauke software don kwamfutar tafi-da-gidanka ASUS K52F

PostgreSQL ne mai zaman kanta tsarin gudanarwa na tsarin dandamali, har da Windows da Linux. Wannan kayan aiki yana goyan bayan yawan adadin bayanai, yana da harshe mai haɗin ciki da kuma tallafawa aikin ta amfani da harsunan shirye-shirye na gargajiya. A cikin Ubuntu, an shigar da PostgreSQL ta hanyar "Ƙaddara" ta yin amfani da ɗakin ajiya na ma'aikata ko masu amfani, kuma bayan wannan aikin shiri, gwadawa da kuma samar da Tables ana aiwatar da su.

Shigar PostgreSQL a Ubuntu

Ana amfani da bayanan bayanai a wurare daban-daban, amma tsarin gudanarwa mai dadi yana ba su dashi mai mahimmanci. Yawancin masu amfani da su a PostgreSQL, shigar da shi a OS kuma fara aiki tare da tebur. Bayan haka, muna so muyi bayanin kowane tsarin shigarwa, mataki na farko da kuma saitin kayan aikin da aka ambata.

Mataki na 1: Shigar da PostgreSQL

Tabbas, ya kamata ka fara da ƙara dukkan fayiloli da ɗakunan karatu zuwa Ubuntu don tabbatar da aikin PostgreSQL na al'ada. Anyi wannan ta yin amfani da na'ura mai kwakwalwa da kuma mai amfani ko wuraren ajiyar ma'aikata.

1. Gudun "Ƙaddara" a kowane hanya mai dacewa, misali, ta hanyar menu ko ta danna maɓallin haɗin Ctrl + Alt T.



2. Na farko, mun lura da wuraren ajiyar masu amfani, saboda yawancin da aka saba sauke su a can. Saka cikin umurnin filinsudo sh -c 'echo' bb //apt.postgresql.org/pub/repos/apt/ 'lsb_release -cs'-pgdg main ">> /etc/apt/sources.list.d/pgdg.list'sa'an nan kuma danna kan Shigar.



3. Shigar da kalmar shiga don asusunku.



4. Bayan wannan amfaniwget -q http://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-key add -don ƙara kunshe.



5. Ya rage kawai don sabunta tsarin dakunan karatu tare da umarnin da ya dace.sudo apt-samun sabuntawa.



6. Idan kuna sha'awar samun sabon sakon layi na PostgreSQL daga asusun ajiyar ma'aikata, kuna buƙatar rubutawa a cikin na'urasudo apt-samun shigar postgresql postgresql-bayarkuma tabbatar da ƙara fayiloli.

Bayan kammala aikin shigarwa mai kyau, za ka iya ci gaba da ƙaddamar da asusun ajiya, duba aiki na tsarin da daidaitattun farko.

Mataki na 2: Fara PostgreSQL na farko

Gudanar da shigarwar DBMS yana faruwa ta hanyar "Ƙaddara" ta amfani da umarnin da ya dace. Kira ga mai amfani mai amfani kamar wannan:

1. Shigar da umurninsudo su - postgreskuma danna kan Shigar. Wannan aikin zai ba ka izinin gudanarwa a madadin asusun da aka samo ta tsoho, wanda ke aiki a matsayin babban abu.



2. Shigar da na'ura mai sarrafawa a karkashin jagorancin bayanin martabar da ake amfani da ita ta hanyarpsql. Yin aiki tare da yanayin zai taimaka maka kunnawataimako- zai nuna duk dokokin da aka samu da kuma muhawara.



3. Ana duba bayanan game da halin yanzu PostgreSQL ana yin ta conninfo.



4. Fita waje zai taimaka wa tawagar q.

Yanzu ku san yadda za a shiga cikin asusun kuma ku tafi kundin sarrafawa, don haka lokaci ya yi don matsawa don ƙirƙirar sabon mai amfani da database.

Mataki na 3: Ƙirƙiri Mai amfani da Database

Ba koyaushe yana dacewa da aiki tare da asusun da ke faruwa ba, kuma ba koyaushe ake bukata ba. Abin da ya sa muke ba da shawarar yin la'akari da hanyar da za a samar da sabon labaran da kuma haɗa shi da wani bayanan raba.

1. Kasancewa a cikin na'ura mai kwakwalwa a karkashin jagorancin martaba matsayi (tawagarsudo su - postgres) rubutaƙirƙirar - munisa'an nan kuma ba shi da suna mai dacewa ta hanyar rubutawa a cikin kirtani mai dacewa.



2. Na gaba, yanke shawara ko kana so ka ba da damar yin amfani da masu amfani da damar yin amfani da duk albarkatu. Zaɓi zaɓi kawai sannan ka ci gaba.



3. Ana amfani da bayanan mai suna da sunan ɗaya kamar yadda aka ambaci asusun, saboda haka ya kamata ka yi amfani da umurnincreatedb lumpicsinda lumpics - sunan mai amfani.



4. Tsarin yin aiki tare da ƙayyadaddun bayanai yana faruwa ta hanyarpsql -d lumpicsinda lumpics - sunan database.

Mataki na 4: Samar da tebur kuma aiki tare da layuka

Lokaci ya yi don ƙirƙirar tamarku ta farko a cikin jerin bayanai. Wannan hanya kuma ana yin ta ta na'ura mai kwakwalwa, amma ba zai yi wuya a magance manyan dokokin ba, domin duk abin da zaka yi shi ne:

1. Bayan motsawa zuwa bayanan, shigar da wadannan shafuka:

   Sake TABLE gwajin (
shirin ba da kyauta PRIMARY KEY,
type varchar (50) BA NULL,
launi varchar (25) BA NULL,
rajistan wuri varchar (25) duba (wuri a ('arewa', 'kudu', 'yamma', 'gabas', 'arewa maso gabas', 'kudu maso gabas', 'kudu maso yamma', 'arewa maso yamma')),
shigar_date kwanan wata
);

   

   Da farko sunan mai suna kayyade. gwajin (zaka iya zaɓar wani suna). Wadannan suna bayyana kowane shafi. Mun zabi sunayen type varchar kuma launi varchar kawai don misali, za ka iya samun dama ga wani nuni, amma tare da amfani da haruffan Latin. Lambobi a cikin ƙuƙwalwar suna da alhakin girman ɗigin, wanda ke da alaka da bayanan da aka dace a can.

2. Bayan shigarwa ya kasance kawai don nuna teburin akan allon tare da d.



3. Kuna ganin aikin mai sauƙi wanda ba ya ƙunshi duk wani bayani duk da haka.



4. Sabuwar bayani an kara ta ta hanyar umarniTASHE A cikin gwaji (nau'in, launi, wuri, install_date) HALITTA ('slide', 'blue', 'kudu', '2018-02-24');Da farko, an nuna sunan teburin, a cikin yanayinmu shi ne gwajin, to, dukkanin ginshiƙai an jera, kuma ana nuna alamomin da aka nuna, dole ne a rubuce.



5. Sa'an nan kuma zaka iya ƙara wani layin, alal misali,TASHE A cikin gwaji (nau'in, launi, wuri, install_date) KASHI ('swing', 'rawaya', 'arewa maso yamma', '2018-02-24');



6. Gudun tebur ta hanyarSANTA * DAGA gwaji;don kimanta sakamakon. Kamar yadda kake gani, an shirya kome da kyau kuma an shigar da bayanai daidai.



7. Idan kana buƙatar cire duk wani darajar, yi ta ta hanyar umarniKASHE DAGA DA KARARWA YAKE irin = 'slide';ta hanyar ƙayyade filin da aka buƙata a fadi.

Mataki na 5: Shigar phpPgAdmin

Gudanar da bayanai ba a sauƙaƙe ba ne ta hanyar na'ura mai kwakwalwa, don haka yana da kyau in haɓaka shi ta hanyar shigar da phpPgAdmin GUI na musamman.

1. Bayani ta hanyar "Ƙaddara" Sauke sababbin sabuntawa don ɗakin karatu viasudo apt-samun sabuntawa.



2. Shigar Ajiyayyen Yanar gizo na Apachesudo apt-samun shigar apache2.



3. Bayan shigarwa, gwada aikinsa kuma daidaita daidaitaka ta yin amfani da shisudo apache2ctl configtest. Idan wani abu ya yi daidai ba, nemi kuskure bisa ga bayanin a kan shafin yanar gizo Apache.



4. Fara uwar garken ta bugasudo systemctl fara apache2.



5. Yanzu cewa an tabbatar da aikin uwar garken, za ka iya ƙara phpPgAdmin ɗakunan karatu ta hanyar sauke su daga tashar ajiya ta gidan wayaSudo apt kafa phppgadmin.



6. Na gaba, ya kamata ka canza canjin sanyi sau ɗaya. Buɗe ta ta hanyar rubutu na rubutu, ƙayyadewagedit /etc/apache2/conf-available/phppgadmin.conf. Idan rubutun ya karanta kawai, zaka buƙaci umarnin kafin gedit saka masudo.



7. Kafin layi "Bukata na gida" saka#, don sake saita shi a cikin sharhin, kuma shigar da ƙasaIzinin Daga duk. Yanzu samun dama ga adireshin zai bude ga dukkan na'urori akan cibiyar sadarwa, kuma ba kawai ga PC ba.



8. Sake kunna uwar garke yanar gizosudo sabis na apache2 sake farawakuma jin kyauta don sauka don aiki tare da PostgreSQL.

A cikin wannan labarin, mun duba ba kawai PostgreSQL ba, har ma da shigarwa na uwar garken yanar gizo Apache, wanda aka yi amfani dashi wajen hada LAMP software. Idan kuna sha'awar tabbatar da cikakken aiki na shafukanku da kuma sauran ayyukanku, muna ba ku shawara ku fahimci kanku tare da aiwatar da ƙara wasu abubuwa ta hanyar karatun wani labarinmu a link din.

Duba kuma: Shigar da ɗakin LAMP a Ubuntu