¥¹¥Ý¥ó¥µ¡¼¥µ¥¤¥È
2013.07.04 Thursday
°ìÄê´ü´Ö¹¹¿·¤¬¤Ê¤¤¤¿¤á¹¹ð¤òɽ¼¨¤·¤Æ¤¤¤Þ¤¹
¤Ï¤¸¤á¤Æ¤ÎRuby on Rails¡¢¥È¥é¥Ö¥ëµÏ¿
¥¹¥Ý¥ó¥µ¡¼¥µ¥¤¥È
2013.07.04 Thursday
°ìÄê´ü´Ö¹¹¿·¤¬¤Ê¤¤¤¿¤á¹¹ð¤òɽ¼¨¤·¤Æ¤¤¤Þ¤¹ Heroku postgres¤Î¾ðÊó³Îǧ¤ÈÀܳ¡¦¥Ð¥Ã¥¯¥¢¥Ã¥×/¥ê¥¹¥È¥¢
2013.03.29 Friday
ÆÃÄê¤Î¥Æ¡¼¥Ö¥ë¤Î¥«¥é¥à·¿°ìÍ÷¤ò»²¾È¤¹¤ë
heroku pg:psql¡¡¢«psql¤ËÀܳ
»²¹Í¡§¥d TABLE_NAME¡¡TABLE_NAME¤Ç»ØÄꤷ¤¿¥Æ¡¼¥Ö¥ë¤Î¥«¥é¥à°ìÍ÷¤òɽ¼¨ Class: Heroku::Command::Pg ¥Æ¡¼¥Ö¥ëÄêµÁ¤Î³Îǧ pgAdmin·¤ÇHeroku postgres¤ËÀܳ¡¢¥Ð¥Ã¥¯¥¢¥Ã¥×/¥ê¥¹¥È¥¢Heroku postgres¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¡¢¥ê¥¹¥È¥¢¤ÎÊýË¡¤Ï¤³¤³¤Ë½ñ¤¤¤Æ¤¢¤ë¤È¤ª¤ê¤Ê¤Î¤À¤±¤ì¤É¡¢¥í¡¼¥«¥ë¤Îdump¥Õ¥¡¥¤¥ë¤òaws¤Ë¾å¤²¤Æ¥¤¥ó¥Ý¡¼¥È¤·¤è¤¦¤È¤·¤¿¤â¤Î¤ÎThe backup url is invalid¤È¥¨¥é¡¼¤¬½Ð¤Æ¡¢¤½¤ì¤¬¤É¤¦¤·¤Æ¤â²ò·è¤Ç¤¤Ê¤«¤Ã¤¿¤Î¤ÇpgAdmin·¤ÇHeroku¤Îpostgres¥µ¡¼¥Ð¡¼¤ËÀܳ¤·¤Æ¥ê¥¹¥È¥¢¤·¤Æ¤ß¤ë¤³¤È¤Ë¡£ pgAdmin·¤òHeroku postgreSQL¤ËÀܳ¤¹¤ëÊýË¡¤Ï°Ê²¼¤ò»²¾È¡£ Connect PGAdmin3 to Heroku PostgreSQL dedicated database ¥Ð¥Ã¥¯¥¢¥Ã¥×¦¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¤È¤³¤í¤Ç±¦¥¯¥ê¥Ã¥¯¤·¤Æ¡Ö¥Ð¥Ã¥¯¥¢¥Ã¥×¡×¤òÁªÂò¡¢¥Õ¥©¡¼¥Þ¥Ã¥È¤òTar¡¢¥¨¥ó¥³¡¼¥É¤òUTF8¤Ë¤·¤Æhogehoge.backup¤ò¤É¤³¤«¤ËÊݸ¡£ ¥ê¥¹¥È¥¢Â¦¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç±¦¥¯¥ê¥Ã¥¯¤·¤Æ¡Ö¥ê¥¹¥È¥¢¡¼¡×¤òÁªÂò¡¢¥Õ¥©¡¼¥Þ¥Ã¥È¤òCustom or Tar¤Ë¤·¤Æ¾å¤ÇÊݸ¤·¤¿hogehoge,backup¤ò¥ê¥¹¥È¥¢¡£ ¤Ç¤¤¿¡ª Heroku postgres¤Î¥Ç¡¼¥¿¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¡¦¥í¡¼¥«¥ë¤Ç¥ê¥¹¥È¥¢
2012.11.30 Friday
Heroku db:pull¤¬¤¦¤Þ¤¯Æ°¤«¤Ê¤¯¤Ê¤Ã¤¿¤Î¤Ç¡¢Heroku postgres¤Ç¥Ð¥Ã¥¯¥¢¥Ã¥×¼è¤Ã¤Æ¥ê¥¹¥È¥¢¤È¤«¤¤¤¦¤Î¤ò¤·¤Ê¤¤ã¤¤¤±¤Ê¤¯¤Ê¤Ã¤¿¤Î¤Ç¥á¥â¡£ SQLÃμ±¥¼¥í¡À(¡°¢Ï¡°)¡¿¤Á¤Ê¤ß¤ËWindows¤Ç¤¹¡£ Heroku app¤Îpostgres¤Î¤È¤³¤í¤Çsnapshots¤Î¡Ö+¡×¤ò¥Ý¥Á¤ê¤Þ¤¹¡£ ***.dump¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤¬¤Ç¤¤ë¤Î¤Ç¥À¥¦¥ó¥í¡¼¥É¡£ ¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤Ç¡¢pg_restore¤È¤¤¤¦¤Î¤ò¤ä¤ë¡£ Heroku¤Î¸ø¼°¤Î¤³¤³¤Î¥Ú¡¼¥¸¤ÎExport¤ò»²¾È¡£ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump
ÀÄ»úÉôʬ¤ò½ñ¤´¹¤¨¤Æ¼Â¹Ô¤¹¤ì¤Ð¥ê¥¹¥È¥¢¤Ç¤¤Þ¤¹¡£¤ª¤ï¤ê¡£ Rails¥¢¥×¥ê¤òHeroku¤ÇÆ°¤«¤·¤Æ¤ß¤ë¡Ê£±¡Ë
2009.10.15 Thursday
¤½¤ì¤Ç¤ÏHeroku¤Ë¾å¤²¤ë¤Þ¤Ç¤ÎÆ»¤Î¤ê¡£ ¤Þ¤¢¤Û¤È¤ó¤É¤ÎÆâÍƤÏHeroku¤Î¥¯¥¤¥Ã¥¯¥¹¥¿¡¼¥È¥¬¥¤¥É¸«¤Æ¤ä¤ì¤Ð¤½¤Î¤È¤ª¤ê¤Ê¤ó¤À¤±¤É¡£ ¡Ú£±¡Ûgit¤¬»È¤¨¤ë¤è¤¦¤Ë¤·¤Æ¤ª¤¯¡¡gitƳÆþ¤ÏÊÌ¥¨¥ó¥È¥ê»²¾È¢ÍWindows¤ÇGit¤«¤é¥×¥é¥°¥¤¥ó¤ò¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë ¡Ú£²¡ÛSSH¤Ç¸°ºî¤ëWindows¤À¤È¤ä¤Ï¤êTeraTerm¤¬¤è¤µ¤½¤¦¡£³ØÀ¸¤Î»þ°ÊÍè¤À¡£ ÀΤÏTeraTerm+TTSSHÊÌ¡¹¤ËÍî¤È¤·¤Æ¤¿¤±¤É¡¢ºÇ¶á¹¹¿·¤µ¤ì¤Æ¤ëTeraTerm¤ÏTTSSH¤â°ì½ï¤ËÆþ¤ì¤é¤ì¤ë¤ß¤¿¤¤¡£ ¤³¤³¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë¡£ ÀßÄꢪSSH¸°À¸À® ¤Ç¸ø³«¸°¤ÈÈëÌ©¸°¤Î¥»¥Ã¥È¤òºî¤ì¤ë¡£¥Ñ¥¹¥ï¡¼¥É¤ÏÀßÄꤹ¤Ù¤¡£ ²¼¤Î¥ê¥ó¥¯Àè¤ò¸«¤Ê¤¬¤é¡¢¥í¡¼¥«¥ë¤ÎŬÅö¤Ê¾ì½ê¤Ë¸ø³«¸°¤ÈÈëÌ©¸°¤òÊݸ¤·¤¿¡£ »²¹Í¡§¡¡teraterm(ssh2Âбþ) + ¸ø³«¸°Ç§¾Ú ¤Ê¤ó¤«¤Î¥³¥Þ¥ó¥É¤ÎÅÓÃæ¤ÇC:¡ïDocuments and Settings¡ï¥æ¡¼¥¶¡¼Ì¾¡ï.ssh¤Ëid_dsa.pub¡Ê¸ø³«¸°¡Ë¤¬¤Ê¤¤¤ó¤À¤¼¡ª¤È¸À¤ï¤ì¤¿¤Î¤Ç¾å¤ÇÊݸ¤·¤¿¸°¤ò¥³¥Ô¡¼¤·¤Æ.ssh¥Õ¥©¥ë¥À¤ËÊݸ¤·¤¿¡£ ¥¨¥¯¥¹¥×¥í¡¼¥é¡¼¤Ç¤Ï¡Ö.¡×¤Ç»Ï¤Þ¤ë¥Õ¥©¥ë¥À¤Ïºî¤ì¤Ê¤¤¤Î¤«¤Ê¡© ¤Ê¤ó¤«¿·¤·¤¤¥Õ¥©¥ë¥À¤Ç̾Á°¤òÊѤ¨¤è¤¦¤È¤¹¤ë¤È¥¨¥é¡¼¤¬½Ð¤¿¤Î¤Ç¡¢¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤«¤éºî¤Ã¤¿¡£ ¡Ú£³¡ÛHeroku¤Ë¥æ¡¼¥¶¡¼ÅÐÏ¿¡¡¤³¤³¤Ç¡ÖSign up¡×¥Ü¥¿¥ó¤ò²¡¤·¤Æ¥á¥¢¥É¤È¥Ñ¥¹¥ï¡¼¥ÉÆþ¤ì¤ì¤Ð¤¹¤°¤Ç¤¤ë¡£ ¡Ú£´¡ÛGem¤ÇHeroku¤ò¥¤¥ó¥¹¥È¡¼¥ëgem install heroku ¤³¤ì¤À¤±¡£¡Ú£µ¡Ûgit¤Î½àÈ÷Heroku¤Ë¾å¤²¤¿¤¤¥×¥í¥¸¥§¥¯¥È¤Î¥Õ¥©¥ë¥Àľ²¼¤Ç git init git add . git commit -m "¥¢¥×¥ê̾" ¤ò³¤±¤¶¤Þ¤Ë¡£¡Ú£¶¡ÛHeroku¤Ë¿·¤·¤¯¥×¥í¥¸¥§¥¯¥È¤òºî¤ëheroku create ¢¬¤òÆþ¤ì¤ë¤È¥á¥¢¥É¤È¥Ñ¥¹¥ï¡¼¥É¤òÍ׵ᤵ¤ì¤ë¤Î¤Ç¡¢Heroku¤Ë¥æ¡¼¥¶¡¼ÅÐÏ¿¤·¤¿¤È¤¤Î¤ò¤¤¤ì¤ë¡£¤³¤Î¤È¤¡¢SSH¤Î¸°¤¬¾ì½ê¤Ë¤Ê¤¤¤È¸À¤ï¤ì¤¿¤È»×¤¦¡£¸ø³«¸°¤¬Heroku¤ÎÊý¤ËÁ÷¤é¤ì¤¿¤Ã¤Ý¤¤¡£ ¤¢¤È¡¢Ëè²óºÇ½é¤Ëheroku¤Ë¥¢¥¯¥»¥¹¤·¤¿¤È¤¤Ë¤ÏSSH¤Î¸°¤òºî¤Ã¤¿»þ¤Ë·è¤á¤¿¥Ñ¥¹¥ï¡¼¥É¤òÍ׵ᤵ¤ì¤ë¤Î¤Ç¤³¤ì¤âÆþ¤ì¤ë¡£ À®¸ù¤¹¤ë¤È Created http://high-sunrise-58.heroku.com/ | git@heroku.com:high-sunrise-58.git ¤ß¤¿¤¤¤Ê¤Î¤¬É½¼¨¤µ¤ì¤ë¡£¡Ê¤³¤ì¤Ï¸ø¼°¤Î¥É¥¥å¥á¥ó¥È¤Ë¾è¤Ã¤Æ¤ë¥¢¥É¡Ëhttp://high-sunrise-58.heroku.com/¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤È¡¢¤Þ¤À¥¢¥×¥ê¤¬¤Ê¤¤¤È¤¤Î¥Ú¡¼¥¸¤¬É½¼¨¤µ¤ì¤ë¡£ ¤¢¤È¾åµ¤Î²¼¤Î¹Ô¤Ë¸ø¼°¤Î¥É¥¥å¥á¥ó¥È¤À¤È Git remote heroku added ¤È½ñ¤¤¤Æ¤¢¤Ã¤Æ¡¢¿·¤·¤¯ºî¤é¤ì¤¿git@heroku.com:high-sunrise-58.git¤¬¡Öheroku¡×¤È¤·¤Æremote¤ËÅÐÏ¿¤µ¤ì¤¿¤è¤È¤Ê¤ë¤ß¤¿¤¤¤À¤Ã¤¿¤±¤ì¤É¡¢»ä¤Î¾ì¹ç¤Ï¤³¤Îɽ¼¨¤¬½Ð¤Ê¤¯¤Æ¼¡¤Î¹àÌܤǤĤޤº¤¤¤¿¤Î¤Ç¡¢ ¼«Ê¬¤Ç°Ê²¼¤Î¥³¥Þ¥ó¥É¤òÆþ¤ì¤ÆÅÐÏ¿¤·¤Þ¤·¤¿¡£ git remote add heroku git@heroku.com:high-sunrise-58.git ¡Ú£·¡Û£µ¤Çgit¤Ë¥³¥ß¥Ã¥È¤·¤¿¥¢¥×¥ê¤òHeroku¤Ë»ý¤Ã¤Æ¤¯git push heroku master ¤³¤ì¤Ç¤Ê¤ó¤ä¤«¤ó¤ä¤Ç¤¿¤é¡¢À®¸ù¡ªruby-aaws¤¬¤Ê¤¤¤è¤È¸À¤ï¤ì¤¿¤±¤É¡¢¤È¤ê¤¢¤¨¤º¥×¥í¥¸¥§¥¯¥È¼«ÂΤϤÁ¤ã¤ó¤È¾å¤¬¤Ã¤Æ¤ëÌÏÍÍ¡£ ¤¤¤¯¤Ä¤«°ú¤Ã¤«¤«¤Ã¤¿¤È¤³¤Ï¤¢¤Ã¤¿¤±¤É¡¢¤³¤³¤Þ¤ÇÈæ³ÓŪ¥¹¥à¡¼¥º¤ËÍè¤ì¤¿Êý¤«¤Ê¡£ Heroku¤Î¥É¥¥å¥á¥ó¥È¤¹¤´¤¯À°È÷¤µ¤ì¤Æ¤Æ¤ï¤«¤ê¤ä¤¹¤¤¡£ ±Ñ¸ì¤À¤±¤É¡¢¤Á¤ã¤ó¤È¹àÌܤ¬¤¤ì¤¤¤Ë¤ï¤«¤ì¤Æ¤Æ¡¢°ì¤Ä°ì¤Ä¤Î¹àÌܤ¬¤À¤é¤À¤éŤ¯¤Ê¤¯¤Æ´Ê·é¤Ë¤Þ¤È¤Þ¤Ã¤Æ¤Æ¤¤¤¤¡£ ¤ï¤«¤ó¤Ê¤¯¤Ê¤Ã¤¿¤é¤Þ¤º¤Ï¥É¥¥å¥á¥ó¥È¤ò¸«¤ë¤Î¤¬¤è¤µ¤½¤¦¡£¥°¥°¤ë¤Î¤Ï¤½¤ì¤«¤é¤À¡£ Rails¥¢¥×¥ê¤òHeroku¤Ç¸ø³«¤·¤Æ¤ß¤ë¡Ê£°¡Ë
2009.10.15 Thursday
¤½¤í¤½¤í¥¢¥×¥ê¤ò¥Í¥Ã¥È¤Ç¸ø³«¤·¤Æ¤ß¤¿¤¤¤È»×¤Ã¤Æ ¥µ¡¼¥Ð¡¼¤È¤«¤É¤¦¤·¤¿¤é¤¤¤¤¤ó¤À¤í¤¦¤È¿§¡¹Ä´¤Ù¤Æ¤ß¤¿¤ó¤À¤±¤É¡¢ RoR¤Ã¤Æºî¤ë¤Î¤Ï¤ä¤ê¤ä¤¹¤¤¤±¤ÉPerl¤È¤«PHP¤ß¤¿¤¤¤Ë¥½¡¼¥¹¤ò¥µ¡¼¥Ð¡¼¤Ë¾å¤²¤ì¤Ð£Ï£Ë¤Ã¤Æ¤ó¤¸¤ã¤Ê¤¤¤Î¤Í ÁªÂò»è¤È¤·¤Æ¤Ï¡¢
¥µ¡¼¥Ð¡¼¤Î±¿ÍѤȤ«¤Ê¤ó¤Æ¤ä¤Ã¤¿¤³¤È¤Ê¤¤¤ó¤Ç¤¹¤±¤É¡Ä¡Ä¡£ ¤Ç¤â¤³¤ÎÃæ¤Ê¤éVPS¤«¤Ê¤¢¡£ Linux¡©¿¨¤Ã¤¿¤³¤È¤Ê¤¤¡¢ Apache¤È¤«²¿¤½¤ì¤ª¤¤¤·¤¤¤Î¡© FastCGI¡©Mongrel¡©Passenger¡©¡©¡©¡© ¥ª¥ï¥¿¡À(^o^)¡¿ Á´Éô³Ð¤¨¤ó¤Î¡¢Ä¶ÂçÊѤ½¤¦¡£¡£¡£ ¤Ç¤â¤Þ¤¢¤·¤ã¤¢¤Ê¤¤¤«¤¡¡¢¤ä¤ë¤·¤«¤Ê¤¤¤«¤¢¡¢¤È»×¤Ã¤Æ¤¿¤éµßÀ¤¼ç¸½¤ë¡ª ¤½¤ì¤¬ Heroku ¡Ö¤Ø¤í¤¯¡×¤À¤È»×¤Ã¤Æ¤¿¤é¡Ö¤Ï¡¼¤ª¡¼¤¯¡×¤À¤½¤¦¤Ê£÷ ¤³¤ì¡¢Web¾å¤Ç¥½¡¼¥¹½ñ¤¤¤ÆRails¥¢¥×¥êºî¤ì¤ë¤Ã¤Æ¤¤¤¦¤ä¤Ä¤À¤Ã¤¿¤Èµ²±¤·¤Æ¤¿¤Î¤À¤±¤ì¤É¡¢ ¤É¤¦¤ä¤é¥ª¡¼¥×¥ó¥Ù¡¼¥¿½ª¤Ã¤ÆÀµ¼°ÈǤ˰ܹԤµ¤ì¤¿¤È¤¤ËRuby¤¬¤¹¤°Æ°¤«¤»¤ë¥Û¥¹¥Æ¥£¥ó¥°¥µ¡¼¥Ó¥¹¤Ë¤Ê¤Ã¤Æ¤¿¤ß¤¿¤¤¡£ ¿§¡¹É¾È½¸«¤Æ¤¿¤é·ë¹½¤¹¤°Æ°¤«¤»¤½¤¦¤À¤Ã¤¿¤Î¤Ç¡¢¤³¤ì¤À¡ª¤È£±¤â£²¤â¤Ê¤¯Èô¤Ó¤Ä¤¤¤¿¡£ ¤È¤¤¤¦¤ï¤±¤Ç¡¢¼¡²ó¤«¤éHeroku¤Ç¥¢¥×¥ê¤òÆ°¤«¤·¤Æ¤ß¤ë¤Þ¤Ç¤ä¤Ã¤Æ¤ß¤Þ¡¼¡£ |
Rails3¥ì¥·¥Ô¥Ö¥Ã¥¯ 190¤Îµ»
¤Ä¤¤¤ËRails3ÂбþÈǤ¬½Ð¤Þ¤·¤¿¡ª¡ª
WEB+DB PRESS Vol.58
Rails2·Ï¤«¤é3¤Ø¤Î°Ü¹Ô»þ¤ËÃΤꤿ¤¤¤³¤È¤¬¤Ò¤È¤Þ¤È¤Þ¤ê¤Ë¤Ê¤Ã¤Æ¤Æ¤è¤«¤Ã¤¿¡ª¿§¡¹¥°¥°¤ë¤è¤ê¤³¤ì¤òÆɤàÊý¤¬Áᤤ¡£
Ruby¥ì¥·¥Ô¥Ö¥Ã¥¯ Âè3ÈÇ 303¤Îµ»
Ruby¤ä¤ë¤Ê¤é¤³¤Î¥ê¥Õ¥¡¥ì¥ó¥¹¤ÏɬÍס£
Search this site
|