¤Ï¤¸¤á¤Æ¤ÎRuby on Rails¡¢¥È¥é¥Ö¥ëµ­Ï¿
¥¹¥Ý¥ó¥µ¡¼¥µ¥¤¥È

°ìÄê´ü´Ö¹¹¿·¤¬¤Ê¤¤¤¿¤á¹­¹ð¤òɽ¼¨¤·¤Æ¤¤¤Þ¤¹

posted by ¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ | | - | - | - |¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯ - ¥¹¥Ý¥ó¥µ¡¼¥µ¥¤¥È
Heroku postgres¤Î¾ðÊó³Îǧ¤ÈÀܳ¡¦¥Ð¥Ã¥¯¥¢¥Ã¥×/¥ê¥¹¥È¥¢

ÆÃÄê¤Î¥Æ¡¼¥Ö¥ë¤Î¥«¥é¥à·¿°ìÍ÷¤ò»²¾È¤¹¤ë

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¤ò¥ê¥¹¥È¥¢¡£
¤Ç¤­¤¿¡ª³Ú¤·¤¤
posted by ¥È¥â¥È | 01:02 | Heroku | comments(0) | trackbacks(0) |¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯ - Heroku postgres¤Î¾ðÊó³Îǧ¤ÈÀܳ¡¦¥Ð¥Ã¥¯¥¢¥Ã¥×/¥ê¥¹¥È¥¢
Heroku postgres¤Î¥Ç¡¼¥¿¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¡¦¥í¡¼¥«¥ë¤Ç¥ê¥¹¥È¥¢
Heroku db:pull¤¬¤¦¤Þ¤¯Æ°¤«¤Ê¤¯¤Ê¤Ã¤¿¤Î¤Ç¡¢Heroku postgres¤Ç¥Ð¥Ã¥¯¥¢¥Ã¥×¼è¤Ã¤Æ¥ê¥¹¥È¥¢¤È¤«¤¤¤¦¤Î¤ò¤·¤Ê¤­¤ã¤¤¤±¤Ê¤¯¤Ê¤Ã¤¿¤Î¤Ç¥á¥â¡£
SQLÃμ±¥¼¥í¡À(¡°¢Ï¡°)¡¿¤Á¤Ê¤ß¤ËWindows¤Ç¤¹¡£

1 Heroku app¤Îpostgres¤Î¤È¤³¤í¤Çsnapshots¤Î¡Ö+¡×¤ò¥Ý¥Á¤ê¤Þ¤¹¡£
***.dump¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤¬¤Ç¤­¤ë¤Î¤Ç¥À¥¦¥ó¥í¡¼¥É¡£

2 ¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤Ç¡¢pg_restore¤È¤¤¤¦¤Î¤ò¤ä¤ë¡£
Heroku¤Î¸ø¼°¤Î¤³¤³¤Î¥Ú¡¼¥¸¤ÎExport¤ò»²¾È¡£
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump
ÀÄ»úÉôʬ¤ò½ñ¤­´¹¤¨¤Æ¼Â¹Ô¤¹¤ì¤Ð¥ê¥¹¥È¥¢¤Ç¤­¤Þ¤¹¡£

¤ª¤ï¤ê¡£
posted by ¥È¥â¥È | 00:21 | Heroku | comments(0) | trackbacks(0) |¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯ - Heroku postgres¤Î¥Ç¡¼¥¿¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¡¦¥í¡¼¥«¥ë¤Ç¥ê¥¹¥È¥¢
Rails¥¢¥×¥ê¤òHeroku¤ÇÆ°¤«¤·¤Æ¤ß¤ë¡Ê£±¡Ë
¤½¤ì¤Ç¤Ï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¤Î¥É¥­¥å¥á¥ó¥È¤¹¤´¤¯À°È÷¤µ¤ì¤Æ¤Æ¤ï¤«¤ê¤ä¤¹¤¤¡£
±Ñ¸ì¤À¤±¤É¡¢¤Á¤ã¤ó¤È¹àÌܤ¬¤­¤ì¤¤¤Ë¤ï¤«¤ì¤Æ¤Æ¡¢°ì¤Ä°ì¤Ä¤Î¹àÌܤ¬¤À¤é¤À¤éŤ¯¤Ê¤¯¤Æ´Ê·é¤Ë¤Þ¤È¤Þ¤Ã¤Æ¤Æ¤¤¤¤¡£
¤ï¤«¤ó¤Ê¤¯¤Ê¤Ã¤¿¤é¤Þ¤º¤Ï¥É¥­¥å¥á¥ó¥È¤ò¸«¤ë¤Î¤¬¤è¤µ¤½¤¦¡£¥°¥°¤ë¤Î¤Ï¤½¤ì¤«¤é¤À¡£
posted by ¥È¥â¥È | 15:24 | Heroku | comments(0) | trackbacks(0) |¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯ - Rails¥¢¥×¥ê¤òHeroku¤ÇÆ°¤«¤·¤Æ¤ß¤ë¡Ê£±¡Ë
Rails¥¢¥×¥ê¤òHeroku¤Ç¸ø³«¤·¤Æ¤ß¤ë¡Ê£°¡Ë
¤½¤í¤½¤í¥¢¥×¥ê¤ò¥Í¥Ã¥È¤Ç¸ø³«¤·¤Æ¤ß¤¿¤¤¤È»×¤Ã¤Æ
¥µ¡¼¥Ð¡¼¤È¤«¤É¤¦¤·¤¿¤é¤¤¤¤¤ó¤À¤í¤¦¤È¿§¡¹Ä´¤Ù¤Æ¤ß¤¿¤ó¤À¤±¤É¡¢
RoR¤Ã¤Æºî¤ë¤Î¤Ï¤ä¤ê¤ä¤¹¤¤¤±¤ÉPerl¤È¤«PHP¤ß¤¿¤¤¤Ë¥½¡¼¥¹¤ò¥µ¡¼¥Ð¡¼¤Ë¾å¤²¤ì¤Ð£Ï£Ë¤Ã¤Æ¤ó¤¸¤ã¤Ê¤¤¤Î¤ÍÎä¤ä´À

ÁªÂò»è¤È¤·¤Æ¤Ï¡¢

  • ¼«Â𥵡¼¥Ð¡¼¡§¡¡¥Ï¡¼¥É¤«¤é½àÈ÷¤·¤Ê¤­¤ã¤¤¤±¤Ê¤¤¤·¡¢¤Î¤Ã¤±¤«¤éºî¶È¤¬½Å¤¹¤®¤ë

  • ÀìÍÑ¥µ¡¼¥Ð¡¼¡§¡¡£Ï£Ó¤È¤«¥½¥Õ¥È¤È¤«¹¥¤­¤Ë½ÐÍè¤ë¤±¤ÉÃÍÃʤ¬¹â¤¤

  • £Ö£Ð£Ó¡§¡¡³¤³°¤Ê¤éÃÍÃʤâ·ë¹½°Â¤¤¡¡ÀßÄê¤â¤«¤Ê¤ê¼«Í³¤¬Íø¤­¤½¤¦

  • ¶¦Í­¥µ¡¼¥Ð¡¼¡§¡¡°Â¤¤¤±¤É¤¢¤Þ¤ê¼«Í³¤ÏÍø¤«¤º¡¢½Å¤¯¤Ê¤ê¤¬¤Á


¥µ¡¼¥Ð¡¼¤Î±¿ÍѤȤ«¤Ê¤ó¤Æ¤ä¤Ã¤¿¤³¤È¤Ê¤¤¤ó¤Ç¤¹¤±¤É¡Ä¡Ä¡£
¤Ç¤â¤³¤ÎÃæ¤Ê¤éVPS¤«¤Ê¤¢¡£
Linux¡©¿¨¤Ã¤¿¤³¤È¤Ê¤¤¡¢
Apache¤È¤«²¿¤½¤ì¤ª¤¤¤·¤¤¤Î¡©
FastCGI¡©Mongrel¡©Passenger¡©¡©¡©¡©
¥ª¥ï¥¿¡À(^o^)¡¿

Á´Éô³Ð¤¨¤ó¤Î¡¢Ä¶ÂçÊѤ½¤¦¡£¡£¡£±«

¤Ç¤â¤Þ¤¢¤·¤ã¤¢¤Ê¤¤¤«¤¡¡¢¤ä¤ë¤·¤«¤Ê¤¤¤«¤¢¡¢¤È»×¤Ã¤Æ¤¿¤éµßÀ¤¼ç¸½¤ë¡ª

¤½¤ì¤¬

Heroku

¡Ö¤Ø¤í¤¯¡×¤À¤È»×¤Ã¤Æ¤¿¤é¡Ö¤Ï¡¼¤ª¡¼¤¯¡×¤À¤½¤¦¤Ê£÷

¤³¤ì¡¢Web¾å¤Ç¥½¡¼¥¹½ñ¤¤¤ÆRails¥¢¥×¥êºî¤ì¤ë¤Ã¤Æ¤¤¤¦¤ä¤Ä¤À¤Ã¤¿¤Èµ­²±¤·¤Æ¤¿¤Î¤À¤±¤ì¤É¡¢
¤É¤¦¤ä¤é¥ª¡¼¥×¥ó¥Ù¡¼¥¿½ª¤Ã¤ÆÀµ¼°ÈǤ˰ܹԤµ¤ì¤¿¤È¤­¤ËRuby¤¬¤¹¤°Æ°¤«¤»¤ë¥Û¥¹¥Æ¥£¥ó¥°¥µ¡¼¥Ó¥¹¤Ë¤Ê¤Ã¤Æ¤¿¤ß¤¿¤¤¡£
¿§¡¹É¾È½¸«¤Æ¤¿¤é·ë¹½¤¹¤°Æ°¤«¤»¤½¤¦¤À¤Ã¤¿¤Î¤Ç¡¢¤³¤ì¤À¡ª¤È£±¤â£²¤â¤Ê¤¯Èô¤Ó¤Ä¤¤¤¿¡£

¤È¤¤¤¦¤ï¤±¤Ç¡¢¼¡²ó¤«¤éHeroku¤Ç¥¢¥×¥ê¤òÆ°¤«¤·¤Æ¤ß¤ë¤Þ¤Ç¤ä¤Ã¤Æ¤ß¤Þ¡¼¡£
posted by ¥È¥â¥È | 14:57 | Heroku | comments(0) | trackbacks(0) |¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯ - Rails¥¢¥×¥ê¤òHeroku¤Ç¸ø³«¤·¤Æ¤ß¤ë¡Ê£°¡Ë
Rails3¥ì¥·¥Ô¥Ö¥Ã¥¯ 190¤Îµ»
Rails3¥ì¥·¥Ô¥Ö¥Ã¥¯ 190¤Îµ»
¤Ä¤¤¤ËRails3ÂбþÈǤ¬½Ð¤Þ¤·¤¿¡ª¡ª
WEB+DB PRESS Vol.58
WEB+DB PRESS Vol.58
Rails2·Ï¤«¤é3¤Ø¤Î°Ü¹Ô»þ¤ËÃΤꤿ¤¤¤³¤È¤¬¤Ò¤È¤Þ¤È¤Þ¤ê¤Ë¤Ê¤Ã¤Æ¤Æ¤è¤«¤Ã¤¿¡ª¿§¡¹¥°¥°¤ë¤è¤ê¤³¤ì¤òÆɤàÊý¤¬Áᤤ¡£
Ruby¥ì¥·¥Ô¥Ö¥Ã¥¯ Âè3ÈÇ 303¤Îµ»
Ruby¥ì¥·¥Ô¥Ö¥Ã¥¯ Âè3ÈÇ 303¤Îµ»
Ruby¤ä¤ë¤Ê¤é¤³¤Î¥ê¥Õ¥¡¥ì¥ó¥¹¤ÏɬÍס£
Search this site