Tine maPostgres ipapo, asi ini handizive zvekuita nazvo (c)

Ichi chirevo kubva kune imwe yeshamwari dzangu uyo ​​pane imwe nguva akauya kwandiri nemubvunzo nezvePostgres. Ipapo takagadzirisa chinetso chake mumazuva akati uye, achinditenda, akawedzera kuti: “Zvakanaka kuva neDBA yaunoziva.”

Asi chii chekuita kana iwe usingazive DBA? Panogona kuve neakawanda sarudzo dzemhinduro, kubva pakutsvaga shamwari pakati peshamwari kusvika pakudzidza mubvunzo wega. Asi chero mhinduro inouya mupfungwa dzako, ndine nhau dzakanaka kwauri. Mune bvunzo mode, isu takatangisa kurudziro sevhisi yePostgres nezvese zvakaitenderedza. Chii ichi uye takasvika sei pakurarama seizvi?

Sei zvose izvi?

Postgres inenge isiri nyore, uye dzimwe nguva yakaoma zvikuru. Zvinoenderana nehuwandu hwekubatanidzwa uye mutoro.

Avo vanoshanda mumabasa vanofanirwa kuve nechokwadi chekuti Postgres sevhisi inoshanda nemazvo uye zvakadzikama - tarisa mashandisirwo ezviwanikwa, kuwanikwa, kukwana kwekugadziriswa, nguva nenguva kuita zvigadziriso uye kugara uchiongorora hutano. Avo vari mukuvandudza uye kunyora maapplication, kazhinji, vanofanirwa kutarisa kuti application inopindirana sei nedatabase uye kuti haigadziri mamiriro ekukurumidzira anogona kudzikisa dhatabhesi. Kana munhu asina rombo rakanaka kuti ave mutungamiriri wehunyanzvi / tekinoroji, saka zvakakosha kwaari kuti Postgres yese inoshanda zvakavimbika, inofanotaura uye haigadziri matambudziko, nepo zvichikurudzirwa kuti usanyura zvakadzama muPostgres kwenguva yakareba. .

Mune chero yezviitiko izvi, pane iwe uye Postgres. Kuti ushumire Postgres zvakanaka, unofanirwa kuve nekunzwisisa kwayo uye kunzwisisa kuti inoshanda sei. Kana Postgres isiri yakananga nyanzvi, saka unogona kupedza nguva yakawanda uchiidzidza. Zvakanaka, kana pane nguva uye chido, hazvisi nguva dzose zvakajeka kuti unotanga kupi, sei uye kupi kwekufamba.

Kunyangwe kana kutarisa kuchiiswa, izvo zvinofanirwa kufambisa basa, nyaya yeruzivo rwenyanzvi inoramba yakavhurika. Kuti ugone kuverenga nekunzwisisa magirafu, iwe uchiri kufanirwa kuve nekunzwisisa kwakanaka kwemashandiro anoita Postgres. Zvikasadaro, chero yekutarisa inoshanduka kuita inosuruvarisa mifananidzo uye spam kubva kune yambiro panguva dzisina kujairika dzezuva.

Zvombo yakangoitwa kuti Postgres ive nyore kushandisa. Iyo sevhisi inounganidza uye inoongorora data nezve Postgres uye inoita kurudziro pane izvo zvinogona kuvandudzwa.

Chinangwa chikuru chesevhisi ndechekupa mazano akajeka anopa pfungwa yezviri kuitika uye izvo zvinoda kuitwa zvinotevera.

Kune nyanzvi dzisina ruzivo rwehunyanzvi, zvinokurudzira zvinopa pekutangira kudzidziswa kwepamusoro. Kune nyanzvi dzepamusoro, kurudziro inoratidza mapoinzi anofanirwa kutariswa. Panyaya iyi, Weaponry inoshanda semubatsiri anoita mabasa enguva dzose kuwana matambudziko kana zvikanganiso zvinoda kutariswa zvakanyanya. Zvombo zvinogona kufananidzwa ne linter inotarisa Postgres uye inonongedza zvikanganiso.

Zvinhu zvakamira sei?

Panguva ino Zvombo iri mu test mode uye yemahara, kunyoreswa kunogumira kwenguva. Pamwe chete nevazvipiri vakati wandei, tiri kupedzisa injini yekurudziro pazvigadziko zvekurwa, tichiona manyepo uye tichishanda pane zvinyorwa zvekurudziro.

Nenzira, kurudziro ichiri kutwasanuka - vanongotaura zvekuita uye kuti ungazviita sei, pasina humwe humwe ruzivo - saka pakutanga uchafanirwa kutevedzera hukama kana Google iyo. Cheki uye kurudziro inovhara system uye zvigadziriso zvehardware, zvigadziriso zvePostgres pachayo, iyo yemukati schema, uye zviwanikwa zvinoshandiswa. Pachine zvinhu zvakawanda zvinoda kuwedzerwa muzvirongwa.

Uye zvechokwadi, isu tiri kutsvaga vanozvipira vakagadzirira kuyedza sevhisi uye kupa mhinduro. Isu tinewo demo, mungapinda muone. Kana iwe uchinzwisisa kuti iwe unoda izvi uye wakagadzirira kuedza, saka nyorera kwatiri mail.

Yakavandudzwa 2020-09-16. Kutanga.

Mushure mekunyoresa, mushandisi anokurudzirwa kugadzira purojekiti - iyo inokutendera kuti ubatanidze zviitiko zve database mumapoka. Mushure mekugadzira purojekiti, mushandisi anotungamirwa kune mirairo yekugadzirisa nekuisa mumiririri. Muchidimbu, iwe unofanirwa kugadzira vashandisi veajenti, wobva wadhawunirodha iyo agent yekumisikidza script uye woimhanyisa. Mune shell mirairo inotaridzika seizvi:

psql -c "CREATE ROLE pgscv WITH LOGIN SUPERUSER PASSWORD 'A7H8Wz6XFMh21pwA'"
export PGSCV_PG_PASSWORD=A7H8Wz6XFMh21pwA
curl -s https://dist.weaponry.io/pgscv/install.sh |sudo -E sh -s - 1 6ada7a04-a798-4415-9427-da23f72c14a5

Kana iyo host ine pgbouncer, saka iwe zvakare uchafanirwa kugadzira mushandisi kuti abatanidze mumiririri. Iyo chaiyo nzira yekumisikidza mushandisi mupgbouncer inogona kuchinjika uye inotsamira zvakanyanya pakugadziriswa kunoshandiswa. Muzhinji mazwi, iyo setup inosvika pakuwedzera mushandisi kune stats_users configuration file (kazhinji pgbouncer.ini) uye kunyora password (kana hashi yayo) kune faira rakatsanangurwa muparameter auth_file. Kana ukachinja stats_users, unozofanira kutangazve pgbouncer.

Iyo install.sh script inotora akati wandei emakakatanwa anodiwa ayo akasiyana kune yega yega purojekiti, uye kuburikidza nemamiriro ekunze anosiyana anogashira ruzivo rwevashandisi vakagadzirwa. Tevere, iyo script inotanga mumiririri mubootstrap modhi - mumiriri anozvikopa kuPATH, anogadzira gadziriso ine ruzivo, systemd unit uye inotanga se systemd sevhisi.
Izvi zvinopedzisa kuiswa. Mukati memaminetsi mashoma, iyo dhatabhesi muenzaniso ichaonekwa mune rondedzero yevaenzi mune iyo interface uye iwe unogona kutotarisa kune ekutanga kurudziro. Asi chinhu chakakosha ndechekuti kurumbidza kwakawanda kunoda huwandu hukuru hwema metrics akaunganidzwa (zvishoma pazuva).

Source: www.habr.com