[B! PostgreSQL-Tools] hamastaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hamasta id:hamasta

PostgreSQL-Toolsã«é–¢ã™ã‚‹hamastaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

pgpool page
pgpoolã¯ï¼Œpgpoolé–‹ç™ºãƒšãƒ¼ã‚¸(pgfoundry)ã‹ã‚‰ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ï¼Ž ã¾ãŸï¼ŒCVSã‚’ä½¿ã£ã¦pgfoundry.orgã‹ã‚‰é–‹ç™ºä¸ã®æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ï¼Ž cvs -d:pserver:anonymous@cvs.pgfoundry.org:/cvsroot/pgpool login ã¨ã™ã‚‹ã¨ï¼Œãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’èžã‹ã‚Œã‚‹ã®ã§ï¼Œä½•ã‚‚å…¥åŠ›ã›ãšã«ãƒªã‚¿ãƒ¼ãƒ³ã‚’æŠ¼ã™ï¼Ž ã“ã®æ“ä½œã¯æœ€åˆã®1å›žã ã‘ï¼Žã“ã‚Œã ã‘ã§ã¯ä½•ã‚‚ã‚½ãƒ¼ã‚¹ã¯å–å¾—ã•ã‚Œãªã„ï¼Ž å®Ÿéš›ã«ã‚½ãƒ¼ã‚¹ã‚’å–å¾—ã™ã‚‹ã«ã¯ï¼Œ cvs -z3 -d:pserver:anonymous@cvs.pgfoundry.org:/cvsroot/pgpool co pgpool ã¨ã™ã‚‹ï¼ŽãªãŠï¼Œ2å›žç›®ä»¥é™ã¯ï¼Œpgpoolã®ã‚½ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã§ï¼Œ cvs -z3 update ã¨ã™ã‚‹ã ã‘ã§æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã¨åŒæœŸãŒå–ã‚Œã‚‹ï¼Ž CVSã‚’HTMLã§ãƒ–ãƒ©ã‚¦ã‚ºã™ã‚‹ ã“
hamasta 2007/03/06
pgpool æ—¥æœ¬èªž è§£èª¬

PostgreSQL-Tools
ãƒªãƒ³ã‚¯
http://www.ftokai-u.ac.jp/~yahiro/pgsqlfe/readme.html
hamasta 2006/11/29
>å¤§å¦ã®æŽˆæ¥ã§SQLã‚’ãŠã•ã‚ã‚Šç¨‹åº¦ã«å¦ç¿’ã™ã‚‹ãƒ¬ãƒ™ãƒ«å‘ã‘

PostgreSQL

PostgreSQL-Tools
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘ã“ã‚Œã¯ä¾¿åˆ©! MySQL/PostgreSQLã«ã‚‚å¯¾å¿œ - RDBMSæ“ä½œãƒ„ãƒ¼ãƒ«\"Execute Query\" (1) ã„ã‚ã„ã‚RDBMSç®¡ç†ãƒ„ãƒ¼ãƒ« (MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ«)
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®Rerational Database Management Ssystem(RDBMS)ã®é›„ã¨ã„ãˆã°MySQLã¨PostgreSQLã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚“ã§ä½¿ã†ã‚¿ã‚¤ãƒ—ã®RDBMSã¾ã§åºƒã’ã‚Œã°Apache Derbyã€H2ã€HSQL DBãªã©ã‚‚äººæ°—ãŒã‚ã‚‹ãŒã€æ±Žç”¨çš„ã«å¹…åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹FLOSS RDBMSã¨ãªã‚‹ã¨ã€ã‚„ã¯ã‚ŠMySQLã¨PostgreSQLã®2ã¤ã¨ãªã‚‹ã ã‚ã†ã€‚ ã“ã®2ã¤ã®RDBMSã«å…±é€šã—ãŸç‰¹å¾´ã«ã€å‘¨è¾ºãƒ„ãƒ¼ãƒ«ãŒå……å®Ÿã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã€‚10å¹´ã¾ãˆã§ã‚ã‚Œã°ç®¡ç†ã«CUIãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã“ã¨ã«é•å’Œæ„Ÿã¯ãªã‹ã£ãŸãŒã€ç¾åœ¨ã§ã¯å„ªã‚ŒãŸGUIãƒ„ãƒ¼ãƒ«ãŒã‚ã‚Šã€åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ãŸã¨ãˆã°MySQLã«ã¯MySQL AdministratorãŒã€PostgreSQLã«ã¯pgAdmin IIIãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ å›³1.1 MySQLç®¡ç†ãƒ„ãƒ¼ãƒ« â€“ MySQL Administrato
hamasta 2006/09/22
PostgreSQL

MySQL

PostgreSQL-Tools
ãƒªãƒ³ã‚¯
PostgreSQLã§ãƒ‘ãƒ©ãƒ¬ãƒ«ãƒ»ã‚¯ã‚¨ãƒªã‚’å¯èƒ½ã«ã™ã‚‹pgpool-IIï¼Œç„¡å„Ÿå…¬é–‹
SRA OSSæ—¥æœ¬æ”¯ç¤¾ã¯9æœˆ8æ—¥ï¼Œpgpool-IIã‚’æ£å¼ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚pgpool-IIã¯ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®DBMSã§ã‚ã‚‹PostgreSQLã‚’ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã—ï¼Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆãƒ‡ãƒ¼ã‚¿è¤‡è£½ï¼‰ã‚„è² è·åˆ†æ•£ï¼Œ1ã¤ã®æ¤œç´¢ã‚’è¤‡æ•°ã®ã‚µãƒ¼ãƒãƒ¼ä¸Šã§ä¸¦åˆ—å®Ÿè¡Œã™ã‚‹ãƒ‘ãƒ©ãƒ¬ãƒ«ãƒ»ã‚¯ã‚¨ãƒªã‚’å¯èƒ½ã«ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã€‚ pgpool-IIã®å‰èº«ã§ã‚ã‚‹pgpoolã¯ï¼ŒSRA OSSæ—¥æœ¬æ”¯ç¤¾é•·ã®çŸ³äº•é”å¤«æ°ãŒé–‹ç™ºã—ãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã®æŽ¥ç¶šã‚’ä¿æŒã—ã¦æ€§èƒ½ã‚’å‘ä¸Šã•ã›ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒªãƒ³ã‚°æ©Ÿèƒ½ã«åŠ ãˆï¼Œè¤‡æ•°ã®PostgreSQLã‚µãƒ¼ãƒãƒ¼ã‚’ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã—ï¼Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„è² è·åˆ†æ•£ã‚’è¡Œã†æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ã€‚ pgpool-IIã¯ï¼Œã“ã‚Œã«ãƒ‘ãƒ©ãƒ¬ãƒ«ã‚¯ã‚¨ãƒªæ©Ÿèƒ½ã‚’åŠ ãˆï¼Œå¤§è¦æ¨¡ãªæ¤œç´¢ã‚’é«˜é€ŸåŒ–ã—ãŸã‚‚ã®ã€‚ç‹¬ç«‹è¡Œæ”¿æ³•äºº æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹(IPA)ã®ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢æ´»ç”¨åŸºç›¤æ•´å‚™äº‹æ¥ã€ã«æŽ¡æŠžã•ã‚Œ
hamasta 2006/09/09
PostgreSQL

PostgreSQL-Tools
ãƒªãƒ³ã‚¯
ã€ã‚³ãƒ©ãƒ ã€‘Yet Another ä»•äº‹ã®ãƒ„ãƒ¼ãƒ« (51) PostgreSQLã¨MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆ(1) - pgbench | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ä»Šå›žã¨æ¬¡å›žã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å°Žå…¥ã™ã‚‹ä¸Šã§ã€èª°ã—ã‚‚æ°—ã«ãªã‚‹ã§ã‚ã‚ã†æ€§èƒ½ã®è©•ä¾¡ã«ã¤ã„ã¦è€ƒãˆã¦ã¿ãŸã„ã€‚ã¤ã¾ã‚Šã€æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã€Œãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã€ã®ã‚„ã‚Šæ–¹ã§ã‚ã‚‹ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å…ˆé ƒæ™´ã‚Œã¦8.0ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸPostgreSQLã¨ã€ä¸–ç•Œã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã«ãªã‚‰ã‚“ã¨ã™ã‚‹MySQLã®2ã¤ã€‚å•†ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å ´åˆã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã®å…¬è¡¨ãŒãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä¸Šèªã‚ã‚‰ã‚Œã¦ã„ãªã‹ã£ãŸã‚Šã™ã‚‹ã‚ˆã†ã ãŒã€ä¸Šè¨˜2ã¤ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã¯ãã‚“ãªå¿ƒé…ã‚‚è¦ã‚‰ãªã„ã€‚ã¾ãšä»Šå›žã¯ã€çŸ³äº•é”å¤«æ°ä½œã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã€Œpgbenchã€ã‚’ä½¿ã£ã¦ã€PostgreSQL8.0ã®æ€§èƒ½ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã‚ˆã†ã€‚ãªãŠã€ä¾‹ã«ã‚ˆã£ã¦ä½¿ç”¨ã™ã‚‹ç’°å¢ƒã¯ãƒ¡ãƒ¢ãƒª128MBã®ä½Žé€ŸãªCeleronãƒžã‚·ãƒ³ã€‚OSã¯Fedora Core 3ã§ã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã¨ã„ã£ã¦ã‚‚ã€ãã®æ‰‹æ³•ã¯æ§˜ã€…ã ã€‚ä¸€èˆ¬çš„ã«æœ‰åãªã®ã¯ã€ŒTPCï¼ˆTra
hamasta 2006/02/22
PostgreSQL

PostgreSQL-Tools
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬12å›ž ã‚³ã‚¢ãƒ¡ãƒ³ãƒãŒé–‹ç™ºã—ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ã‚½ãƒ•ãƒˆSlony-I
DBã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¤‡è£½ã‚’ä½œã‚‹ä»•æŽ›ã‘ã‚’æŒ‡ã™ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ï¼ŒPostgreSQLå˜ä½“ã§ã¯å®Ÿç¾ã§ããªã„å¯ç”¨æ€§ã®å‘ä¸Šã‚„è² è·åˆ†æ•£ãªã©ã®ãƒ¡ãƒªãƒƒãƒˆã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•æŽ›ã‘ã‚„å®Ÿè£…æ–¹å¼ã¯æ§˜ã€…ã§ã‚ã‚‹ã€‚ã“ã‚Œã¯ï¼Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã¯ã€Œã“ã‚ŒãŒç†æƒ³ã§ã‚ã‚‹ã€ã¨ã„ã†æ–¹å¼ãŒå˜åœ¨ã—ãªã„ã‹ã‚‰ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹Slony-I(http://slony.info)ã¯ï¼Œã€ŒéžåŒæœŸãƒ»ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ã€æ–¹å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«åˆ†é¡žã•ã‚Œã‚‹ã€‚ã“ã®æ–¹å¼ã§ã¯ï¼Œä¸€èˆ¬ã«ä¸€ã¤ã®ã€Œãƒžã‚¹ã‚¿ã€ã¨å‘¼ã°ã‚Œã‚‹ä¸»ã‚µã‚¤ãƒˆã‹ã‚‰ä¸€å®šé–“éš”ã§æ›´æ–°ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€ã¤ã¾ãŸã¯è¤‡æ•°ã®å¾“ã‚µã‚¤ãƒˆ(ä¸€èˆ¬ã«ã€Œã‚¹ãƒ¬ãƒ¼ãƒ–ã€ã¨å‘¼ã°ã‚Œã‚‹)ã«è»¢é€ã—ï¼Œæ›´æ–°çµæžœã‚’åæ˜ ã™ã‚‹ã€‚ã—ãŸãŒã£ã¦ï¼Œã‚ã‚‹æ™‚åˆ»ã‚’å–ã‚‹ã¨ãƒžã‚¹ã‚¿ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã®é–“ã§ã¯å¿…ãšã—ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ãŒä¸€è‡´ã—ãªã„ã“ã¨ã«ãªã‚‹ã€‚ã¾ãŸï¼Œãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«å¯¾ã—ã¦è¡Œã†ã“ã¨ã¯ã§ããªã„ã€‚ ã“ã†ã—
hamasta 2006/02/22
PostgreSQL

PostgreSQL-Tools
ãƒªãƒ³ã‚¯
1