[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[plamo:02068] Re: [pgsql-jp 7758] Re: ¥Æ¡¼¥Ö¥ë¤Ø¤Î¿ôÃͥǡ¼¥¿¥³¥Ô¡¼¤Ë¤Ä¤¤¤Æ¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡£
-
From:Jun Kuwamura
-
Date:Thu, 1 Apr 1999 00:43:55 +0900
- Subject: [plamo:02068] Re: [pgsql-jp 7758] Re: ¥Æ¡¼¥Ö¥ë¤Ø¤Î¿ôÃͥǡ¼¥¿¥³¥Ô¡¼¤Ë¤Ä¤¤¤Æ¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡£
- From: Jun Kuwamura <juk@xxxxxxxxxx>
- Date: Thu, 1 Apr 1999 00:43:55 +0900
- Posted: Thu, 1 Apr 1999 00:43:55 +0900 (JST)
¤¯¤ï¤à¤é¤Ç¤¹¡£
¤½¤Î¸å¡¢DM¤Ç夤¤¿¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤Çµ¤¤Ë¤Ê¤ë¤È¤³¤í¤¬¤¢¤ê¤Þ¤·¤¿¡£
> [502]postgres@server1: root> csvtopg /usr/local/pgsql/kojin.csv | psql -c
> "copy boshunin from stdin" meibo
> resetting connection
¸½ºß¤ÏÉáÃÊ6.4.2(Plamo-1.4.x)¤ò»È¤Ã¤Æ¤Þ¤¤¤ÆÌäÂê¤Ê¤¯¤Ç¤¤¿¤Î¤Ç¤¹
¤¬¡¢6.3.2(Plamo1.3.x) ¤ÎÊý¤Çcopy¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤·¤Æ¤ß¤¿¤È¤³¤íƱ
ÍͤΥ¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤¬½Ð¤Þ¤·¤¿¡£¸¶°ø¤¬Æ±¤¸¤«¤É¤¦¤«¤Ï¤ï¤«¤ê¤Þ¤»
¤ó¤¬¡¢¸½ºß¤Î¤È¤³¤íÉÔÌÀ¤Ç¤¹¡£
¤½¤³¤Ç¡¢pg_upgrade ¤Ç¡¢6.4.2 ¤Ë¥¢¥Ã¥×¥°¥ì¡¼¥É¤·¤è¤¦¤È¤·¤Þ¤·¤¿
¤¬¡¢¼êºî¶È¤¬É¬ÍפǤ·¤¿¡£6.3 ¤ÎDBMS¤Ç "pg_dumpall -s -z" ¤ò¤·¤Æ¡¢
6.4 ¤Ç pg_upgrade ¤ò¤¹¤ì¤Ð¤Ç¤¤ë¤È` man pg_upgrade` ¤Ï½ñ¤¤¤Æ¤¤¤ë
¤Î¤Ç¤¹¤¬¡¢¼«Ê¬¤ÎDB¤Ë¤Ï´ö¤Ä¤«ÌäÂ꤬¤¢¤ê¤Þ¤·¤¿¡£
o ¥¿¥¤¥×¤Ë char16 ¤ò»È¤Ã¤Æ¤¤¤ë¥Æ¡¼¥Ö¥ë¤¬¤¢¤Ã¤¿¡£
o ÅÐÏ¿¤·¤Æ¤¢¤Ã¤¿C¸À¸ì¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤Î¥í¡¼¥À¥Ö¥ë¥ª¥Ö¥¸¥§¥¯¥È¤ò
¾Ã¤·¤Æ¤·¤Þ¤Ã¤Æ¤¤¤¿(DROP FUNCTION¤·¤Ê¤¤¤Þ¤Þ)¡£
o ¾¤Ë¤â¤Ê¤Ë¤«¤¢¤Ã¤¿¤«¤â¡¢¤¿¤È¤¨¤Ð¡¢ user ¤È¤¤¤¦¥«¥é¥à̾¤ò»È¤Ã
¤Æ¤¤¤¿¤È¤«¡£
¥¢¥Ã¥×¥°¥ì¡¼¥É¤ÏÂçÂΰʲ¼¤Î¼ê½ç¤Ç¹Ô¤Ê¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢¾åµ¤ÎÍýͳ¤«
¤é¤« pg_upgrade ¤¬¥¨¥é¡¼¤È¤Ê¤êÉÔ´°Á´¤Ê¾õÂ֤ˤʤäƤ·¤Þ¤¤¡¢·ë¶É
pg_dump ¤ÇDBËè¤Ë¥Ð¥Ã¥¯¥¢¥Ã¥×¤ò¼è¤Ã¤Æ¡¢¥À¥ó¥×¥Õ¥¡¥¤¥ë¤ò¼êľ¤·¤·¤Æ
¤«¤é psql ¤Ç¥í¡¼¥É¤·¤Ê¤ª¤·¤Þ¤·¤¿¡£
1.¸Å¤¤DB¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×(6.3.x ¤Î postmaster ¤¬Áö¤Ã¤Æ¤ë¾õÂÖ¤Ç)
postgres% pg_dumpall -s -z > /tmp/db.out
postgres% tar cvfz /tmp/data.tgz data
2. ¸Å¤¤¥Ñ¥Ã¥±¡¼¥¸¤Îºï½ü(¼ÂºÝ¤Ë¤Ï¤³¤ì¤Ï¤·¤Æ¤¤¤Ê¤¤)
postgres% su
# removepkg pgsql632
3. ¿·¤·¤¤¥Ñ¥Ã¥±¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë
# installpkg pgsql642
# su - postgres
postgres% mkdir old
postgres% cp /tmp/db.out old/.
postgres% tar xvfz /tmp/data.tgz -C old/
postgres% postmaster -S
postgres% pg_upgrade -f old/db.out old/data
Ãí°Õ¡§¥í¡¼¥À¥Ö¥ë¥â¥¸¥å¡¼¥ë¤ò»È¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ï¥³¥Ô¡¼¤·¤Æ¤ª¤¯¡£
¼ÂºÝ¤Ï¡¢removepkg ¤·¤Æ¤¤¤Ê¤«¤Ã¤¿¤Î¤Ç¡¢
postgres% cp -a ../pgsql63/lib/modules lib
¤ò pg_upgrade ¤ÎÁ°¤Ë¹Ô¤Ê¤Ã¤Æ¥³¥Ô¡¼¤·¤¿¡£
# copy ¥³¥Þ¥ó¥É¤¬¤É¤¦¤·¤Æ»È¤¨¤Ê¤«¤Ã¤¿¤«ÉÔÌÀ¤Ç¤¹¤¬¡¢Plamo¤Î
# pgpost ¤Çpostal DB¤òÅÐÏ¿¤¹¤ë¤Î¤Ë»È¤Ã¤Æ¤¤¤Æ¤Ç¤¤Æ¤¤¤ë¤Ï¤º
# ¤Ê¤Î¤Ç¡¢ÉԻ׵ġ£
--
Jun Kuwamura
rC Cm
^
~
[¸¡º÷¥Ú¡¼¥¸]
[¥á¡¼¥ë°ìÍ÷]
Plamo ML ¸ø³«¥·¥¹¥Æ¥à