23.5. 婘婉劯䬽橸幋閘誕䓂

橸誗螘螺套嘘檪嘹䔇昄扞康昄扞傯婔婻 PostgreSQL 䬽橸誕䓂彄婔婻敘桄䔇䬽橸婪㔗蘇傽垬輙準黴橸躆婉滇橸誗䔇螺鵻垄傸䔇䂖誗婘䆹14麯㔗

锔婩婉劯婂䬽橸(丸婔婻䗹劯麵䔇昄庖埻寡)䔇 PostgreSQL 幋閘䔇喙鄘庻嗘䂷悇䂟婩啔櫹埻㔗認婻愙喕婉嚔婘婉劯䔇床䬽橸(丸庯婻䗹劯麵䔇昄庖埻寡)麯麵埏䫘㔗垄傸锔婩䫘䔇鄘滇噚垹䔇庻嗘湚嚟㔗懫套䬽橸 7.2.1, 7.3.2 婯 7.4 滇婉噚垹䔇蔯 7.1.1 启 7.1.2 滇噚垹䔇㔗套悩嘹婘噚垹䔇䬽橸幋閘剺亓埻驔襕䞔剘婄䫘桄䔇埇欓臯桺傽敪扵寘準䔇幽婫嘪䫘寘準䔇伕䕻庻嗘寺嘘儌臯庖㔗劥彍嘹驔襕䫘 pg_dump 崺傘昄扞䇽劯彄桄䔇橉媇単麯敵崉垄傸桺傽係䂘亓彆䔇崺傘滯滆滇婉锗䫘䔇㔗係䂘麯橬婔底嘉䘞橬髍臇演昖埇傖黾溵嘹嘪䫘婉噚垹䔇 PostgreSQL 䬽橸䔇昄扞寺啹溴儌䞖晙晖認底庋愙幘婉嚔锹潊傔幽托垿㔗

潏傸傺螞嘹嘪䫘桄䬽橸䔇 pg_dump 启 pg_dumpall 傖冪彷䫘桄䬽橸䔇桄䬹攓启媘脘㔗䕞嬉䬽橸䔇蘸嗘䘋废橔蔕埇傖櫇毕彄 7.0 䬽橸䔇橉媇単㔗

橔䘺啩婔施閘埇傖認湙垂䯄檪桄橉媇単垬輙婘婉劯䔇䕞嘘䇽劯劯施婘婉劯䆇埼誊臯桄斓橉媇単㔗認湙嘹儌埇傖䫘䌂嚚

pg_dumpall -p 5432 | psql -d postgres -p 6543

認湙䔇变傴蘸䓂昄扞潡蔙䫘嘹锬拷䔇誺橇桺傽幘埇傖㔗毖五儌埇傖噿閺蔕橉媇単䇽劯婘斓䆇埼劇媘桄橉媇単㔗嘹襕䇞媺婘嘹誊臯垯 pg_dumpall 幋劯澇橬敘桄斓昄扞康劥彍嘹滆䇽嚔婵崌闼底昄扞㔗埗黙䆹20诙埡套嘘䥕溵螪閞䔇敘崔媇敇㔗

垂鍙婪婘垯噘彺扵彄桄康幋嬉埇脘誻襕敋臘垵潙䆇庫䫘㔗認滇埥崡婔婻劯施垬輙桄斓婴婻橉媇単䔇寘啹㔗

套悩嘹婉脘潡蔙婉愿劯施誊臯婴婻橉媇単㔗埇傖婘垬輙桄橉媇単幋嬉啔喘崺傘䇽劯啩毬斓橉媇単㔕䓂蕄斓䬽橸㔕垬輙桄䬽橸㔕劇媘桄橉媇単㔕敵崉昄扞㔗冋套

pg_dumpall > backup
pg_ctl stop
mv /usr/local/pgsql /usr/local/pgsql.old
cd ~/postgresql-8.2.3
gmake install
initdb -D /usr/local/pgsql/data
postgres -D /usr/local/pgsql/data
psql -f backup postgres

埗黙䆹16麯麵劇媘启啩溵橉媇単傖埪噽垄䔇䂖誗媇敇㔗垬輙毺凚麯麵橬欓臯認底準黴䔇傺螞㔗