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

itboy id:itboy

postgresqlã«é–¢ã™ã‚‹itboyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

PostgreSQL 10ã®æ–°æ©Ÿèƒ½ã®ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼
ã‚ãªãŸã«ã¨ã£ã¦é‡è¦ãªãƒˆãƒ”ãƒƒã‚¯ã‚„åŒåƒšã®æœ€æ–°æƒ…å ±ã‚’å…¥æ‰‹ã—ã¾ã—ã‚‡ã†æœ€æ–°ã®æ´žå¯Ÿã¨ãƒˆãƒ¬ãƒ³ãƒ‰ã«é–¢ã™ã‚‹æœ€æ–°æƒ…å ±ã‚’å³åº§ã«å—ã‘å–ã‚Šã¾ã—ã‚‡ã†ã€‚ ç¶™ç¶šçš„ãªå¦ç¿’ã®ãŸã‚ã«ã€ç„¡æ–™ã®ãƒªã‚½ãƒ¼ã‚¹ã«æ‰‹è»½ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã—ã‚‡ã†ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ãƒˆãƒ©ãƒ³ã‚¹ã‚¯ãƒªãƒ—ãƒˆä»˜ãå‹•ç”»ã€ãŠã‚ˆã³ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°æ•™æã€‚ è¨˜äº‹ã‚’ä¿å˜ã—ã¦ã€ã„ã¤ã§ã‚‚èªã‚€ã“ã¨ãŒã§ãã¾ã™è¨˜äº‹ã‚’ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã—ã¦ã€æº–å‚™ãŒã§ããŸã‚‰ã„ã¤ã§ã‚‚èªã‚ã¾ã™ã€‚
itboy 2017/05/01
postgresql
ãƒªãƒ³ã‚¯
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å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
itboy 2012/09/13
postgresql

mySQL

database
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ™ãƒ³ãƒ€ãƒ¼ã®ãŸã‚ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã€ŒSQL Anywhere OnDemand Editionã€
itboy 2011/08/10
ãƒ•ãƒ©ã‚°ã ã‚‰ã‘ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã£ã¦ç¢ºã‹ã«ã‚ˆãè¦‹ã‚‹ï½—

postgresql

database
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹ãƒˆãƒ¼ã‚¿ãƒ«ãƒ»ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ¼
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
itboy 2010/10/08
postgresql

security
ãƒªãƒ³ã‚¯
http://neta.ywcafe.net/000960.html
itboy 2009/02/23
database

postgresql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ãƒ¡ãƒ¢ã‚ã‚‚Memoãƒ»ãƒ»ãƒ» Â» Blog Archive Â» PostgreSQLã®å†—é•·åŒ–ã‚’è€ƒãˆã‚‹2ã€‚DRBD+heartbeat+WALã¯ã©ã†ã ã‚ã†ã€‚(Postgresqlè¨å®šã¨è»½ã„ãƒ†ã‚¹ãƒˆï¼‰
ä½œæ¥ãƒ¡ãƒ¢ã¨ã‹ã„ã‚ã‚“ãªè¨˜éŒ²admin 2008/12/12 11:26:39 ã¾ãšdrbd1,drbd2ã®ä¸¡ã‚µãƒ¼ãƒãƒ¼ã«æ™®é€šã«postgresqlã‚’å°Žå…¥ã™ã‚‹ã€‚å°Žå…¥å¾Œã€è‡ªå‹•èµ·å‹•ã‚’è§£é™¤ã™ã‚‹ã€‚ drbd2ã®postgresã¯åœæ¢ã—ã¦ãŠãã‚ˆã†ã«ã€‚ drbd1:~# apt-get install postgresql-8.1 Reading package lists... Done Building dependency tree... Done Suggested packages: oidentd ident-server The following NEW packages will be installed: postgresql-8.1 0 upgraded, 1 newly installed, 0 to remove and 5 not upgraded. Nee
itboy 2009/02/18
postgresql

éšœå®³å¯¾ç–
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬10å›ž åŸºå¹¹æ¥å‹™å‘ã‘ã«å¤§å¹…æ‹¡å¼µã•ã‚ŒãŸPostgreSQL 8.0ï¼Œãƒ™ãƒ¼ã‚¿ãƒ†ã‚¹ãƒˆé–‹å§‹
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬10å›ž åŸºå¹¹æ¥å‹™å‘ã‘ã«å¤§å¹…æ‹¡å¼µã•ã‚ŒãŸPostgreSQL 8.0ï¼Œãƒ™ãƒ¼ã‚¿ãƒ†ã‚¹ãƒˆé–‹å§‹ æ˜¨å¹´11æœˆã«PostgreSQL 7.4ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã‹ã‚‰9ã‚«æœˆï¼Œ8æœˆ10æ—¥ï¼Œã¤ã„ã«æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³8.0ã®ãƒ™ãƒ¼ã‚¿ãƒ†ã‚¹ãƒˆãŒé–‹å§‹ã•ã‚ŒãŸã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã®1ã‚±ã‚¿ç›®ã®æ•°å—ãŒä¸ŠãŒã‚‹ã®ã¯2000å¹´ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸ7.0ä»¥æ¥ã®ã“ã¨ã§ã‚ã‚Šï¼Œä»Šå›žã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‹ã‘ã‚‹é–‹ç™ºè€…ã®æ„æ°—è¾¼ã¿ãŒã†ã‹ãŒã‚ã‚Œã‚‹ã€‚ å¤§å¹…ã«æ©Ÿèƒ½ã‚’æ‹¡å¼µã—ãŸ8.0 å®Ÿéš›8.0ã§ã¯ä»Šã¾ã§ã®ãƒªãƒªãƒ¼ã‚¹ã§ã¯è¦‹ã‚‰ã‚Œãªã‹ã£ãŸã‚ˆã†ãªå¤§å¹…ãªæ©Ÿèƒ½æ‹¡å¼µãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã€‚ä»¥ä¸‹ï¼Œä¸»è¦ãªã‚‚ã®ã‚’åˆ—æŒ™ã—ãŸã€‚ ãƒã‚¤ãƒ³ãƒˆãƒ»ã‚¤ãƒ³ãƒ»ã‚¿ã‚¤ãƒ ãƒ»ãƒªã‚«ãƒãƒª(Point In Time Recovery) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æœ¬ä½“ãŒãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãªã©ã§å¤±ã‚ã‚Œã¦ã‚‚(ãƒ¡ãƒ‡ã‚£ã‚¢éšœå®³)ï¼Œãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒã‚°ã‹ã‚‰æœ€æ–°ã®çŠ¶æ…‹ã«å¾©å…ƒã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã—ãŸæ™‚ç‚¹ã¾
itboy 2009/02/16
postgresql

database
ãƒªãƒ³ã‚¯
PostgreSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã«ã€€ï½žé‡ã„SQLã®è¦‹ã¤ã‘æ–¹ï½ž : ã‚¢ã‚·ã‚¢ãƒ«ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ç‰§é‡Žã§ã™ã€‚ å…ˆæ—¥ã€ã‚ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§ä½¿ç”¨ã—ã¦ã„ã‚‹PostgreSQLã‚’è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ PostgreSQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ‰‹è»½ã«ä¸Šã’ã‚‹ã«ã¯ã€ ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’å¤‰æ›´ã™ã‚‹ ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ–¹ã§é‡ã„SQLã‚’ç™ºè¡Œã—ã¦ã„ã‚‹å ´æ‰€ã‚’è¦‹ã¤ã‘ã¦ã€ãã®éƒ¨åˆ†ã‚’ç›´ã—ã¦ã„ã ãƒ»vaccumã‚’å®Ÿè¡Œã™ã‚‹ ãªã©ã€ã„ãã¤ã‹æ–¹æ³•ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ä»Šå›žã¯ã€PostgreSQLã§å®Ÿè¡Œæ™‚é–“ãŒé•·ã„SQLã‚’è¦‹ã¤ã‘ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€ã¾ãšã¯ãƒ†ã‚¹ãƒˆç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãŠãã¾ã™ã€‚ <?php $dbÂ =Â pg_connect('dbname=test'); $sqlÂ =Â " CREATEÂ TABLEÂ artistÂ ( artist_idÂ serialÂ primaryÂ key, nameÂ textÂ notÂ null ) "; pg_query($sql); $sq
itboy 2008/05/13
postgresql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬26å›ž ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã«åˆ†æžã™ã‚‹ãƒã‚°è§£æžãƒ„ãƒ¼ãƒ«pgFouine
PostgreSQLã§ã¯ï¼Œpostgresql.confã‚’è¨å®šã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šï¼ŒSQLæ–‡ã‚„ãã®å®Ÿè¡Œæ™‚é–“ãªã©ã®æƒ…å ±ã‚’ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜éŒ²ã§ãã‚‹ã€‚ã“ã“ã§ã¯ã“ã®ãƒã‚°ã®ã“ã¨ã‚’ã€ŒSQLãƒã‚°ã€ã¨å‘¼ã¶ã“ã¨ã«ã—ã‚ˆã†ã€‚å˜ã«ã€Œãƒã‚°ã€ã¨ã„ã†ã¨ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°(WALãƒã‚°)ã¨æ··åŒã™ã‚‹æã‚ŒãŒã‚ã‚‹ã‹ã‚‰ã§ã‚ã‚‹ã€‚ SQLãƒã‚°ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªè¨˜éŒ²ãŒæ®‹ã‚‹ã€‚ LOG: statement: INSERT INTO history (tidï¼Œbidï¼Œaidï¼Œdeltaï¼Œmtime) VALUES (4ï¼Œ1ï¼Œ25891ï¼Œ8417ï¼ŒCURRENT_TIMESTAMP); LOG: duration: 72.786 ms
itboy 2007/09/18
postgresql

ãƒã‚°è§£æž
ãƒªãƒ³ã‚¯
plotless: UTF-8ã§ã®å…¨æ–‡æ¤œç´¢ãƒ¡ãƒ¢ï¼ˆPostgreSQL + Tsearch2 + MeCab ç·¨ï¼‰
æ…£ã‚Œãªã„ perlã€€ã«è‹¦æˆ¦ã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€"Bad free() ignored (PERL_CORE)" ã£ã¦è¦å‘ŠãŒå‡ºã¦ãã‚‹åŽŸå› ãŒã‚¤ãƒžã‚¤ãƒã‚ã‹ã‚Šã¾ã›ã‚“â€¦ã€‚ perl5.8ã‚’å…¥ã‚Œç›´ã—ã¦ã¿ã‚ˆã†ã‹ã¨portsã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ã‚ˆã†ã«ãªã‚‹ã—â€¦ã€‚å›°ã£ãŸãªãâ€¦ã€‚ ã§ã€ãã‚Œã¨ã¯é–¢ä¿‚ãªããƒã‚¹ã‚°ãƒ¬ã®Tsearch2 + MeCabã‚’ä½¿ã£ãŸå…¨æ–‡æ¤œç´¢ã®ä»•æ–¹ã‚’å¿˜ã‚Œãªã„ã‚ˆã†ã«ãƒ¡ãƒ¢ãƒ¡ãƒ¢ã€‚ å‚è€ƒã«ã—ãŸã®ã¯ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã€‚ https://www.oss.ecl.ntt.co.jp/tsearch2j/index.html http://www.emaki.minidns.net/Programming/postgres/index.html --- ç’°å¢ƒ ãƒ»FreeBSD 5.4 ãƒ»PostgreSQL 7.4.13 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ (/usr/ports/databases/postg
itboy 2007/04/23
postgresql

tsearch2

install
ãƒªãƒ³ã‚¯
1