PostgreSQL運用管理入門

1PTUHSF42-ӡ༻؅ཧ ೖ໳ :PTIJZVLJ"TBCB

಺༰ w JOJUECͳͲجຊతͳͱ͜Ζ w QSPDFTTߏ੒ w XBMͳͲͷ෺ཧϑΝΠϧ w -0$, w
7"$66."/"-:;&3&*/%&9 w &91-"*/ͷݟํ w CBDLVQSFQMJDBUJPO w TPVSDFDPEFSFBEJOH

όʔδϣϯ൪߸ w 1PTUHSF42-YZ[ͱ͍͏όʔδϣϯ൪߸͕෇͘ w YZ͕ϝδϟʔόʔδϣϯ ͕ϕʔλ൛ w جຊతʹσʔλϕʔεͷ෺ཧϑΝΠϧʹޓ׵ੑ͕ͳ͍ w
[͕ϚΠφʔόʔδϣϯ w CVHpY͕த৺ w ͨ·ʹηΩϡϦςΟ໰୊ͱ͔ͰɺTZTUFNDBUBMPHΛॻ ͖׵͑ͳ͍ͱ͍͚ͳ͍͜ͱ΋͋Δ

σʔλϕʔεͷॳظԽ w JOJUECίϚϯυ w ࢦఆͨ͠σΟϨΫτϦʹඞཁͳϑΝΠϧΛҰࣜ࡞੒ w ઃఆϑΝΠϧ΋ੜ੒͞ΕΔ w JOJUEC࣮ߦͨ͠Ϣʔβ1PTUHSF42-ͷεʔύʔϢʔβ w
஫ҙɿMPDBMF͸$ʹ͓ͯ͘͠ͱ༨ܭͳτϥϒϧΛճආ Ͱ͖Δ DSFBUFECͰ΋MPDBMFΛઃఆ͢Δ͜ͱ͸Մೳ

ઃఆϑΝΠϧ w QPTUHSFTRMDPOG w 1PTUHSF42-ຊମͷઃఆ w QH@ICBDPOG w ೝূͷઃఆ w
SFDPWFSZDPOG w ͋ͱͰઆ໌ w QH@JEFOUDPOG w ΄ͱΜͲ࢖Θͳ͍ͷͰলུ

QPTUHSFTRMDPOG w NFNPSZ΍MPHHJOHͳͲ༷ʑͳઃఆ͕Մೳ w σϑΥϧτͷઃఆ͸࢖͍΋ͷʹͳΒͳ͍ͷͰɺมߋ ͕ඞཁ w ઃఆมߋ͸SFMPBEͰࡁΉ΋ͷ΍ɺSFTUBSU͕ඞཁͳ ෺͕͋ΔͷͰ஫ҙ

QH@ICBDPOG w Ͳ͔͜Βͷ઀ଓΛڐՄ͢ΔͳͲΛهड़ w UZQF EBUBCBTF VTFS BEESFTT NFUIPE w
NFUIPE͸USVTU SFKFDU NE DMFBSͳͲ MPDBMJTGPS6OJYEPNBJOTPDLFUDPOOFDUJPOTPOMZ MPDBMBMMBMMUSVTU *1WMPDBMDPOOFDUJPOT IPTUBMMBMMUSVTU *1WMPDBMDPOOFDUJPOT IPTUBMMBMMUSVTU IPTUUFTUUFTUNE VOJYEPNBJO TPDLFU 5$1

LFSOFMͷઃఆ w ڞ༗ϝϞϦΛ֬อ͢ΔͷͰɺ্ݶΛมߋ͢Δඞཁ͋ Γ w LFSOFMTINNBY w LFSOFMTINBMM FUDTZTDUMDPOG LFSOFMTINNBY
LFSOFMTINBMM TVEPTZTDUMQ

ىಈɾఀࢭ w QH@DUMίϚϯυΛ࢖͏ w QH@DUM%JOJUECͨ͠৔ॴ\TUBSUcTUPQcSFMPBEc SFTUBSUcQSPNPUF^ w VCVOUVͰ͋Ε͹TVEPTFSWJDFQPTUHSFTRM SFMPBE\TUBSUcTUPQcSFMPBEcSFTUBSU^

QSPDFTTߏ੒

ϓϩηε w ϚϧνϓϩηεΞʔΩςΫνϟ w ϓϩηεؒ௨৴͸QJQF TINFN TJHOBM TPDLFU w ਌ϓϩηε͸QPTUNBTUFSͱݺ͹ΕΔ
w جຊతʹ͸ఀࢭ΍SFMPBE͸QPTUNBTUFSʹTJHOBMΛ౤͛Δ w શͯͷࢠϓϩηε͸QPTUNBTUFS͔ΒGPSL ͞ΕΔ VTSMJCQPTUHSFTRMCJOQPTUHSFT%WBSMJCQPTUHSFTRMNBJOD DPOpH@pMFFUDQPTUHSFTRMNBJOQPTUHSFTRMDPOG a@QPTUHSFTDIFDLQPJOUFSQSPDFTT a@QPTUHSFTXSJUFSQSPDFTT a@QPTUHSFTXBMXSJUFSQSPDFTT a@QPTUHSFTBVUPWBDVVNMBVODIFSQSPDFTT a@QPTUHSFTTUBUTDPMMFDUPSQSPDFTT a@QPTUHSFTQPTUHSFTUFTU<MPDBM>JEMF

ϓϩηεҰཡ QPTUNBTUFS ઀ଓड͚෇͚Δ਌ϓϩηε CBDLFOE 42-Λॲཧ͢Δϓϩηε XBMXSJUFS 8"-Λఆظతʹॻ͖ͩ͢ϓϩηε CBDLHSPVOEXSJUFS ڞ༗όοϑΝΛఆظతʹॻ͖ͩ͢ϓϩηε ʢੲ͸$)&$,10*/5΋࣮ߦ͍ͯͨ͠ʣ
TUBUTDPMMFDUPS ౷ܭ৘ใΛ6%1Ͱड͚Δϓϩηε BVUPWBDVVN WBDVVN΍BOBMZ[FΛ͋Δᮢ஋௒͑ͨΒ࣮ߦ͢Δϓϩηε BSDIJWFS XBMΛͲ͔͜ʹίϐʔ͢ΔͨΊͷϓϩηε XBMTFOEFS TUSFBNJOHSFQMJDBUJPOͷૹΔଆ XBMSFDFJWFS TUSFBNJOHSFQMJDBUJPOΛड͚Δଆ DIFDLQPJOUFS $)&$,10*/5Λ࣮ߦ͢Δϓϩηε

γάφϧ w QPTUNBTUFS 4*(5&3. શΫϥΠΞϯτ͕ऴྃ͢Δ·Ͱ଴ͭ TNBSUTIVUEPXO 4*(*/5 ઀ଓதͷΫϥΠΞϯτͷτϥϯβΫγϣϯΛBCPSUͯ͠ TIVUEPXO GBTUTIVUEPXO
4*(26*5 ڧ੍ऴྃ JNNFEJBUFTIVUEPXO ࣍ճͷىಈ࣌ʹϦΧόϦ͕૸Δ w QPTUHSFT CBDLFOEQSPDFTT 4*(5&3. ΫΤϦΛΩϟϯηϧ͠ɺϓϩηεΛऴྃ͢Δ 4*(*/5 ΫΤϦΛΩϟϯηϧ͢Δ͚ͩ 4*(26*5 ڧ੍ऴྃ QPTUNBTUFSҎ֎ͷϓϩηε͕࠶ىಈ͔͔Δ

ϝϞϦ w ڞ༗ϝϞϦ w ڞ༗όοϑΝɺ8"-όοϑΝɺෳ਺ϓϩηεͰڞ༗͞ ΕΔ಺෦σʔλ w ώʔϓϝϞϦ w TPSU౳ͷΫΤϦ࣮ߦ࣌ʹ࢖ΘΕΔϓϩηεݻ༗ͷ࡞ۀ
ۭؒ

ڞ༗ϝϞϦ w ىಈ࣌ʹ·ͱΊͯΨπϯͱ֬อ w TIBSFECV⒎FS w 8"-CV⒎FS w -0$,ྖҬ w
͔Βڍಈ͕มΘΔ͔΋ʁ <WBHSBOU!QSFDJTF>dIFBEEBUBJQDTB 4IBSFE.FNPSZ4FHNFOUT LFZTINJEPXOFSQFSNTCZUFTOBUUDITUBUVT YGFWBHSBOU 4FNBQIPSF"SSBZT LFZTFNJEPXOFSQFSNTOTFNT YGFWBHSBOU YGFBWBHSBOU YGFCWBHSBOU YGFDWBHSBOU YGFEWBHSBOU YGFFWBHSBOU YGFGWBHSBOU YGFWBHSBOU

ڞ༗όοϑΝ w ͢΂ͯͷσʔλૢ࡞͸ඞͣڞ༗όοϑΝΛ௨Δ w ૢ࡞͸ϒϩοΫ ,# ୯Ґ ڞ༗όοϑΝ ෺ཧϑΝ Πϧ
෺ཧϑΝ Πϧ ෺ཧϑΝ Πϧ QPTUHSFT QPTUHSFT 8"- $-0( XSJUF SFBEXSJUF

NPOJUPSJOH

౷ܭ৘ใऩूϓϩηε w 1PTUHSF42-ࣗ਎ͰɺͲΜͳॲཧΛͲΕ͚͔ͩͨ͠ ͳͲΛه࿥͍ͯ͠Δ w BVUPWBDVVN͸͜ͷσʔλΛݟ͍ͯΔ w TUBUTDPMMFDUPSQSPDFTT͕ͦͷϓϩηε w IUUQXXXQPTUHSFTRMKQEPDVNFOUIUNM
NPOJUPSJOHTUBUTIUNM

NPOJUPSJOHྫ w ઀ଓதͷϢʔβ਺Λௐ΂Δ w 4&-&$5 '30.QH@TUBU@BDUJWJUZ w Ωϟογϡώοτ཰Λௐ΂Δ w UFTU%#ͷ৘ใΛݟΔ
UFTUTFMFDUIFBQ@CMLT@IJUOVNFSJD IFBQ@CMLT@SFBE IFBQ@CMLT@IJU OVNFSJDGSPN QH@TUBUJP@VTFS@UBCMFTXIFSFIFBQ@CMLT@SFBE UFTUTFMFDU GSPNQH@TUBU@EBUBCBTFXIFSFEBUOBNFUFTU

ϩοΫͷཻ౓ w TQJOMPDL w -8-0$, MJHIUXFJHIUMPDL w ߦϩοΫ w
ςʔϒϧϩοΫ

TQJOMPDL w Ұ൪టष͍ॴ w $16ΞʔΩςΫνϟ͝ͱʹΞηϯϒϦݴޠͰॻ͔ Ε͍ͯΔ w T@MPDLI w ͱͯ΋୹͍ظ͚ؒͩऔΓ͍ͨϩοΫ
w 4QJO-PDL"DRVJSF4QJO-PDL3FMFBTF

-8-PDL w TQJOMPDLΑΓ͸ॏ͍ɺ಺෦తͳϩοΫ w TQJOMPDLͱTFNBQIPSFΛ࢖࣮ͬͯ૷

ߦϩοΫ w ߦʹର͔͔ͯ͠ΔϩοΫ w Ϣʔβ͕ҙࣝ͢Δ͜ͱ͕Ͱ͖ΔϩοΫ w ߦϩοΫ͸ڞ༗ϩοΫͱഉଞϩοΫͷछྨ w ڞ༗ϩοΫ͸SFBE͸ಉ࣌ʹͰ͖Δ͕ɺഉଞϩο Ϋ͕ೖΔͱϒϩοΫ͞ΕΔ

໌ࣔతͳߦϩοΫ w ഉଞϩοΫ w 4&-&$5ʜ'0361%"5& w ڞ༗ϩοΫ w 4&-&$5ʜ'034)"3&

ςʔϒϧϩοΫ ϩοΫ໊ ڝ߹ "$$&444)"3& "$$&44&9$-64*7& 3084)"3& &9$-64*7&͓Αͼ"$$&44&9$-64*7& 308&9$-64*7& 4)"3&ɺ4)"3&308&9$-64*7&ɺ&9$-64*7&ɺ͓ Αͼ"$$&44&9$-64*7&ϩ
4)"3&61%"5&&9$-64*7& 4)"3&61%"5&&9$-64*7&ɺ4)"3&ɺ4)"3&308 &9$-64*7&ɺ&9$-64*7&ɺ͓Αͼ"$$&44 4)"3& 308&9$-64*7&ɺ4)"3&61%"5&&9$-64*7&ɺ 4)"3&308&9$-64*7&ɺ&9$-64*7&ɺ͓Αͼ 4)"3&308&9$-64*7& 308&9$-64*7&ɺ4)"3&61%"5&&9$-64*7&ɺ 4)"3&ɺ4)"3&308&9$-64*7&ɺ&9$-64*7&ɺ͓ &9$-64*7& "$$&44&9$-64*7& IUUQXXXQPTUHSFTRMKQEPDVNFOUIUNMFYQMJDJUMPDLJOHIUNM

QH@MPDLT w ςʔϒϧϩοΫΛ୭͕औ͍ͬͯΔ͔ΛݟΔ͜ͱ͕Ͱ ͖ΔϏϡʔ UFTUCFHJO #&(*/ UFTUMPDLUBCMFTUPSF -0$,5"#-& UFTUTFMFDU GSPNQH@MPDLT
MPDLUZQFcEBUBCBTFcSFMBUJPOcQBHFcUVQMFcWJSUVBMYJEcUSBOTBDUJPOJEcDMBTTJEcPCKJEcPCKTVCJEc WJSUVBMUSBOTBDUJPOcQJEcNPEFcHSBOUFEcGBTUQBUI SFMBUJPOcccccccccccc "DDFTT4IBSF-PDLcUcU WJSUVBMYJEcccccccccccc &YDMVTJWF-PDLcUcU SFMBUJPOcccccccccccc "DDFTT&YDMVTJWF-PDLcUcG SPXT

σουϩοΫݕग़ w QPTUHSFTRMDPOGͷEFBEMPDL@UJNFPVUͷִؒͰσουϩοΫΛݕग़ w ϩοΫάϥϑΛUPQPMPHJDBMTPSU w ॏ͍ͷͰඵʹઃఆͯ͋͠Δ EFGBVMUඵ UFTUCFHJO #&(*/
UFTUMPDLUBCMFU -0$,5"#-& UFTUMPDLUBCMFU -0$,5"#-& UFTU UFTUCFHJO #&(*/ UFTUMPDLUBCMFU -0$,5"#-& UFTUMPDLUBCMFU &3303EFBEMPDLEFUFDUFE %&5"*-1SPDFTTXBJUTGPS"DDFTT&YDMVTJWF-PDLPO SFMBUJPOPGEBUBCBTFCMPDLFECZQSPDFTT 1SPDFTTXBJUTGPS"DDFTT&YDMVTJWF-PDLPOSFMBUJPO PGEBUBCBTFCMPDLFECZQSPDFTT )*/54FFTFSWFSMPHGPSRVFSZEFUBJMT

ϩοΫपΓͷτϥϒϧ w αʔό͕៉ྷʹμ΢ϯ͠ͳ͔ͬͨ৔߹ w όοναʔό͕00.Ͱམͪͯ͠·ͬͨ w ˠLFFQBMJWFͷઃఆΛ୹͘͢Δ UDQ@LFFQBMJWFT@JEMF5$1@,&&1*%-& JOTFDPOET TFMFDUTUIFTZTUFNEFGBVMU
UDQ@LFFQBMJWFT@JOUFSWBM5$1@,&&1*/57- JOTFDPOET TFMFDUTUIFTZTUFNEFGBVMU UDQ@LFFQBMJWFT@DPVOU5$1@,&&1$/5 TFMFDUTUIFTZTUFNEFGBVMU

7"$66. "/"-:;&3&*/%&9

7"$66.ͷඞཁੑ w .7$$࢖ͬͯτϥϯβΫγϣϯΛ࣮૷͍ͯ͠ΔͨΊ w ݱࡏͷUSBOTBDUJPOJEͱɺߦʹຒ·͍ͬͯΔYNJO΍QH@DMPHͳͲ͔Βɺͦͷߦ͕ݟ͑ͯ΋ྑ͍͔ Λ൑அ NVMUJYBDUͱ͔Α͘Θ͔Βͳ͍֓೦͕ೖ͖ͬͯͯɺ΋ͬͱෳࡶ w ෆཁྖҬͷճऩΛ7"$66.͕ߦ͏
UFTUCFHJO #&(*/ UFTUJOTFSUJOUPUWBMVFT */4&35 UFTUJOTFSUJOUPUWBMVFT */4&35 UFTUDPNNJU $0..*5 UFTUTFMFDUYNJO DNJO YNBY DNBY BGSPNU YNJOcDNJOcYNBYcDNBYcB cccc cccc SPXT UFTUTFMFDUYNJO DNJO YNBY DNBY BGSPNU YNJOcDNJOcYNBYcDNBYcB cccc cccc SPXT */4&35 %&-&5& ࣮ࡍʹ͸࡟আ͞Εͣʹ࢒Δ

9*%पճ໰୊ w τϥϯβΫγϣϯ*%͸? VOTJHOFEJOU w ͳͷͰΦʔόʔϑϩʔ͢ΔՄೳੑ͋Δ w ͪΌΜͱରࡦͯ͋͠Δ w
BVUPWBDVVN͕উखʹ9*%पճ໰୊Λճආ͢Δ7"$66.Λྲྀ͢ UFTUWBDVVNGSFF[FU 7"$66. UFTUTFMFDUYNJO DNJO YNBY DNBY BGSPNU YNJOcDNJOcYNBYcDNBYcB cccc cccc SPXT

)0561%"5& w ಛఆͷ৚݅Λຬͨ͢ͱ)0561%"5&ͱ͍͏ॲཧ͕૸Γɺ7"$66.Λ ͤͣʹෆཁྖҬΛճऩ͢Δ w ৄ͘͠͸ͪ͜Β w IUUQMFUTQPTUHSFTRMKQEPDVNFOUTUVUPSJBMIPU@ w ͬ͘͟Γ͍͏ͱ
w ֤ϖʔδΛߋ৽༻ʹগ͠εϖʔεΛ։͚͓ͯ͘ pMMGBDUPSΛઃఆ͢Δ w ΠϯσοΫεష͍ͬͯͳ͍ߦΛߋ৽͢Δ͜ͱ w τϥϯβΫγϣϯΛ։͖ͬͺͳ͠ʹ͠ͳ͍

7"$66.νϡʔχϯά w NBJOUFOBODF@XPSL@NFN w Ίͬͨʹ࢖Θͳ͍ͷͰɺଟΊʹઃఆ͓͍ͯͯ͠Α͍ w WBDVVN@DPTU@ w ͪΜͨΒ7"$66.Λಈ͔͢ઃఆ
w *0ͷϐʔΫΛආ͚͍ͨ৔߹ʹઃఆ

"/"-:;& w ֤ςʔϒϧͷΧϥϜ͝ͱʹͲ͏͍͏σʔλ͕͋Δ͔ɺ ͱ͍͏౷ܭ৘ใΛ͍࣋ͬͯΔ w QH@TUBUTͱ͍͏ϏϡʔͰ֬ೝͰ͖Δ

QH@TUBUTྫ w NPTUDPNNPO@WBMT w Α͘ग़ͯ͘Δ஋Λ͍࣋ͬͯΔ w Α͘ग़ͯ͘Δ஋Ͱ͋Ε͹ɺQMBOOFS͸TFRTDBOͷ΄͏͕଎͍ͱ൑அ͢Δ͜ͱ΋͋Δ UFTUTFMFDU GSPNQH@TUBUTXIFSFUBCMFOBNFU <3&$03%>
TDIFNBOBNFcQVCMJD UBCMFOBNFcU BUUOBNFcB JOIFSJUFEcG OVMM@GSBDc BWH@XJEUIc O@EJTUJODUc NPTU@DPNNPO@WBMTc\ ^ NPTU@DPNNPO@GSFRTc\ ^ IJTUPHSBN@CPVOETc DPSSFMBUJPOc NPTU@DPNNPO@FMFNTc NPTU@DPNNPO@FMFN@GSFRTc FMFN@DPVOU@IJTUPHSBNc ࠷ස஋ ׂ߹ UFTUJOTFSUJOUPUTFMFDUJGSPN HFOFSBUF@TFSJFT BTJ */4&35 UFTUBOBMZ[F

QH@TUBUTྫ w IJTUPHSBN@CPVOET w ίετݟੵ΋Γͷͱ͖ʹɺ΍CFUXFFOͰͲΕ͘Β͍ߦ͕͋Δ͔Λਪఆ͢Δ UFTUTFMFDU GSPNQH@TUBUTXIFSFUBCMFOBNFU <3&$03%>
TDIFNBOBNFcQVCMJD UBCMFOBNFcU BUUOBNFcB JOIFSJUFEcG OVMM@GSBDc BWH@XJEUIc O@EJTUJODUc NPTU@DPNNPO@WBMTc NPTU@DPNNPO@GSFRTc IJTUPHSBN@CPVOETc \ ʜ DPSSFMBUJPOc NPTU@DPNNPO@FMFNTc NPTU@DPNNPO@FMFN@GSFRTc FMFN@DPVOU@IJTUPHSBNc

QH@TUBUTྫ w DPSSFMBUJPO w ෺ཧతʹͲ͏͍͏ॱ൪ͰฒΜͰ͍Δ͔ w ঢॱͰฒΜͰ͍Ε͹͍Δ΄Ͳʹۙͮ͘ w ߱ॱͰฒΜͰ͍Ε͹͍Δ΄Ͳʹۙͮ͘ w
ϥϯμϜͩͱʹۙͮ͘

3&*/%&9 w ·ΕʹΠϯσοΫεյΕͨΓɺΠϯσοΫε͕ංେ Խ͢Δ͜ͱ͕͋ΔͷͰɺ࡞Γͳ͓͢ίϚϯυ w ςʔϒϧϩοΫͱΔͷͰɺ৔߹ʹΑͬͯ͸%301 */%&9͔ͯ͠Β$3&"5&*/%&9$0/$633&/5-: Ͱ࡞Δ΄͏͕ఀࢭ͕࣌ؒগͳ͍͔΋

BVUPWBDVVN w σʔϞϯϓϩηεͰɺߋ৽ස౓ʹΑͬͯࣗಈతʹ 7"$66.Λಈ͔͢ w UISFTIPME͸ςʔϒϧ୯ҐͰઃఆՄೳ BVUPWBDVVNPO&OBCMFBVUPWBDVVNTVCQSPDFTT PO SFRVJSFTUSBDL@DPVOUTUPBMTPCFPO MPH@BVUPWBDVVN@NJO@EVSBUJPOEJTBCMFT
MPHTBMMBDUJPOTBOE UIFJSEVSBUJPOT MPHTPOMZ BDUJPOTSVOOJOHBUMFBTUUIJTOVNCFS PGNJMMJTFDPOET BVUPWBDVVN@NBY@XPSLFSTNBYOVNCFSPGBVUPWBDVVN TVCQSPDFTTFT DIBOHFSFRVJSFTSFTUBSU BVUPWBDVVN@OBQUJNFNJOUJNFCFUXFFOBVUPWBDVVNSVOT BVUPWBDVVN@WBDVVN@UISFTIPMENJOOVNCFSPGSPXVQEBUFTCFGPSF WBDVVN BVUPWBDVVN@BOBMZ[F@UISFTIPMENJOOVNCFSPGSPXVQEBUFTCFGPSF BOBMZ[F BVUPWBDVVN@WBDVVN@TDBMF@GBDUPSGSBDUJPOPGUBCMFTJ[FCFGPSF WBDVVN BVUPWBDVVN@BOBMZ[F@TDBMF@GBDUPSGSBDUJPOPGUBCMFTJ[FCFGPSFBOBMZ[F BVUPWBDVVN@GSFF[F@NBY@BHFNBYJNVN9*%BHFCFGPSF GPSDFEWBDVVN DIBOHFSFRVJSFTSFTUBSU BVUPWBDVVN@WBDVVN@DPTU@EFMBZNTEFGBVMUWBDVVNDPTUEFMBZGPS BVUPWBDVVN JONJMMJTFDPOET NFBOTVTFWBDVVN@DPTU@EFMBZ BVUPWBDVVN@WBDVVN@DPTU@MJNJUEFGBVMUWBDVVNDPTUMJNJUGPS BVUPWBDVVN NFBOTVTF WBDVVN@DPTU@MJNJU

ΫΤϦνϡʔχϯά

جຊతͳઓུ w ઈରతͳΫΤϦ࣮ߦ͚࣌ؒͩΛݟͯɺνϡʔχϯά ର৅ͷΫΤϦΛ୳͞ͳ͍ w ඵ͔͔͍ͬͯΔΫΤϦ͕Ұ೔Ұճ͔͠ͳ͍৔ ߹͸ɺ૬खʹ͠ͳͯ͘ྑ͍ w શମͷ͏ͪʹ্ҐԿ͔઎Ί͍ͯΔΫΤϦΛ௵͢ ΂͖
w OFXSFMJDศར

&91-"*/ w νϡʔχϯάର৅ͱͳΔΫΤϦ͕Ͳ͏΍࣮ͬͯߦ͞ ΕΔ͔Λ֬ೝ͢Δ w &91-"*/ͱ&91-"*/"/"-:;& w "/"-:;&Λ͚ͭΔͱɺ࣮ࡍʹΫΤϦΛ࣮ߦ͠ ͯɺͲ͜ʹͲΕ͚͔͔͔ͩ࣌ؒͬͨΛදࣔ w
&91-"*/͸ίετΛग़͢ͷΈ

ྫ UFTUFYQMBJOTFMFDU GSPNUXIFSFB 26&3:1-"/ *OEFY0OMZ4DBOVTJOHU@BPOU DPTUSPXTXJEUI *OEFY$POE B
SPXT UFTUFYQMBJOBOBMZ[FTFMFDU GSPNUXIFSFB 26&3:1-"/ *OEFY0OMZ4DBOVTJOHU@BPOU DPTUSPXTXJEUI BDUVBMUJNF SPXTMPPQT *OEFY$POE B )FBQ'FUDIFT 5PUBMSVOUJNFNT SPXT

UBCMFTDBO w TFRTDBO w ςʔϒϧΛ্͔ΒԼ·ͰશͯεΩϟϯ͢Δ w JOEFYTDBO w ΠϯσοΫεܦ༝ͰσʔλΛϑΣον w
ΠϯσοΫε͸CUSFF΍(*/ͳͲ৭ʑ͋Δ w CJUNBQTDBOͱ͍͏ΠϯσοΫεΛ૊Έ߹ΘͤΔ  ϓϥϯ΋͋Δ w JOEFYPOMZTDBO w ΠϯσοΫε͚ͩΛݟͯσʔλΛϑΣον ςʔϒϧσʔλ ΠϯσοΫεσʔλ ςʔϒϧσʔλ ΠϯσοΫεσʔλ

UBCMFKPJO w OFTUFEMPPQ w ૯౰ΓͰ૊Έ߹ΘͤΛ࡞Δ w NFSHFKPJO w ͓ޓ͍Λιʔτ͓͍ͯͯ͠ɺ  ্͔Βॱ൪ʹ૊Έ߹Θ͍ͤͯ͘
w TPSUͷίετ͕͔͔Δ w IBTIKPJO w IBTIUBCMFΛ࢖͏ w ϝϞϦ৯͏ TPSUࡁΈ IBTIUBCMF

ͦͷଞͷϓϥϯ w ू߹ԋࢉ w "QQFOE w 4FUPQ w ιʔτ΍-*.*5 w
4PSU 501/TPSU RVJDLTPSU pMFTPSU w -*.*5 w $5& w XPSLTDBOͱ͔

Α͋͘Δτϥϒϧ w "/"-:;&͕ෆ଍͍ͯͯ͠ɺؒҧͬͨϓϥϯ͕࢖ΘΕΔ w BOBMZ[F͢Δ͜ͱ w TFUFOBCMF@TFRTDBOUPP⒎ͱ͔Ͱ͖Δ͕ඇਪ঑ w ΠϯσοΫε͕ͳ͍ w
షΔ͔͠ͳ͍ w XIFSFGVOD IPHF Έ͍ͨͳͷ͸ɺؔ਺ΠϯσοΫε͕ඞཁ w UBCMFKPJO͕஗͍ w ઌʹߜΓࠐΜͰ͔ΒUBCMFKPJO͢Δͱ଎͘ͳΔέʔε͕݁ߏ͋Δ w XPSL@NFNΛ૿΍͢ w ςʔϒϧεΩʔϚมߋ͸ίετେͳͷͰɺΑ͘ߟ͔͑ͯΒ࣮ࢪ͢Δ͜ͱ

ॻ͖ࠐΈνϡʔχϯά

ԿΛνϡʔχϯά͢Δ͔ʁ w ॻ͖ࠐΈͷνϡʔχϯά͸݁ߏΉ͍ͣ w Ͳ͔͜Ͱඞͣॻ͔ͳ͍ͱ͍͚ͳ͍ͷͰ w ͨͩɺॻ͖ࠐΈΛ෼ࢄͤ͞Δ͜ͱͰɺෛՙΛݮΒ ͢͜ͱ͸Մೳ w ࣌ؒΛ෼ࢄ
w ৔ॴΛ෼ࢄ

͍Βͳ͍ΠϯσοΫε࡟আ w ࢖Θͳ͍ΠϯσοΫε͸ॻ͖ࠐΈʹର͢ΔϖφϧςΟ Λ௥Ճ͍ͯ͠Δ͚ͩ w ࢖͍ͬͯͳ͍΋ͷ͔Ͳ͏͔͸౷ܭ৘ใऩूϓϩηε ͔ΒऔΓग़͢ w QH@TUBU@VTFS@JOEFYFTͳͲΛݟΔ UFTUTFMFDU
GSPNQH@TUBU@VTFS@JOEFYFTXIFSFJEY@TDBO

$)&$,10*/5ΛݮΒ͢ w $)&$,10*/5ͱ͸ɺϝϞϦʹ͚ͩॻ͔ΕͨมߋΛ࣮֬ʹσΟε Ϋʹॻ͖ࠐΉϓϩηε w ܾΊΒΕͨ࣌ؒPSফඅͨ͠8"-ϑΝΠϧ਺Ͱ$)&$,10*/5 ͕ىಈ w σϑΥϧτͩͱ$)&$,10*/5͕සൃ͢ΔͷͰɺNJO
ϑΝΠϧͰઃఆ͍ͯ͠Δ w $)&$,10*/5த͸શྗͰσΟεΫʹॻ͖ࠐΜͰ͍͘ͷͰɺͪ ΜͨΒಈ͔͢Α͏ʹ͢Δ DIFDLQPJOU@DPNQMFUJPO@UBSHFU

TZOD@NFUIPE w GTZOD GEBUB@TZOD PQFO@TZODͳͲɺTZOD͢Δϝ ιουΛมߋͰ͖Δ w ͲΕ͕͍͍͔͸࣮ػͰࢼ͞ͳ͍ͱ͍͚ͳ͍ w pMFTZTUFNͱ͔৭ʑͳ৚݅ͰมΘΔʁ

΍ͬͪΌͩΊ w GTZODP⒎ w σʔλফ͑Δ w GVMM@QBHF@XSJUFTP⒎ w σʔλফ͑Δ

CBDLVQSFTUPSF

CBDLVQ w ίʔϧυόοΫΞοϓ w 1PTUHSF42-Λఀࢭͯ͠ɺσʔλΛόοΫΞοϓ w ϗοτόοΫΞοϓ w ՔಇதʹόοΫΞοϓΛऔಘ w
࿦ཧόοΫΞοϓ w QH@EVNQ QH@EVNQBMM w ࢖͍ํ͸ϚχϡΞϧݟͯ w ෺ཧόοΫΞοϓ w 1PJOU*O5JNF3FDPWFSZ w ׳Εͳ͍ͱΊΜͲ͍͘͞

1*53 w ͋Δ࣌఺ͷ෺ཧόοΫΞοϓͱࠩ෼ 8"- Λ࢖ͬͯ೚ҙͷ࣌ؒ·Ͱ໭ Δ w ͱ͍ͬͯ΋ɺ෺ཧόοΫΞοϓΑΓաڈʹ͸໭Εͳ͍ w 8"-&ͱ͍͏ɺ4ʹόοΫΞοϓΛอ؅͢ΔπʔϧΛ࢖͍ͬͯΔ
w QH@CBTFCBDLVQͱ͍͏πʔϧ΋͋Δ XBM@MFWFMBSDIJWFPSIPUTUBOECZ BSDIJWF@NPEFPO BSDIJWF@DPNNBOEbXBMΛίϐʔ͢ΔίϚϯυ` QPTUHSFTRMDPOG UFTUTFMFDUQH@TUBSU@CBDLVQ IPHF QH@TUBSU@CBDLVQ SPX ͜͜ͰUBSͱ͔࢖ͬͯ෺ཧόοΫΞοϓ UFTUTFMFDUQH@TUPQ@CBDLVQ QH@TUPQ@CBDLVQ # SPX

໭͠ํ ϕʔεόοΫΞοϓΛల։ SFDPWFSZDPOGͱ͍͏ϑΝΠϧΛ࡞੒͠ɺ෺ཧϑΝ Πϧͷ͋ΔUPQEJSFDUPSZʹஔ͘ w IUUQXXXQPTUHSFTRMKQEPDVNFOU IUNMSFDPWFSZUBSHFUTFUUJOHTIUNM
QPTUNBTUFSΛىಈ

SFQMJDBUJPO

SFQMJDBUJPOઃఆ w ϚχϡΞϧΈͯؤு͍ͬͯͩ͘͞ w IUUQXXXQPTUHSFTRMKQEPDVNFOUIUNM XBSNTUBOECZIUNM453&".*/( 3&1-*$"5*0/

ιʔείʔυπΞʔ

σΟϨΫτϦߏ੒ w $Ͱॻ͔Ε͍ͯ·͢ w TSDJODMVEF w IFBEFSpMF w TSDCBDLFOE w
DϑΝΠϧ

cBDDFTT USBOTBDUJPOܥ cCPPUTUSBQ CPPUTUSBQ cDBUBMPH TZTUFNDBUBMPH
cDPNNBOET 42-ͷίϚϯυͷΤϯτϦϙΠϯτ $3&"5&5"#-&ͳͲ cFYFDVUPS 42-࣮ߦΤϯδϯ cGPSFJHO GPSFJHOEBUBXSBQQFS cMJC MJCSBSZ cMJCQR MJCQRͱ͍͏ΫϥΠΞϯτϥΠϒϥϦ cNBJO NBJO cOPEFT QBSTFͨ͠OPEFΛૢ࡞͢Δؔ਺܈ cPQUJNJ[FS ίετͷܭࢉ΍QMBOΛ૊ΈཱͯͨΓ͢ΔQMBOOFS cQBSTFS QBSTFS cQPSU QPSUJOHʹඞཁͳίʔυ cQPTUNBTUFS QPTUNBTUFS αʔόϓϩηε ͷίʔυɻBVUPWBDVVNͳͲ΋ cSFHFY ਖ਼نදݱ cSFQMJDBUJPO SFQMJDBUJPO cSFXSJUF WJFX΍SVMFͰΫΤϦΛॻ͖׵͑ΔSVMFFOHJOF cTUPSBHF TUPSBHFपΓɻϩοΫ΋ɻ cUDPQ QPTUHSFTϓϩηεͷNBJO cUTFBSDI શจݕࡧ AVUJMT ଟݴޠ΍৭ʑͳܕɺιʔτͳͲΛఆٛ

σόοάϏϧυ w NBLF HDD MJC[MJC ͦͷଞύοέʔδ͕ඞཁ w DPOpHVSFͰ͚͜ΔͷͰɺ౎౓ೖΕΔ w HEC΋ೖΕ͓ͯ͘
͞Βʹ͍͏ͱFNBDT΋ w ࠷దԽ͢ΔͱσόοάΊΜͲ͍͘͞ͷͰP⒎ʹ͢Δ $'-"(40DPOpHVSFQSFpY)0.&EFCVH NBLFJOTUBMM JOJUEC%)0.&EFCVHEBUB QH@DUM%)0.&EFCVHEBUBTUBSU

UFTUTFMFDUQH@CBDLFOE@QJE QH@CBDLFOE@QJE SPX HECQ ʜ HEC CU
YGFDEEJO@@MJCD@SFDW GE CVGYDDF1R3FDW#V⒎FS O qBHT BUTZTEFQTVOJYTZTWMJOVYY@SFDWD YBJOTFDVSF@SFBE QPSUYECG QUSYDDF1R3FDW#V⒎FS MFO BUCFTFDVSFD YBJOQR@SFDWCVG BUQRDPNND YGJOQR@HFUCZUF BUQRDPNND YDJO4PDLFU#BDLFOE JO#VGY⒎GFBECEC BUQPTUHSFTD YDEDJO3FBE$PNNBOE JO#VGY⒎GFBECEC BUQPTUHSFTD YEJO1PTUHSFT.BJO BSHD BSHWYCD ECOBNFYCDF QPTUHSFT VTFSOBNFYCDEZBTBCB BUQPTUHSFTD YGBJO#BDLFOE3VO QPSUYECG BUQPTUNBTUFSD YGGJO#BDLFOE4UBSUVQ QPSUYECG BUQPTUNBTUFSD YFGJO4FSWFS-PPQ BUQPTUNBTUFSD YFFGJO1PTUNBTUFS.BJO BSHD BSHWYCC BUQPTUNBTUFSD YDJONBJO BSHD BSHWYCC BUNBJOD

ؾ߹ͰؤுΓ·͠ΐ͏

PostgreSQL運用管理入門

PostgreSQL運用管理入門

More Decks by Yoshiyuki Asaba

Other Decks in Technology

Featured

Transcript