[B! db][postgresql] gnwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gnw id:gnw

dbã¨postgresqlã«é–¢ã™ã‚‹gnwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (29)

${{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}}

GitHub - k1LoW/tbls: tbls is a CI-Friendly tool to document a database, written in Go.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
gnw 2018/06/18
github

postgresql

db
ãƒªãƒ³ã‚¯
PostgreSQLå°Žå…¥ã«å‘ã‘ã¦ã®å–ã‚Šçµ„ã¿ ï½žå¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã¸ã®é©ç”¨ã‚’ç›®æŒ‡ã—ã¦ï½ž(5) â€” Let's Postgres
4.3 é‹ç”¨é¢ã®ç€ç›®ç‚¹ 3ï¼š DB ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã®æ”¹å–„ ãƒ‡ãƒ¼ã‚¿ã®æ–ç‰‡åŒ–ã«ã‚ˆã‚‹æ€§èƒ½ä½Žä¸‹ã«å¯¾å‡¦ã™ã‚‹æ–¹æ³•ã¨ã—ã¦ã€å¼Šç¤¾ã§ã¯ PostgreSQL ã® CLUSTER ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã—ãŸã€‚ ãã‚Œã¯ã€ä¸€æ™‚çš„ã«å¯¾è±¡ã®è¡¨ã¨åŒç¨‹åº¦ã®ç©ºãé ˜åŸŸãŒãƒ‡ã‚£ã‚¹ã‚¯ã«å¿…è¦ã¨ãªã‚‹ã‚‚ã®ã®ã€ãƒ†ãƒ¼ãƒ–ãƒ«å†ç·¨æˆã®å‡¦ç†ãŒé«˜é€Ÿã«è¡Œãˆã‚‹ãŸã‚ã§ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€CLUSTER ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ ACCESS EXCLUSIVE ãƒãƒƒã‚¯ã‚’å–å¾—ã—ã¾ã™ã€‚ ãã®ãŸã‚ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œï¼ˆå‚ç…§/æ›´æ–°ä¸¡æ–¹ï¼‰ãŒãƒ–ãƒãƒƒã‚¯ã•ã‚Œ CLUSTER å‡¦ç†ä¸ã¯ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ 24 æ™‚é–“ 365 æ—¥é‹ç”¨ã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢æ™‚é–“ã®ç¢ºä¿ãŒä¸å¯èƒ½ãªå ´åˆã‚„ã€å¤œé–“ã«å¤§é‡ã®ãƒãƒƒãƒã‚’å®Ÿè¡Œã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®å ´åˆã€ CLUSTER ã«ã‚ˆã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã¸ã®å½±éŸ¿ã¯ã€PostgreSQL é©ç”¨ã®å¤§ããªèª²é¡Œã®Â 1 ã¤ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã«å¯¾ã—
gnw 2015/03/19
postgresql

db
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
gnw 2012/09/13
postgresql

mysql

db
ãƒªãƒ³ã‚¯
PostgreSQLã¯æ¨™æº–ã§ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ä»•æ§˜ã«ãªã£ãŸ
PostgreSQL9.1ã®ä»•æ§˜å¤‰æ›´ã«ã¦ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆæ™‚ã®è¨å®šã¨ã—ã¦ã€standard_conforming_stringsãŒonã¨ã¿ãªã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ä»•æ§˜å¤‰æ›´ã«ã‚ˆã‚Šã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§ã®PostgreSQLã¯ã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒãªããªã‚Šã€ISOè¦æ ¼ã®SQLã¨åŒæ§˜ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãƒ«ãƒ¼ãƒ«ï¼ˆã‚·ãƒ³ã‚°ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã‚’é‡ãã‚‹ã®ã¿ï¼‰ã¨ãªã‚Šã¾ã™ã€‚ PostgreSQLã®æ–‡å—åˆ—ãƒªãƒ†ãƒ©ãƒ«ã¯ã€å…ƒã€…MySQLåŒæ§˜ã«ã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹ä»•æ§˜ã§ã—ãŸã€‚ãã®å¾Œã€ãƒªãƒªãƒ¼ã‚¹8.1ã«ã¦ã€è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ standard_conforming_strings ãŒè¿½åŠ ã•ã‚Œã€ã“ã®å€¤ãŒ on ã®å ´åˆã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ï¼ˆISOè¦æ ¼ã¨åŒæ§˜ã®ï¼‰ä»•æ§˜ã¨ãªã‚Šã¾ã—ãŸã€‚å¾“æ¥ã®ãƒªãƒªãƒ¼ã‚¹ã§ã¯ã€standard_conforming_stringsã‚’æŒ‡å®šã—ãªã„å ´åˆoffã¨ã¿ãªã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã“ã‚Œã¯ã€å¾Œ
gnw 2011/09/26
postgresql

db
ãƒªãƒ³ã‚¯
pg_upgrade | Let's POSTGRES
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ ç¬ åŽŸ è¾°ä» ã¯ã˜ã‚ã« PostgreSQLã§ã¯ã€å®šæœŸçš„ãªãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ãŒè¡Œã‚ã‚Œã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã«ã¯2ç¨®é¡žã‚ã‚Šã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³å (x.y.z) ã® x ã¾ãŸã¯ y ãŒå¤‰åŒ–ã™ã‚‹ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒªãƒªãƒ¼ã‚¹ (8.3 â†’ 8.4) ã¨ã€z ãŒå¤‰åŒ–ã™ã‚‹ãƒžã‚¤ãƒŠãƒ¼ãƒªãƒªãƒ¼ã‚¹ (8.3.6 â†’ 8.3.7) ã§ã™ã€‚ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã‚¢ãƒƒãƒ—ã™ã‚‹ã¨DBã‚¯ãƒ©ã‚¹ã‚¿ã®äº’æ›æ€§ãŒãªããªã‚‹ãŸã‚ã€pg_dumpç‰ã«ã‚ˆã‚‹ãƒ€ãƒ³ãƒ—ã‚’è¡Œã„ã€æ–°ç‰ˆã®DBã‚¯ãƒ©ã‚¹ã‚¿ã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒªã‚¹ãƒˆã‚¢ã™ã‚‹å‡¦ç†ãŒå¿…è¦ã§ã™ã€‚ ã“ã®ãƒ€ãƒ³ãƒ—ã®å–å¾—ã¨ãƒªã‚¹ãƒˆã‚¢ã¯ã€éžå¸¸ã«å¤§ããªãƒ‡ãƒ¼ã‚¿ã‚’æŒã¤ã‚·ã‚¹ãƒ†ãƒ ã§ã¯é•·æ™‚é–“ã‹ã‹ã‚‹ãŸã‚åŽ„ä»‹ã§ã—ãŸã€‚ã“ã®ä½œæ¥ãŒé¢å€’ã§ã€å¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã„ç¶šã‘ã¦ã„ã‚‹æ–¹ã‚‚å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿã“ã®ã‚ˆã†ãªãƒ€ãƒ³ãƒ—ã‚„ãƒªã‚¹ãƒˆã‚¢å‡¦ç†ã‚’ä¸è¦ã«ã—ã€ä½¿ç”¨ä¸ã®DBã‚¯ãƒ©ã‚¹ã‚¿ã‚’ãã®ã¾ã¾æ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®PostgreSQLã§ã‚‚ä½¿ã„ç¶šã‘ã‚‰ã‚Œã‚‹ã‚ˆ
gnw 2011/03/31
postgresql

db
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
gnw 2007/09/04
db

postgresql

security
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
gnw 2007/07/23
db

postgresql
ãƒªãƒ³ã‚¯
ã€ŒR25ã€ã‚µã‚¤ãƒˆã‚’PostgreSQLã§æ§‹ç¯‰ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã¯OSSã‚’ã“ã†è€ƒãˆã‚‹ â€• ï¼ IT
2007/06/05 ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®FIT ã‚·ã‚¹ãƒ†ãƒ åŸºç›¤æŽ¨é€²å®¤ ãƒ•ã‚§ãƒ‡ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚ªãƒ•ã‚£ã‚µãƒ¼ã®ç±³è°·ä¿®æ°ã¯6æœˆ5æ—¥ã€ã€ŒPostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007ã€ã§è¬›æ¼”ã—ã€åŒç¤¾ãŒå±•é–‹ã™ã‚‹ãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã¸ã®PostgreSQLã®æŽ¡ç”¨çŠ¶æ³ã‚’èª¬æ˜Žã—ãŸã€‚ãƒ•ãƒªãƒ¼ãƒšãƒ¼ãƒ‘ãƒ¼ã€ŒR25ã€ã€ŒL25ã€ã®Webã‚µã‚¤ãƒˆãªã©ã§å®Ÿé¨“çš„ã«PostgreSQLã‚’ä½¿ã£ã¦ã„ã‚‹ãŒã€ã€Œè² è·ãŒé«˜ã„ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã¾ã æ€–ãã¦ä½¿ãˆãªã„ã€ã¨ã„ã†ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼å´ã‹ã‚‰ã¿ãŸPostgreSQLã®èª²é¡Œã¨ã¯ä½•ã ã‚ã†ã‹ã€‚ R25ã€L25ã®Webã‚µã‚¤ãƒˆã¯æœˆç´„1å„„2000ä¸‡ã®ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã‚’èª‡ã‚‹ã€‚ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã¯ã»ã‹ã«ã‚‚ãƒãƒ¼ã‚«ãƒ«ã‚µãƒ¼ãƒã‚µã‚¤ãƒˆã®ã€Œã‚¹ã‚´ã‚¤åœ°å›³ã€ã‚„åœ°åŸŸæ¤œç´¢æƒ…å ±ã‚µã‚¤ãƒˆã€Œãƒ‰ã‚³ã‚¤ã‚¯ï¼Ÿã€ãªã©ã§PostgreSQLã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ã€‚ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã¯4å¹´å‰ã«ã‚‚PostgreSQLã®æŽ¡ç”¨ã‚’æ¤œè¨Žã—ãŸãŒã€å½“æ™‚ã®æ©Ÿèƒ½ã§ã¯ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°ãŒå–ã‚Œãšã€ã€Œã‚‚ã—ã‚µãƒ¼ãƒ“ã‚¹ãŒè½ã¡ãŸã¨ãã«æˆ»ã›ãªã„å¯èƒ½æ€§ãŒã‚
gnw 2007/06/05
pgpool

postgresql

db

è² è·å¯¾ç–
ãƒªãƒ³ã‚¯
PostgreSQL: PostgreSQL 8.2 Press Kit
PostgreSQL 8.2 ãƒ—ãƒ¬ã‚¹ã‚ãƒƒãƒˆ ç›®æ¬¡ ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ è¿½åŠ æ©Ÿèƒ½ã«é–¢ã™ã‚‹æƒ…å ± ãƒ€ã‚¤ãƒ³ãƒãƒ¼ãƒ‰å…ˆ æ–‡æ›¸ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ å•ã„åˆã‚ã›å…ˆ å¼•ç”¨ã—ãŸä¼æ¥ã®æƒ…å ± æ³•äººã‚µãƒãƒ¼ãƒˆ è¿½åŠ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ è‹±èªžç‰ˆ ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ 2006å¹´12æœˆ5æ—¥ãƒ¯ã‚·ãƒ³ãƒˆãƒ³DC(LISAã‚³ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹) æœ¬æ—¥ã€PostgreSQLã‚°ãƒãƒ¼ãƒãƒ«é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—ã¯ã€PostgreSQLã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.2ã®ãƒªãƒªãƒ¼ã‚¹ã‚’ç™ºè¡¨ã—ã¾ã™ã€‚ ã“ã®14ç•ªç›®ã®å…¬å¼ãƒªãƒªãƒ¼ã‚¹ã§ã¯ã€å•†ç”¨ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦æ±‚ã®ã‚ã£ãŸæ©Ÿèƒ½è¿½åŠ ã€ç†Ÿæˆã€æ€§èƒ½å‘ä¸ŠãŒãªã•ã‚Œã€ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®å…ˆç«¯ã¨ã—ã¦ååˆ†æ¯”è¼ƒã§ãã‚‹ã‚‚ã®ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.2ã¯PostgreSQLã¸ã®ç§»è¡Œã‚’ã‚ˆã‚Šä¸€å±¤é€²ã‚ã‚‹ã‚‚ã®ã¨ç¢ºä¿¡ã—ã¦ã„ã¾ã™ã€‚ PostgreSQLã‚³ã‚¢ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒã®ä¸€äººEnterpriseDBãƒ‡ãƒ¼ã‚¿ãƒ™
gnw 2006/12/06
postgresql

db
ãƒªãƒ³ã‚¯
Â» ç¬¬2å›ž Slony-Iã¨pgpoolã‚’çµ„ã¿åˆã‚ã›ãŸã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ â€“ å¤§è¦æ¨¡å‚ç…§ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ | PowerGresä½“é¨“è¨˜ | æŠ€è¡“æƒ…å ± | PowerGres
å‰å›žã¯ã€Slony-Iã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã€ãƒžã‚¹ã‚¿ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¤‡è£½ãŒç°¡å˜ã«ä½œæˆã§ãã‚‹ã“ã¨ã‚’ã”ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€å‰å›žã”ç´¹ä»‹ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’ã€å¤§è¦æ¨¡ã§å®Ÿè·µçš„ãªã‚·ã‚¹ãƒ†ãƒ ã«æ‹¡å¼µã™ã‚‹ãŸã‚ã«ã€pgpoolã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’çµ„ã¿åˆã‚ã›ã¦ã¿ã¾ã™ã€‚pgpoolã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŽ¥ç¶šã‚’ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã—ã€åŠ¹çŽ‡ã‚ˆãå‚ç…§ã™ã‚‹ãŸã‚ã®æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ã€Slony-Iã§è¤‡è£½ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‚ç…§åŠ¹çŽ‡ãŒå‘ä¸Šã—ã¾ã™ã€‚ Slony-Iã¨pgpoolã‚’çµ„ã¿åˆã‚ã›ãŸã‚·ã‚¹ãƒ†ãƒ ã®æ§‹ç¯‰ã«ã¯ã€ã„ãã¤ã‹ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã®ã§ã€å®Ÿä¾‹ã‚’äº¤ãˆã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚
gnw 2006/10/27
db

postgresql

pgpool

slony-i
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬31å›ž ã¤ã„ã«PostgreSQL 8.2ãƒ™ãƒ¼ã‚¿ãƒ»ãƒ†ã‚¹ãƒˆé–‹å§‹!
2006å¹´9æœˆ21æ—¥ï¼Œå¾…æœ›ã®PostgreSQL 8.2ã®ãƒ™ãƒ¼ã‚¿ç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œï¼ŒPostgreSQL8.2ã®å…¨å®¹ãŒæ˜Žã‚‰ã‹ã¨ãªã£ãŸã€‚å…¨ä½“çš„ã«ã¯ãã‚Œã»ã©ç›®ã ã£ãŸæ–°æ©Ÿèƒ½ã¯ãªã„ãŒï¼Œç´°ã‹ãªæ”¹å–„ã‚„ï¼Œæ€§èƒ½å‘ä¸ŠãŒãªã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã ã€‚ æœ¬é€£è¼‰ã§ã‚‚25å›žã¨30å›žã§8.2ã®æ–°æ©Ÿèƒ½ã‚„æ”¹è‰¯ç‚¹ã‚’å–ã‚Šä¸Šã’ã¦ããŸãŒï¼Œãã‚Œã‚’ç°¡å˜ã«å¾©ç¿’ã—ã¦ã¿ã‚ˆã†ã€‚ 25å›žã§ã¯ï¼ŒCE(Constraint Exclususion)ã¨ã„ã†ï¼Œç¶™æ‰¿ã‚’ä½¿ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°æ©Ÿèƒ½ã®æ”¹è‰¯ï¼Œpg_freespacemapã®è¿½åŠ ã‚’ç´¹ä»‹ã—ãŸã€‚ã¾ãŸï¼Œã‚½ãƒ¼ãƒˆå‡¦ç†ã¨ãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã®ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚’ä½¿ã£ãŸVACUMMã®é«˜é€ŸåŒ–ã¸ã®è©¦ã¿ã«ã¤ã„ã¦ã‚‚ç´¹ä»‹ã—ãŸã€‚æ®‹å¿µãªãŒã‚‰VACUUMã®é«˜é€ŸåŒ–ã¯ç››ã‚Šè¾¼ã¾ã‚Œãªã‹ã£ãŸãŒï¼Œã‚½ãƒ¼ãƒˆå‡¦ç†ã®é«˜é€ŸåŒ–ã¯8.2ã«å–ã‚Šè¾¼ã¾ã‚ŒãŸã€‚ 30å›žã§ã¯ï¼ŒGINã¨ã„ã†æ–°ã—ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚¿ã‚¤ãƒ—ã®è¿½åŠ ï¼ŒCOPYã‚„INSERTã®æ”¹è‰¯ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã€‚ æœ¬ç¨¿ã§ã¯ã“ã‚Œ
gnw 2006/10/16
db

postgresql
ãƒªãƒ³ã‚¯
ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãƒ‰ãƒƒãƒˆ ã‚¸ãƒ£ãƒ‘ãƒ³ | PostgreSQLç”¨ã®æ—¥æœ¬èªžå¯¾å¿œå…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ï½¢Ludiaã€
sillywalkæ›°ãã€"ITProã®è¨˜äº‹ã«ã‚ˆã‚Œã°ã€NTTãƒ‡ãƒ¼ã‚¿ã¯10æœˆ11æ—¥ã€åŒç¤¾ãŒé–‹ç™ºã—ãŸå…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ï½¢Ludiaï½£ã‚’LGPLã«ã‚ˆã‚Šç„¡å„Ÿå…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ã¾ã—ãŸã€‚PostgreSQLã«æ ¼ç´ã•ã‚ŒãŸãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã®å…¨æ–‡æ¤œç´¢ãŒå¯èƒ½ã§ã€ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã§ã¯æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã«å¯¾å¿œã—ãŸé«˜é€Ÿãƒ»é«˜ç²¾åº¦ãªã‚‚ã®ãŒå˜åœ¨ã›ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã—åˆ¥ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã™ã‚‹å¿…è¦ãŒã‚ã£ãŸã€‚Ludiaã¯å•†ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚½ãƒ•ãƒˆã«åŒ¹æ•µã™ã‚‹é€Ÿåº¦ã¨ç²¾åº¦ã‚’å‚™ãˆã‚‹ã€(NTTãƒ‡ãƒ¼ã‚¿)ã¨ã—ã¦ã„ã¾ã™ã€‚Ludiaã¯ã€N-gramã¨å½¢æ…‹ç´ è§£æžã®2ç¨®é¡žã®å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ–¹å¼ã‚’ã‚µãƒãƒ¼ãƒˆã—ã€ã¾ãŸãƒ–ãƒ¼ãƒªã‚¢ãƒ³æ¤œç´¢ã€è¿‘å‚ä½ç½®æ¤œç´¢ã€é¡žä¼¼æ–‡æ›¸æ¤œç´¢ã¨ã„ã£ãŸæ¤œç´¢ãŒå¯èƒ½ã§ã€æ¤œç´¢çµæžœã®åˆè‡´åº¦ã‚’ç¤ºã™ï½¢ã‚¹ã‚³ã‚¢ï½£ã‚‚æä¾›ã™ã‚‹ãã†ã§ã™ã€‚" ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«ã¯çµ„ã¿è¾¼ã¿ç”¨å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³sennaã‚’ä½¿ã£ã¦ã„ã‚‹æ§˜ã§ã‚ã‚‹ã€‚
gnw 2006/10/12
db

postgresql

slashdot
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘RDBMSæ“ä½œãƒ„ãƒ¼ãƒ«æ±ºå®šæ‰“!? - Eclipseã‹ã‚‰Oracle/DB2/MySQL/PostgreSQLã‚’æ“ä½œ (1) Eclipse SQL Explorerã¨ã¯ (MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ«)
RDBMSãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«Execute QueryãŒã‚ã‚‹ã€‚MySQL Administratorã‚„pgAdmin IIIãªã©ã¨ã¯ç•°ãªã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¾å˜ã—ãªã„ç®¡ç†ãƒ„ãƒ¼ãƒ«ã ã€‚Javaã§é–‹ç™ºã•ã‚ŒãŸRDBMSæ“ä½œãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã§ã€ã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦SQLã‚¯ã‚¨ãƒªã®å®Ÿè¡Œã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆ/ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãªã©ãŒå¯èƒ½ã¨ã„ã†ç‰¹å¾´ã‚’ã‚‚ã¤ã€‚ã“ã“ã§ã¯åŒæ§˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦ã€Eclipse IDEã‚’ä½¿ã£ã¦é–‹ç™ºã•ã‚ŒãŸã€ŒEclipse SQL Explorerã€ã‚’ç´¹ä»‹ã—ãŸã„ã€‚ Eclipse SQL Explorerã¯JDBCã‚’é€šã˜ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–²è¦§ã‚„ã‚¯ã‚¨ãƒªæ“ä½œã‚’è¡Œã†ãŸã‚ã®ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãƒ„ãƒ¼ãƒ«ã€‚GNU LESSER GENERAL PUBLIC LICENSE Version 2.1ã®ã‚‚ã¨ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€åŸ·ç†ç¾åœ¨ã§ã®æœ€æ–°ç‰ˆã¯8æœˆ30æ—¥(ç±³å›½æ™‚é–“
gnw 2006/10/03
db

postgresql

mysql

software
ãƒªãƒ³ã‚¯
Â» ç¬¬ 1 å›ž Slony-I ã‚’ä½¿ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ â€“ å¤§è¦æ¨¡å‚ç…§ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ | PowerGres
ã“ã®ãƒšãƒ¼ã‚¸ã«è¨˜è¼‰ã®æƒ…å ±ã¯ã€2005 å¹´ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸ PowerGres Plus V2 ã‚’å¯¾è±¡ã¨ã—ã¦ã„ã¾ã™ã€‚PowerGres Plus V2 ã®è²©å£²ã¯ã™ã§ã«çµ‚äº†ã—ã¦ã„ã¾ã™ã€‚ PowerGres Plus ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«é–¢ã™ã‚‹æƒ…å ±ã¯ã€è£½å“ç´¹ä»‹ãƒšãƒ¼ã‚¸ã¾ãŸã¯ PowerGres ä½“é¨“è¨˜ãƒšãƒ¼ã‚¸ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ æœ€è¿‘ã§ã¯ã€å°è¦æ¨¡ã§å§‹ã‚ãŸäº‹æ¥ãŒã€ãƒ’ãƒƒãƒˆå•†å“ã®å‡ºç¾ã‚„ãƒ¡ãƒ‡ã‚£ã‚¢ã§ç´¹ä»‹ã•ã‚Œã‚‹ã“ã¨ã§ã€ä¸€æ°—ã«æµè¡Œã—ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã§ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒæ•°åå€ã«å¢—ãˆã‚‹ã“ã¨ã‚‚ã‚ãšã‚‰ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ãã®ã‚ˆã†ãªå ´åˆã€ãã®ä¼æ¥ã¯ã€è¿…é€Ÿã€ã‹ã¤ç°¡å˜ã«ã‚·ã‚¹ãƒ†ãƒ ã‚’å¢—è¨ã—ãªãã¦ ã¯ãªã‚Šã¾ã›ã‚“ã€‚ Slony-I ã¯ãƒã‚§ãƒ¼ãƒ³æ–¹å¼ã¨å‘¼ã°ã‚Œã‚‹æ–¹å¼ã«ã‚ˆã‚Šã€ã‚·ã‚¹ãƒ†ãƒ ã‚’ç°¡å˜ã«å¢—è¨ã§ãã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ PowerGres Plus ã§ã¯ã€Slony-I ã‚’åˆ©ç”¨ã—ã¦ã€å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿å‚ç…§ã‚’è¡Œã†ã‚·ã‚¹ãƒ†ãƒ ã‚’ç°¡å˜ã«æ§‹ç¯‰ã™ã‚‹ã“ã¨ãŒã§
gnw 2006/09/29
slony-i

postgresql

db
ãƒªãƒ³ã‚¯
pgpool Wiki
gnw 2006/09/27
db

pgpool

postgresql
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘ã“ã‚Œã¯ä¾¿åˆ©! 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
gnw 2006/09/22
db

postgresql

mysql

software
ãƒªãƒ³ã‚¯
PEAR DBã®PostgreSQLãƒ‰ãƒ©ã‚¤ãƒã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«
Last Updated on: 2006å¹´9æœˆ12æ—¥ã“ã®è„†å¼±æ€§ã¯æœ¬å®¶ã«ã¯ãƒ¬ãƒãƒ¼ãƒˆã—ã¦ã‚ã‚‹ã®ã§ã™ãŒç°¡å˜ãª1è¡Œãƒ‘ãƒƒãƒãªã®ã«ã¾ã CVSã«ã•ãˆé©ç”¨ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚è©³ã—ãè§£èª¬ã—ãŸã¤ã‚‚ã‚Šãªã®ã§ã™ãŒã‚·ãƒ³ã‚°ãƒ«ãƒã‚¤ãƒˆåœã®é–‹ç™ºè€…ã«ã¯ç†è§£ãŒé›£ã—ã„(?)ã‹ç§ã®èª¬æ˜ŽãŒæ‚ªã‹ã£ãŸ(?)ã®ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ã¨ã‚Šã‚ãˆãšã€Œä½œæ¥ä¸ã€ã¨ã®æ—¨ã®ãƒ¡ãƒ¼ãƒ«ãŒå¸°ã£ã¦æ¥ã¦ã„ã¾ã™ãŒé…ã™ãŽãªã®ã§ç‰¹ã«å½±éŸ¿ãŒå¤§ãã„ã¨æ€ã‚ã‚Œã‚‹æ—¥æœ¬ã®ã‚µã‚¤ãƒˆå‘ã‘ã¨ã—ã¦å•é¡Œã®æ¦‚è¦ã¨å¯¾å‡¦æ–¹æ³•ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«è©³ã—ã„æ–¹ãªã‚‰ã©ã®ã‚ˆã†ãªæ¡ä»¶ã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒå¯èƒ½ã«ãªã‚‹ã‹ç°¡å˜ã«åˆ†ã‹ã‚Šã¾ã™ã€‚addslashesã‚„str_replaceã«ã‚ˆã‚‹ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå±é™ºã§ã‚ã‚‹ã“ã¨ã¯åºƒãçŸ¥ã‚‰ã‚Œã¦ã„ã‚‹æ—¢çŸ¥ã®å•é¡Œã¨ã„ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚è‹±èªžã§è¨˜è¿°ã•ã‚ŒãŸãƒ–ãƒã‚°ç‰ã«ã‚‚ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã®å•é¡Œã‚’å–ã‚Šæ‰±ã£ã¦ã‚‹ãƒšãƒ¼ã‚¸ã‚‚ã‚ã‚Šã¾ã™ã€‚ã‚ã¾ã‚Šé•·æœŸé–“æ”¾ç½®
gnw 2006/09/12
db

postgresql

security
ãƒªãƒ³ã‚¯
pgFoundry: Forum: pgpool-II released
gnw 2006/09/08
db

pgpool

postgresql
ãƒªãƒ³ã‚¯
åŒ…å¤´å¸‚åˆ›åŠžæˆ’æ¯’å®¶å±žå¦æ ¡â€œç…§äº®â€æˆ’æ¯’äººå‘˜å›žå®¶è·¯ ç¼–è¾‘ï¼šæˆ’æ¯’å®¶å±žå¦çŽ‹ä¸œéœ‡-æ¦å†ˆæ–°æ“žè”¬èœè¡Œæƒ…ç½‘
æœ€æ–°æ–‡ç« 2018-12-26 18:36â–ª åŠæ—¶æ´åŠ©ï¼å•å¦‡é™•è¥¿å—è·¯åœ°é“ç«™å†…ä¸´ç›†åœ°é“å·¥ä½œäººå‘˜æ–½ä»¥æ´æ‰‹ 2018-12-26 18:36â–ª 17æ¡ç”Ÿæ€å»Šé“ç¼–ç»‡å·¨å¤§â€œç»¿é¡¹é“¾â€ä¸Šæµ·æ£®æž—è¦†ç›–çŽ‡å‡è‡³16... 2018-12-26 18:36â–ª å¤§å†¶å‘ç”Ÿä¸€èµ·3äººæ»äº¡çš„å†’é¡¶äº‹æ•…å…¬å¸æ‰€å±žçŸ¿å±±è¿žç»7å¹´å‘ç”Ÿ... 2018-12-26 18:36â–ª å¤®è¡Œï¼šå››å£åº¦88.8%çš„å±…æ°‘è®¤ä¸ºæ”¶å…¥å¢žåŠ æˆ–åŸºæœ¬ä¸å˜ 2018-12-26 18:36â–ª â€œç¬¬ä¸‰å±Šå¤§ä½¿å›¾ä¹¦è§’â€å›¾ä¹¦æèµ åœ¨é‡‘è¾¹ä¸¾è¡Œ 2018-12-26 18:36â–ª çˆ¶æ¯ä¸è®©çŽ©ç”µè„‘ï¼Œå¥¹å°±åœ¨çº¸ä¸Šå†™ä»£ç ï¼9å²å¥³å©ä»Ž4000äººä¸... 2018-12-26 18:36â–ª é«˜ç©ºå è½æ°´æ³¥å—ç ¸ç ´4å²å¥³ç«¥å¤´éƒ¨è¦æ–¹æ•°æœˆå¯»å‡¶ç»ˆç ´æ¡ˆ 2018-12-26 18:36â–ª ä¸å›½è¦ä¼â€œæŠ±å›¢â€æ‰“å‡å‡€åŒ–é…’ç±»å¸‚åœº 2018-12-26 18:36â–ª äº¤å·¡è¦å®¢ä¸²èµ°å¤±å¥³ç«¥â€œæš–çˆ¸â€å®žåŠ›å® å¨ƒå¼•ç½‘å‹ç¾¡æ…•
gnw 2006/08/17
db

postgresql

è² è·å¯¾ç–
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬29å›ž PostgreSQLèª•ç”Ÿ10å‘¨å¹´! Anniversary Summité–‹å‚¬
7æœˆ8æ—¥ã‹ã‚‰9æ—¥ã¾ã§ï¼ŒPostgreSQLã®èª•ç”Ÿ10å‘¨å¹´ã‚’è¨˜å¿µã—ã¦PostgreSQL Anniversary SummitãŒã‚«ãƒŠãƒ€ã®ãƒˆãƒãƒ³ãƒˆã§é–‹å‚¬ã•ã‚ŒãŸã€‚ ç†è€…ã‚‚ã“ã®ã‚¤ãƒ™ãƒ³ãƒˆã«å‚åŠ ã—ãŸã®ã§ï¼Œãã®æ¨¡æ§˜ã‚’ãƒ¬ãƒãƒ¼ãƒˆã™ã‚‹ã€‚ æ´å²çš„ãªã‚¤ãƒ™ãƒ³ãƒˆã«100åä»¥ä¸Šã®å‚åŠ è€… ã“ã®æ´å²çš„ãªã‚¤ãƒ™ãƒ³ãƒˆã«ã¯89åã®PostgreSQLé–‹ç™ºè€…ã‚’ä¸å¿ƒã«, 100äººä»¥ä¸ŠãŒé›†ã¾ã£ãŸã€‚å‚åŠ è€…ã¯åŒ—ç±³ã‚„ãƒ¨ãƒ¼ãƒãƒƒãƒ‘ã‚’ã¯ã˜ã‚ï¼Œæ—¥æœ¬ï¼Œãƒã‚·ã‚¢ï¼Œ ä¸å›½ï¼Œæ±æ¬§ï¼Œãƒˆãƒ«ã‚³ãªã©æ§˜ã€…å›½ã‹ã‚‰çµé›†ã™ã‚‹ã¨ã„ã†ï¼Œã˜ã¤ã«å›½éš›è‰²è±Šã‹ãªã‚¤ãƒ™ ãƒ³ãƒˆã«ãªã£ãŸã€‚ ãƒ‡ã‚£ãƒŠãƒ¼ã‚¯ãƒ«ãƒ¼ã‚º ç†è€…ã¯ã‚µãƒŸãƒƒãƒˆå‰æ—¥ã®7æœˆ7æ—¥ã«ãƒˆãƒãƒ³ãƒˆå…¥ã‚Šã—ãŸã€‚ç©ºæ¸¯ã‹ã‚‰ã®ã‚¿ã‚¯ã‚·ãƒ¼ãŒæ¸‹æ»žã« å·»ãè¾¼ã¾ã‚Œï¼Œãƒ›ãƒ†ãƒ«ã«ç€ã„ãŸã®ãŒå¤•æ–¹6æ™‚30åˆ†ã€‚ã‚ã‚ãŸã ã—ããƒã‚§ãƒƒã‚¯ã‚¤ãƒ³ã‚’ã™ ã¾ã›ï¼Œè¿‘ãã®ãƒ›ãƒ†ãƒ«ã‹ã‚‰7æ™‚å‡ºç™ºã®ãƒ‡ã‚£ãƒŠãƒ¼ã‚¯ãƒ«ãƒ¼ã‚ºãƒãƒ£ãƒ¼ã‚¿ãƒ¼ãƒã‚¹ã«ãŽã‚ŠãŽã‚Š é–“ã«åˆã£ãŸã€‚ ã“ã®ãƒ„ã‚¡ãƒ¼ã¯PostgreSQLã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸå•†ç”¨ãƒ‘
gnw 2006/08/01
postgresql

db
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸