Nov yog ib nqe lus los ntawm ib tug ntawm kuv cov phooj ywg uas ib zaug dhau los tuaj cuag kuv nrog cov lus nug txog Postgres. Tom qab ntawd peb daws nws qhov teeb meem hauv ob peb hnub thiab, ua tsaug rau kuv, nws hais ntxiv: "Nws yog qhov zoo uas muaj DBA paub."
Tab sis yuav ua li cas yog tias koj tsis paub DBA? Nws tuaj yeem muaj ntau txoj kev xaiv teb, xws li nrhiav cov phooj ywg ntawm cov phooj ywg los kawm cov lus nug koj tus kheej. Tab sis txawm teb li cas los rau hauv koj lub siab, kuv muaj xov xwm zoo rau koj. Hauv kev sim hom, peb tau pib qhov kev pom zoo rau Postgres thiab txhua yam nyob ib puag ncig nws. Qhov no yog dab tsi thiab ua li cas peb thiaj tuaj nyob zoo li no?
Vim li cas tag nrho cov no?
Postgres tsawg kawg yog tsis yooj yim, thiab qee zaum nyuaj heev. Nyob ntawm qhov degree ntawm kev koom tes thiab lub luag haujlwm.
Cov neeg ua haujlwm hauv kev ua haujlwm yuav tsum tau ua kom ntseeg tau tias Postgres ua haujlwm ua haujlwm zoo thiab ruaj khov - saib xyuas kev siv cov peev txheej, muaj, tsim nyog ntawm kev teeb tsa, ua ntu zus thiab kuaj xyuas kev noj qab haus huv tsis tu ncua. Cov neeg uas tab tom txhim kho thiab sau cov ntawv thov, feem ntau, yuav tsum tau saib xyuas seb daim ntawv thov cuam tshuam nrog cov ntaub ntawv li cas thiab nws tsis tsim cov xwm txheej kub ntxhov uas tuaj yeem ua rau cov ntaub ntawv poob. Yog tias ib tug neeg tsis muaj hmoo txaus los ua tus thawj coj ua haujlwm / kws tshaj lij, nws yog qhov tseem ceeb rau nws tias Postgres ua haujlwm tag nrho ntseeg tau, kwv yees thiab tsis tsim teeb meem, thaum nws raug nquahu kom tsis txhob dhia tob rau hauv Postgres ntev. .
Hauv ib qho ntawm cov xwm txheej no, muaj koj thiab Postgres. Txhawm rau pab Postgres zoo, koj yuav tsum muaj kev nkag siab zoo txog nws thiab nkag siab tias nws ua haujlwm li cas. Yog tias Postgres tsis yog qhov tshwj xeeb ncaj qha, ces koj tuaj yeem siv sijhawm ntau los kawm nws. Qhov zoo tshaj plaws, thaum muaj sijhawm thiab lub siab xav, nws tsis yog ib txwm paub meej tias yuav pib qhov twg, yuav ua li cas thiab txav mus rau qhov twg.
Txawm hais tias kev soj ntsuam yog qhia, uas nyob rau hauv txoj kev xav yuav tsum pab txhawb kev ua haujlwm, qhov teeb meem ntawm cov kws paub txog kev paub tseem qhib. Yuav kom nyeem tau thiab nkag siab cov duab, koj tseem yuav tsum muaj kev nkag siab zoo txog Postgres ua haujlwm li cas. Tsis tas li ntawd, ib qho kev saib xyuas hloov mus rau hauv cov duab tu siab thiab spam los ntawm kev ceeb toom ntawm lub sijhawm random ntawm ib hnub.
tsuas yog ua kom Postgres yooj yim siv. Cov kev pabcuam sau thiab txheeb xyuas cov ntaub ntawv hais txog Postgres thiab ua cov lus pom zoo txog qhov tuaj yeem txhim kho.
Lub hom phiaj tseem ceeb ntawm kev pabcuam yog muab cov lus pom zoo uas muab lub tswv yim ntawm qhov tshwm sim thiab qhov yuav tsum tau ua tom ntej.
Rau cov kws tshaj lij uas tsis muaj kev paub txog kev txawj ntse, cov lus pom zoo muab lub ntsiab lus pib rau kev cob qhia qib siab. Rau cov kws tshaj lij, cov lus pom zoo qhia cov ntsiab lus uas yuav tsum tau them rau. Hauv qhov no, Weaponry ua tus pab cuam uas ua haujlwm niaj hnub nrhiav teeb meem lossis qhov tsis txaus uas yuav tsum tau saib xyuas tshwj xeeb. Riam phom tuaj yeem muab piv rau lub linter uas kuaj Postgres thiab taw qhia qhov tsis zoo.
Tam sim no cov khoom zoo li cas?
Thaum lub sijhawm no yog nyob rau hauv kev xeem hom thiab dawb xwb, rau npe yog ib ntus txwv. Ua ke nrog ntau tus neeg tuaj yeem pab dawb, peb tab tom ua tiav cov lus pom zoo ntawm lub hauv paus kev sib ntaus sib tua ze, txheeb xyuas qhov tsis zoo thiab ua haujlwm ntawm cov ntawv ntawm cov lus pom zoo.
Los ntawm txoj kev, cov lus pom zoo tseem yog qhov yooj yim heev - lawv tsuas yog hais tias yuav ua li cas thiab yuav ua li cas, tsis muaj cov ntsiab lus ntxiv - yog li thaum xub thawj koj yuav tau ua raws li cov kev sib txuas lossis Google nws. Kev txheeb xyuas thiab cov lus pom zoo suav nrog kev teeb tsa thiab kho vajtse, teeb tsa ntawm Postgres nws tus kheej, cov txheej txheem sab hauv, thiab cov peev txheej siv. Tseem muaj ntau yam uas yuav tsum tau ntxiv rau hauv cov phiaj xwm.
Thiab tau kawg, peb tab tom nrhiav rau cov neeg tuaj yeem pab dawb uas npaj siab sim cov kev pabcuam thiab muab cov lus qhia. Peb kuj muaj , koj tuaj yeem nkag mus saib. Yog tias koj nkag siab tias koj xav tau qhov no thiab npaj siab sim, thov sau ntawv rau peb ntawm .
Kho tshiab 2020-09-16. pib.
Tom qab sau npe, tus neeg siv raug ceeb toom los tsim ib qhov project - uas tso cai rau koj los muab cov ntaub ntawv piv txwv rau hauv pab pawg. Tom qab tsim ib qhov project, tus neeg siv tau qhia rau cov lus qhia rau kev teeb tsa thiab txhim kho tus neeg sawv cev. Hauv kev txiav txim siab, koj yuav tsum tsim cov neeg siv rau tus neeg sawv cev, tom qab ntawd rub tawm tus neeg sawv cev sau tsab ntawv thiab khiav nws. Hauv plhaub commands nws zoo li no:
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-da23f72c14a5Yog tias tus tswv tsev muaj pgbouncer, ces koj kuj yuav tau tsim ib tus neeg siv los txuas tus neeg sawv cev. Txoj hauv kev tshwj xeeb los teeb tsa tus neeg siv hauv pgbouncer tuaj yeem hloov pauv tau yooj yim thiab nyob ntawm qhov kev teeb tsa siv. Hauv cov ntsiab lus dav dav, kev teeb tsa los ntawm kev ntxiv tus neeg siv rau stats_users configuration file (feem ntau pgbouncer.ini) thiab sau tus password (lossis nws hash) rau cov ntaub ntawv teev tseg hauv qhov ntsuas auth_file. Yog tias koj hloov stats_users, koj yuav tsum rov pib pgbouncer.
Cov ntawv install.sh siv ob peb qhov kev sib cav uas yuav tsum tau ua tshwj xeeb rau txhua qhov haujlwm, thiab los ntawm ib puag ncig hloov pauv nws lees txais cov ntsiab lus ntawm cov neeg siv tsim. Tom ntej no, tsab ntawv pib tus neeg sawv cev hauv hom bootstrap - tus neeg sawv cev luam tawm nws tus kheej mus rau PATH, tsim ib qho kev teeb tsa nrog cov ntsiab lus, ib chav systemd thiab pib ua qhov kev pabcuam systemd.
Qhov no ua tiav lub installation. Tsis pub dhau ob peb feeb, qhov piv txwv database yuav tshwm sim hauv cov npe ntawm cov tswv hauv lub interface thiab koj tuaj yeem saib thawj cov lus pom zoo. Tab sis lub ntsiab lus tseem ceeb yog tias ntau cov lus pom zoo yuav tsum muaj ntau tus lej ntsuas (tsawg kawg ib hnub).
Tau qhov twg los: www.hab.com