Postgresql ndi njira yaulere ya database osiyanasiyana yomwe imakhazikitsidwa pa nsanja zosiyanasiyana, kuphatikizaponso Windows ndi Linux. Chidacho chimathandizira mitundu yambiri ya mitundu ya deta, ali ndi chilankhulo chomangidwa ndipo amathandizira kugwiritsa ntchito zilankhulo zapakale. Ubuntu posgresql imayikidwa kudzera mu terminal pogwiritsa ntchito malo osungira kapena ogwiritsa ntchito, ndipo pambuyo pa ntchito yokonzekera, kuyesa ndi kupanga matebulo kumachitika.
Ikani postgresql ku Ubuntu
Malo osungirako amagwiritsidwa ntchito m'malo osiyanasiyana, koma kasamalidwe kotonthoza kumapereka dongosolo lowongolera. Ogwiritsa ntchito ambiri amaima ku posgresql, ikani iwo os ndi kuyamba kugwira ntchito ndi matebulo. Kenako, tikufuna kuti tisinkhedwe pofotokoza za kuyika konse, kuyambitsa koyamba ndikukhazikitsa chida chotchulidwa.Gawo 1: Ikani postgresql
Zachidziwikire, muyenera kuyamba ndikuwonjezera mafayilo onse ndi maibulale ku Ubuntu kuti mutsimikizire kuti zikugwira ntchito poyambira postgresql. Izi zimachitika pogwiritsa ntchito malo ophatikizira kapena chikhalidwe kapena boma.
- Yambitsani "terminal" m'njira iliyonse yosavuta, mwachitsanzo, kudzera mumenyu kapena kutsina kwa ctrl + t.
- Choyamba, tikuwona malo osungira ogwiritsa ntchito, chifukwa nthawi zambiri mumatsitsa makilimu aposachedwa. Ikani mawu a SuDo Sh -c 'Echo mu Lamulo la HTTP: PGDG.list ', kenako dinani Lowani.
- Lowetsani mawu achinsinsi kuchokera ku akaunti yanu.
- Pambuyo pake, gwiritsani ntchito wit -q https://www.postgresqlqlqlqlqlql/dia/kedia/keys/AcCc4ct. SuDo Apt-kiyi onjezerani - kuwonjezera maphukusi.
- Imangosinthanitsa mabulogu ogwiritsira ntchito omwe ali ndi Standard Sudo Apt-pezani lamulo losintha.
- Ngati mukufuna kupeza mtundu waposachedwa wa postgresql kuchokera ku malo osungira, muyenera kulemba mu SuDo Apt-perekani postgresql-postgeresql-imatsimikizira kuwonjezera mafayilo.
Mukamaliza kukhazikitsa bwino, mutha kusinthana ndi akaunti ya akaunti ya muyezo, ndikuyang'ana momwe dongosololi ndi kusinthira koyambirira.
Gawo 2: Choyamba Thamageresql
Kuwongolera kwa DBMS yokhazikitsidwa kumachitikanso kudzera mu "terminal" pogwiritsa ntchito malamulo oyenera. Funsani wogwiritsa ntchito mosamala akuwoneka motere:
- Lowetsani SuDo Sun - Lamulo la Postgres ndikudina ku Enter. Kuchita koteroko kumakupatsani mwayi kuti musunge akaunti yokhazikika yomwe idapangidwa ndi akaunti yokhazikika, yomwe pakadali pano imakhala ngati yayikulu.
- Kulowetsa mu controle kuwongolera pansi pa mtundu wa mbiri yomwe yagwiritsidwa ntchito imachitika kudzera pa psql. Kuthandizira thandizo kumakuthandizani kuthana ndi chilengedwe - idzawonetsa malamulo onse omwe alipo.
- Kuwona zambiri za gawo laposachedwa lomwe lachitika pambuyo pa \ Conninfo.
- Team \ Q ithandizira kutuluka chilengedwe.
Tsopano mukudziwa momwe mungalowe muakaunti ndikupita ku Corneron Console, ndiye kuti ndi nthawi yosunthira kwa wogwiritsa ntchito watsopano ndi database yake.
Gawo 3: Kupanga wogwiritsa ntchito ndi database
Sikuti nthawi zonse kugwirira ntchito ndi akaunti yomwe ilipo, ndipo sikofunikira nthawi zonse. Ichi ndichifukwa chake tikuganiza kuti tiganizire njira yopanga mbiri yatsopano ndikumangirira ku dababase.
- Kukhala mu kutonthoza pansi pa mbiri ya Postgres (kulamula kwa Sudo Sumres), lembani zopanga - kenako ndikufotokozerani dzina loyenerera, owonetsera zilembo zoyenera.
- Kenako, sankhani ngati mukufuna kupatsa wogwiritsa ntchito ndi lamulo la wopatsa mwayi kuti mupeze zinthu zonse. Ingosankha njira yoyenera ndikupitanso patsogolo.
- Database imatchedwa dzina lomweli monga momwe akauntiyo idatchulidwa, kotero ndikofunikira kugwiritsa ntchito lamulo la ma Lumpu a Lumpb Lumplics, pomwe Lumpkics ndi dzina lolowera.
- Kusintha komwe kumagwira ntchito ndi database yotchulidwa kumachitika kudzera mu psql -d lumpsic, pomwe Lumpkics ndi dzina la database.
Gawo 4: Kupanga tebulo ndikugwira ntchito ndi mizere
Yakwana nthawi yopanga tebulo lanu loyamba mu base. Njirayi imachitidwanso kudzera mu cortole, komabe, zimakhala zosavuta kuthana ndi malamulo akuluakulu, chifukwa mumangofunikira izi:
- Pambuyo kusamukira ku database, lowetsani nambala yotere:
Pangani mayeso a tebulo (
Konzani_kuyenera Chinsinsi cha Sicarial,
Mtundu varchar (50) osati wopanda pake,
Mtundu wa vani (25) osati wopanda pake,
Malo a valchar (25) Chongani (malo mu ('kumpoto', 'chakummwera', 'kumpoto', 'kumwera chakum'mawa', 'kumwera chakum'mawa'),
Kukhazikitsa_ tsiku.
);
Choyamba, dzina la tebulo loyeserera limafotokozedwa (mutha kusankha dzina lina lililonse). Zotsatirazi zikulongosola mzati uliwonse. Tasankha mayina amtundu wa vinyor ndi mtundu wina wowoneka bwino mwachitsanzo, mudzakhalanso ndi chisonyezo cha wina aliyense, koma pokhapokha ngati mukugwiritsa ntchito zilembo za Chilatini. Manambala omwe ali m'mabakaki ali ndi udindo wa kukula kwa mzati, omwe amakhudzana mwachindunji ndi data yomwe idayikidwa pamenepo.
- Mukalowa, zimangowonetsa tebulo pazenera pogwiritsa ntchito \ d.
- Mukuwona pulojekiti yosavuta yomwe ilibe zambiri.
- Zambiri zatsopanozi zimawonjezeredwa kudzera kuyika chilolezo choyeserera (mtundu, malo, malo, kukhazikitsa) miyambo ('slide', 'kumwera', '20182-24'); Choyamba onetsani dzina la tebulo, komabe mayeso, ndiye kuti mizati yonse yalembedwa, ndipo mfundo zake zimafotokozedwa m'mabakaki.
- Mutha kuwonjezera mzere wina, mwachitsanzo, ikani mayeso (mtundu, malo, malo, kukhazikitsa_mpoto ',' Eastterst ',' 2018-24 ');
- Thamangani tebulo kudzera mu chosankhidwa * kuchokera mayeso ;, kuti muyerekeze zotsatira zake. Monga mukuwonera, zonse zimakhazikitsidwa molondola ndipo zomwe zalembedwazi zimapangidwa molondola.
- Ngati mukufuna kuchotsa mtengo uliwonse, chitani izi kuchokera pakuyesa komwe kuli mtundu = 'slide' ;, pofotokoza gawo lomwe mukufuna.
Gawo 5: Ikani Phppgaadmin
Sikuti nthawi zonse kuwongolera kwa database kumachitika mosavuta kudzera mu cortole, motero ndibwino kukweza, ndikukhazikitsa mawonekedwe apadera a PHPPGADIN.
- Choyamba musanayambe "terminal", Tsitsani zosintha zaposachedwa za mailaburiya kudzera mu sudo apt-pezani zosintha.
- Ikani a Apache Sudo Apt-ikani APIP2 pa intaneti.
- Mukakhazikitsa, yesani ndi magwiridwe antchito ndi kulondola kwa syntax pogwiritsa ntchito Sudo Apache2ctl. Ngati china chake chalakwika, yang'anani cholakwika pofotokozera patsamba la Webusayiti ya APIAN.
- Thamangani seva polowa mu SuDo Sysctoctl yambani kuyambitsa Apache2.
- Tsopano popeza kugwira ntchito koyenera kwa seva kumaperekedwa, mutha kuwonjezera zigoli ya Phppgaadmin powatsitsa kuchokera kumalo osungirako a SuDo APT kukhazikitsa.
- Kenako, muyenera kusintha fayilo yosinthira pang'ono. Tsegulani kudzera munthawi yodziwika bwino pofotokoza gedit /tc/apachex2/conf-aailabs/phygadmin.conf. Ngati chikalatacho chikuwerengedwa kokha, muyenera kutchulapo sudo patsogolo pa GEDIT.
- Pamaso pa "chofunikira" kuyika # kuti muikenso ndemanga, kenako perekani chilolezo chonsecho. Tsopano kupeza adilesi idzatsegulidwa pazida zonse za network, osati pa PC ya komweko.
- Yambitsaninso ntchito ya Sudo Apache2 Refert Web Server ndipo imatha kupita kukagwira ntchito ndi postgresql.
Munkhaniyi, sitinkangoganiza kuti ndisanapatsetse, komanso kukhazikitsa kwa a Apache pa intaneti yomwe imagwiritsidwa ntchito mu pulogalamu yotsatira nyali kuphatikiza. Ngati mukufuna kuwonetsetsa kuti masamba anu agwiritsitse ntchito ndi mapulani ena, tikukulangizani kuti mudziwe ntchito zina powerenga nkhani yotsatirayi.
Wonenaninso: kukhazikitsa mapulogalamu a nyali ku Ubuntu