|
Top / PostgreSQL / ¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×
¥¤¥ó¥¹¥È¡¼¥ë †¤¦¤Á¤Î´Ä¶¤ÏRedhat8.0¤Ê¤Î¤Ç¡¢PostgreSQL¤Ï¸µ¡¹¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤Þ¤·¤¿¡£ º£²ó¤Ï¤½¤ì¤Î¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤ò¤·¤Æ¤ß¤¿¤¤¤È»×¤¤¤Þ¤¹¡£ ¤Á¤Ê¤ß¤Ë¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤Ï 7.2.4 -> 7.4.2 ¤Ç¤¹¡£ ¥Ð¥Ã¥¯¥¢¥Ã¥× †PostgreSQL¤ÇBlog¤ò±¿ÍѤ·¤Æ¤¤¤¿¤¿¤á¡¢¥Ç¡¼¥¿¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¤ò¹Ô¤¤¤Þ¤·¤¿¡£ postgres¥æ¡¼¥¶¤Ç pg_dumpall > outputfile ¤Ç£Ï£Ë¡£ ¥¤¥ó¥¹¥È¡¼¥ë †http://www.postgresql.jp/document/pg74doc/html/installation.html ¤Ë¤·¤¿¤¬¤Ã¤Æ¹Ô¤¤¤Þ¤·¤¿¡£ ¤½¤Î¾¤Îºî¶È¤È¤·¤Æ¤Ï/etc/profile¤Ë PATH=/usr/local/pgsql/bin:$PATH ¤òÄɲä·¤Þ¤·¤¿¡£ ¥Ç¡¼¥¿¥ê¥¹¥È¥¢ †/usr/local/pgsql/bin/psql -d template1 -f outputfile ¤½¤Î¾¤Îºî¶È †pg_hba.conf¤Î½¤Àµ #host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.0.0 255.255.0.0 trust µ¯Æ°¥·¥§¥ë¤Î½¤Àµ ¤³¤Îµ»ö¤Ï Top / PostgreSQL / ¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×
¸½ºß¤Î¥¢¥¯¥»¥¹:4747 |