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

masakitk id:masakitk

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

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

é™å®šå…¬é–‹ç”¨ã«é–¢ã™ã‚‹è¨˜äº‹
ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯Mayonezã«æŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹ã€Œé™å®šå…¬é–‹ç”¨ã€ã«é–¢ã™ã‚‹è¨˜äº‹ã‚’ãŸãã•ã‚“ã”ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚Mayonezã§ã€Œé™å®šå…¬é–‹ç”¨ã€ã«é–¢ã™ã‚‹è¨˜äº‹ã‚’ãŠæ¥½ã—ã¿ãã ã•ã„ã€‚ Unityå…¥é–€ã«æœ€é©ãªãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚µã‚¤ãƒˆã¾ã¨ã‚ãƒ»æ¯”è¼ƒä»Šå›žã¯Unityã§ã®ã‚²ãƒ¼ãƒ é–‹ç™ºã‚’å§‹ã‚ã‚‹ã¨ãã«å‚è€ƒã«ãªã‚‹ã€å…¥é–€ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚µã‚¤ãƒˆã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚å…¨ããƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ã®æ–¹ã‹ã‚‰ã€ä»–ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§é–‹ç™ºã‚’ã—ãŸã“ã¨ãŒã‚ã‚‹æ–¹ã‚’å¯¾è±¡ã«ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ å…¥é–€ã«æœ€é©ï¼C++ã‚’å¦ç¿’ã§ãã‚‹ç„¡æ–™ã‚µãƒ¼ãƒ“ã‚¹10ä»Šå›žã¯ã€C è¨€èªžã‚’ç„¡æ–™ã§å¦ç¿’ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚C ã‚’ã“ã‚Œã‹ã‚‰å¦ç¿’ã—ãŸã„ã¨æ€ã£ã¦ã„ã‚‹æ–¹ã‚„åˆå¿ƒè€…ã¯ã‚‚ã¡ã‚ã‚“ã€æ—¢ã«Cã‚’ç¿’å¾—ã—ã¦ã„ã‚‹ã¨ã„ã†æ–¹ã‚‚ã€å¾©ç¿’ã—ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ï¼Ÿ
masakitk 2021/02/04
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã®ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«å…¥é–€ã€€ï¼ˆæš—è¨˜ç”¨ã®SQLé›†ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
PostgreSQLã§ï¼Œã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®å…¥é–€ã€‚ ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½¿ã„æ–¹ã‚’è¦šãˆã‚Œã°ï¼Œè‡ªåˆ†ãŒä½œã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆæƒ…å ±ã‚„ï¼Œãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹äº‹ãŒã§ãã‚‹ã€‚ DBãã®ã‚‚ã®ã®ç†è§£ã‚‚æ·±ã¾ã‚‹ã€‚ ï¼ˆï¼‘ï¼‰æƒ…å ±ã‚¹ã‚ãƒ¼ãƒžï¼ˆäººé–“ã«ç†è§£ã—ã‚„ã™ã„ã€‚èª¿ã¹ç‰©ã‚’ã™ã‚‹ã¨ãä¾¿åˆ©ï¼‰ ã‚«ãƒ©ãƒ ä¸€è¦§ åˆ¶ç´„ä¸€è¦§ ï¼ˆï¼’ï¼‰çµ±è¨ˆæƒ…å ±ãƒ“ãƒ¥ãƒ¼ï¼ˆãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹èª¿æ•´ã«ä¾¿åˆ©ï¼‰ ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ æŽ¥ç¶šãƒ—ãƒã‚»ã‚¹ä¸€è¦§ ï¼ˆï¼“ï¼‰ã‚·ã‚¹ãƒ†ãƒ ã‚«ã‚¿ãƒã‚°ï¼ˆã‚¢ãƒ—ãƒªã‹ã‚‰ã®åˆ©ç”¨å‘ã‘ï¼‰ ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ æ´»ç”¨ä¾‹ ä»¥ä¸‹ã®SQLã¯ï¼Œè¦šãˆã‚„ã™ã„ã‚ˆã†ã«ã‚·ãƒ³ãƒ—ãƒ«ã«è¨˜è¼‰ã—ã¦ã‚ã‚‹ã€‚ ã„ã–ã¨ã„ã†æ™‚ã«ä½¿ã†ãŸã‚ã«ï¼Œå…¨éƒ¨æš—è¨˜ã—ã‚ˆã†ã€‚ å¿…è¦ã«å¿œã˜ã¦PostgreSQLã®æœ€æ–°ç‰ˆã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã“ã¨ã€‚ PostgreSQLæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ http://www.postgresql.jp/document/ ï¼ˆï¼‘ï¼‰æƒ…å ±ã‚¹ã‚ãƒ¼ãƒžï¼ˆinformation_schemaï¼‰ã‚’ä½¿ãŠã† Postgr
masakitk 2012/07/31
postgresql

DB
ãƒªãƒ³ã‚¯
Symfoware
PostgreSQL 14ã‚’Ubuntu 20.04ã¸ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€å¤–éƒ¨ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ PostgreSQL 14ã‚’Ubuntu Server 20.04ã¸ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã¾ã™ã€‚ éŽåŽ»è¨˜äº‹ã®ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã—ã¾ã—ãŸ PostgreSQL 13.3ã‚’Ubuntu 20.04ã¸ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€å¤–éƒ¨ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ https://wiki.postgresql.org/wiki/Apt ãƒªãƒã‚¸ãƒˆãƒªã®è¿½åŠ /etc/apt/sources.list.d/pgdg.listã‚’ä½œæˆ ãƒªãƒã‚¸ãƒˆãƒªã®ãƒ‘ã‚¹ã‚’è¨˜è¼‰ã—ã¾ã™ã€‚ $ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
masakitk 2012/07/23
postgresql
ãƒªãƒ³ã‚¯
EUDC
masakitk 2012/03/06
postgresql

UTF-8
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒªã‚«ãƒãƒª (1) - aaabbb_200904ã®æ—¥è¨˜
Nagios ã¨ã®é€£æºã‹ã‚‰å§‹ã¾ã£ãŸã®ã ãŒã€æœ€è¿‘PostgreSQLã‚’é›†ä¸ã—ã¦è§¦ã£ã¦ã„ã‚‹ã€‚ãã®ä¸ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—&ãƒªã‚«ãƒãƒªã‚’è©¦ã—ã¦ã¿ãŸã€‚ PostgreSQL ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã€DBã®æ©Ÿèƒ½ã‚’ä½¿ã£ãŸã‚‚ã®ã§ã¯ã€ 1. pg_dump ã«ã‚ˆã‚‹DBã”ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— 2. WALã«ã‚ˆã‚‹ãƒ•ãƒ«ãƒ»å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãŒã‚ã‚‹ã€‚ pg_dump ã¯DBã”ã¨ã«ã¾ã¨ã‚ã¦ãƒ€ãƒ³ãƒ—ã‚’å–ã‚‹æ–¹æ³•ã§ã€ãã®åˆ†å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å–ã‚Œãªã„ã€‚ ä¸€æ–¹2ã®WALãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°(å¤‰æ›´å†…å®¹ã‚’æ›¸ãå‡ºã—ãŸãƒ•ã‚¡ã‚¤ãƒ«)ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã§ã€å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå¯èƒ½ã¨ãªã‚‹ã€‚ ãŸã ã—ã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã”ã¨ã« WALã¯1ã¤ã ã‘ã‚‰ã—ãã€DBã”ã¨ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹å ´åˆã«ã¯ã€ãã‚Œãžã‚Œã‚’ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¨ã—ã¦åˆ†å‰²ã™ã‚‹ã‹ã€pg_dump ã§å€‹åˆ¥ã«å–ã‚‹ã‹ãªã©ã®å¯¾å¿œãŒå¿…è¦ã«ãªã‚Šãã†ã ã€‚ 1ã®pg_dump ã¯ä½¿ã„æ–¹ãŒå‰²åˆç°¡å˜ã§ã€ä¾‹ãˆã°ã€mmmã¨ã„ã†DBã®ãƒãƒƒã‚¯ã‚¢
masakitk 2011/09/14
PostgreSQL

DB

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: PostgreSQL
Which method is best to select values present in one table but missing in another one? This: SELECT l.* FROM t_left l LEFT JOIN t_right r ON r.value = l.value WHERE r.value IS NULL , this: SELECT l.* FROM t_left l WHERE l.value NOT IN ( SELECT value FROM t_right r ) or this: SELECT l.* FROM t_left l WHERE NOT EXISTS ( SELECT NULL FROM t_right r WHERE r.value = l.value ) Let's see for PostgreSQL 8.
masakitk 2011/07/27
DB

postgresql
ãƒªãƒ³ã‚¯
SSDã¨SATAã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯æ¯”è¼ƒ ç¬¬2ãƒ©ã‚¦ãƒ³ãƒ‰ï¼šã‚µãƒ¼ãƒã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
SSDã¨SATAã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯æ¯”è¼ƒ ç¬¬2ãƒ©ã‚¦ãƒ³ãƒ‰ï¼šã‚µãƒ¼ãƒã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼šValidation Case Studyï¼ˆ2/2 ãƒšãƒ¼ã‚¸ï¼‰ ãƒ†ã‚¹ãƒˆã§ç‰¹å®šã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è©•ä¾¡ã™ã‚‹ã¨ãã¯ã€ãã‚Œä»¥å¤–ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå˜åœ¨ã—ãªã„çŠ¶æ³ã§ãƒ†ã‚¹ãƒˆã™ã‚‹ã“ã¨ã«ã—ã¦ã„ã‚‹ã€‚ãã“ã§ã€SSDä¸Šã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ã¨ãã¯HDDä¸Šã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’äº‹å‰ã«å‰Šé™¤ã—ã€HDDä¸Šã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ã¨ãã¯SSDä¸Šã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å‰Šé™¤ã™ã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã”ã¨ã«3ç¨®é¡žã®selectã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ãŸã€‚å„ã‚³ãƒžãƒ³ãƒ‰ã¯ãã‚Œãžã‚Œã‚³ãƒ¼ãƒ«ãƒ‰ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã†æ“ä½œã€ãƒ›ãƒƒãƒˆã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã†æ“ä½œã€â€œã‚¯ãƒã‚¹â€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã†æ“ä½œã«å¯¾å¿œã™ã‚‹ã€‚ ã‚³ãƒ¼ãƒ«ãƒ‰ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã‚ˆã‚‹æ“ä½œã§ã¯ã€ã„ã£ãŸã‚“PostgreSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åœæ¢ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SSDãƒ†ãƒ¼ãƒ–ãƒ«ç©ºé–“ã®ç½®ã‹ã‚Œã¦ã„ã‚‹ãƒ‡ã‚£ã‚¹ã‚¯ã‚’ãƒžã‚¦ãƒ³ãƒˆè§£é™¤ã—ã¦ã‹ã‚‰ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ãŸã€‚ãƒ›ãƒƒãƒˆãƒ†ã‚¹ãƒˆã§ã¯ã€åŒã˜ã‚¯ã‚¨ãƒªã‚’2å›žå®Ÿè¡Œ
masakitk 2011/07/01
ãƒ†ã‚¹ãƒˆ

postgresql

ssd
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
masakitk 2011/06/24
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã§ãƒ¦ãƒ¼ã‚¶ãƒ¼ã”ã¨ã«å‚ç…§ã™ã‚‹ã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã‚’å¤‰æ›´ã—ãŸã„å ´åˆã®è¨å®šã„ã‚ã„ã‚ - ä¾ç”°ãƒˆãƒžãƒˆã«ã¤ã
ã·ã‚ãã‚‰ã¾å‚™å¿˜ãƒ¡ãƒ¢çš„ã«postgresã§ã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã‚’å¤‰æ›´ã™ã‚‹ï¼ˆã‚»ãƒƒã‚·ãƒ§ãƒ³ä¸ã®ã¿ï¼‰ä»¥ä¸‹ã®SQLã‚’å®Ÿæ–½ SET search_path TO ã‚¹ã‚ãƒ¼ãƒžå; postgresã§ã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã‚’å¤‰æ›´ã™ã‚‹ï¼ˆå…¨ãƒ¦ãƒ¼ã‚¶ï¼‰postgresql.confã«ä»¥ä¸‹ã®è¨å®šè¡Œã‚’è¿½åŠ ï¼ˆã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆã•ã‚Œã¦ã„ã‚‹ï¼‰search_path = 'ã‚¹ã‚ãƒ¼ãƒžå'ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯'"$user",public'ã¨ãªã£ã¦ãŠã‚Šã€æŽ¥ç¶šãƒ¦ãƒ¼ã‚¶ã®ã‚¹ã‚ãƒ¼ãƒžã‚’ã¾ãšç¢ºèªã—ã€ãªã‘ã‚Œã°publicã‚’ç¢ºèªã™ã‚‹ã¨ã„ã†é€šå¸¸ä½¿ç”¨ã•ã‚Œã¦ã„ã‚‹ãƒ‘ã‚¹ã§ã‚ã‚‹ã€‚postgresã§ã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã‚’å¤‰æ›´ã™ã‚‹ï¼ˆãƒ¦ãƒ¼ã‚¶ã”ã¨ï¼‰ä»¥ä¸‹ã®SQLã‚’å®Ÿæ–½ ALTER USER ãƒ¦ãƒ¼ã‚¶å SET search_path TO ã‚¹ã‚ãƒ¼ãƒžå; CREATEæ™‚ã«ã“ã‚ŒãŒæŒ‡å®šã§ãã‚‹ã‹ã¯ç¢ºèªã—ã¦ã„ãªã„ã€‚
masakitk 2011/06/22
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒª(PITR)ã‚ã‚‚ - ã‚ã‚‰ã‚Œãã“ã®ã‚ã‚‚
PostgreSQLã®ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒª(PITR)ã®ã—ãã¿ã¨ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹é †ã€ãƒªã‚«ãƒãƒªæ‰‹é †ã®ã‚ã‚‚ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ¦‚è¦ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ç¨®é¡ž pg_dump ã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ãŸã¾ã¾ã€pg_dumpã‚³ãƒžãƒ³ãƒ‰ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã—ã¾ã™ã€‚DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ãŸæ™‚ç‚¹ã®ãƒ‡ãƒ¼ã‚¿ã«æˆ»ã™ã“ã¨ãŒã§ãã¾ã™ã€‚PostgreSQLã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç•°ãªã‚‹ã¨ãã€ã“ã®æ–¹æ³•ã§ãƒ‡ãƒ¼ã‚¿ã®ç§»è¡Œã‚’è¡Œã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚µãƒ¼ãƒã‚’åœæ¢å¾Œã€dataãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä»¥ä¸‹ã‚’ã¾ã‚‹ã¾ã‚‹ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ãŸæ™‚ç‚¹ã®ãƒ‡ãƒ¼ã‚¿ã«æˆ»ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã€ã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ãŸã¾ã¾ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚ã¾ãŸã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°ã‚‚å–å¾—ã—ã¾ã™ã€‚ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°ã‚’é©ç”¨ã™ã‚‹ã“ã¨ã§ã€DBã®çŠ¶æ…‹ã‚’ä»»æ„ã®æ™‚åˆ»ã®æ™‚ç‚¹ã«æˆ»ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ã¯ã€ã“ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒ
masakitk 2011/05/12
postgresql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

DB
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
å°åŒ—å¸‚ç«‹å‹•ç‰©åœ’ã¨è¿ªåŒ–è¡—ã‚ãã‚Š åé€£ã‚Œå°æ¹¾#5 å¹´è¶Šã—å°æ¹¾ æ—…è¡Œ5æ—¥ç›®ã€ãƒ¬ã‚¸ãƒ£ãƒ¼ã‚„å‹äººã¨ã®é£Ÿäº‹ã‚’æ¥½ã—ã‚€æ—¥ã§ã™ã€‚å‰æ—¥ã®æ§˜åã¯ã“ã¡ã‚‰ www.oukakreuz.com å°åŒ—å¸‚ç«‹å‹•ç‰©åœ’ã¸ ãƒ‘ãƒ³ãƒ€é¤¨ ãƒ‘ãƒ³ãƒ€ãŒè¦‹ã‚‰ã‚Œã‚‹ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ è¿ªåŒ–è¡—ã¸ æž—èŒ‚æ£®èŒ¶è¡Œã§ãŠèŒ¶ã‚’è³¼å…¥ å°èŠ±åœ’ã§åˆºç¹ã‚°ãƒƒã‚ºã‚’è³¼å…¥ é»’æ¦å£«ç‰¹è‰²è€ç«é‹ã§å¤•é£Ÿ å°åŒ—å¸‚ç«‹å‹•ç‰©åœ’ã¸ æ¾â€¦
masakitk 2011/04/22
postgresql

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
PostgreSQL 8.3 ä»¥é™ã‹ã‚‰ã® postgresql.conf ã‚’ã€ã‚µãƒ¼ãƒãƒ¼ã‚¹ãƒšãƒƒã‚¯ã«ã‚ˆã‚‹ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’è¨å®šã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’èª¿æ•´ã™ã‚‹
DoRuby! (ãƒ‰ãƒ«ãƒ“ãƒ¼!) ã¯ç¾å ´ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã€ä¸»ã«Rubyãªã©ã®æŠ€è¡“ã«é–¢ã™ã‚‹æ§˜ã€…ãªå®Ÿè·µãƒŽã‚¦ãƒã‚¦ã‚’é›†ã‚ãŸæŠ€è¡“æƒ…å ±ã‚µã‚¤ãƒˆã§ã™ã€‚ ã“ã‚“ã«ã¡ã¯ã€O2 ã§ã™ã€‚ä»Šå›žã¯ã€postgresql ã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆpostgresql.confï¼‰ ã«é–¢ã—ã¦ã®ã€ç§ãŒæœ€è¿‘è¨å®šã—ã¦ã„ã‚‹ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’å…¬é–‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚Â å®Ÿéš›ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç›´å¾Œã®è¨å®šã§ã¯ã€ã€Œãƒãƒ¼ã‚¹ãƒšãƒƒã‚¯ã®ãƒžã‚·ãƒ³ç’°å¢ƒã§ã‚‚å‹•ä½œã™ã‚‹ã€è¨å®šã®ç‚ºæœ€è¿‘ã®ã‚µãƒ¼ãƒãƒ¼ã‚¹ãƒšãƒƒã‚¯ã«ã‚ã£ãŸã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’è¨˜è¿°ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚Â ã¨ã¯è¨€ã£ã¦ã‚‚ã€ç§ãŒæ‰±ã£ã¦ã„ã‚‹æœ€è¿‘ã®ã‚µãƒ¼ãƒãƒ¼ã®ãƒ¡ãƒ¢ãƒªã¯ã€8GBã€16GBã€32GB ã§ã€ã•ã‚‰ã«PostgreSQL 8.3ä»¥é™ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã§ã€PostgreSQL 8.3ä»¥é™ã§ã®ã€ãƒ¡ãƒ¢ãƒª3ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Â æ³¨æ„ï¼Žã‚ãã¾ã§ã‚‚ã€ç§ãŒå‰²ã‚Šå‡ºã—ãŸãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã§ã™ã®ã§ã€ã©ã®ã‚ˆã†ã«ä½¿ç”¨ã™ã‚‹ã‹ã«ã‚ˆã£ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯å¿…è¦ã«ãª
masakitk 2011/03/26
postgresql

è¨å®š

ãƒ¡ãƒ¢ãƒª

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Npgsql: User's Manual
masakitk 2011/03/25
postgresql

npgsql

è¨å®š
ãƒªãƒ³ã‚¯
è³‡æºã®æ¶ˆè²»
shared_buffers (integer) # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãŒå…±æœ‰ãƒ¡ãƒ¢ãƒªãƒãƒƒãƒ•ã‚¡ã®ãŸã‚ã«ä½¿ç”¨ã™ã‚‹ãƒ¡ãƒ¢ãƒªé‡ã‚’è¨å®šã—ã¾ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ä¸€èˆ¬çš„ã«128ãƒ¡ã‚¬ãƒã‚¤ãƒˆ(128MB)ã§ã™ã€‚ ã—ã‹ã—ã€ç¨¼åƒä¸ã®ã‚«ãƒ¼ãƒãƒ«ã®è¨å®šãŒã“ã®å€¤ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ãªã„å ´åˆã€ã‚ˆã‚Šå°‘ãªããªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ï¼ˆinit dbã®éŽç¨‹ã§æ±ºå®šã•ã‚Œã¾ã™ï¼‰ã€‚ ã“ã®è¨å®šã¯æœ€ä½Žé™128ã‚ãƒãƒã‚¤ãƒˆãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ã—ã‹ã—ã€è‰¯ã„æ€§èƒ½ã‚’å¼•ãå‡ºã™ãŸã‚ã«ã¯ã€æœ€å°å€¤ã‚ˆã‚Šã‹ãªã‚Šé«˜ã„å€¤ã®è¨å®šãŒé€šä¾‹å¿…è¦ã§ã™ã€‚ ã“ã®å€¤ãŒå˜ä½ãªã—ã§æŒ‡å®šã•ã‚ŒãŸå ´åˆã¯ã€ãƒ–ãƒãƒƒã‚¯å˜ä½ã§ã‚ã‚‹ã¨ã¿ãªã—ã¾ã™ã€‚ã™ãªã‚ã¡ã€BLCKSZãƒã‚¤ãƒˆã€ä¸€èˆ¬çš„ã«ã¯8kBã§ã™ã€‚ ï¼ˆBLCKSZãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã¨ç•°ãªã‚‹å ´åˆã€ã“ã®æœ€å°å€¤ã‚‚ç•°ãªã‚‹å€¤ã«ãªã‚Šã¾ã™ã€‚ï¼‰ ã“ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ã‚µãƒ¼ãƒèµ·å‹•æ™‚ã®ã¿è¨å®šå¯èƒ½ã§ã™ã€‚ 1GBä»¥ä¸Šã®RAMã‚’è¼‰ã›ãŸå°‚ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€shared_buffer
masakitk 2011/03/25
è¨å®š

postgresql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
[pgsql-jp: 40664] Re: postgresql windows64bitç‰ˆ psqlã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸
masakitk 2011/03/25
postgresql
ãƒªãƒ³ã‚¯
ã€ŽPL/pgSQLã§ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸å‡ºåŠ›ã€
PostgreSQL ã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ä½œã‚‹ã«ã¯ PL/pgSQL ã¨ã„ã†SQLæ‰‹ç¶šãè¨€èªžã‚’ä½¿ã„ã¾ã™ã€‚ Oracle ã§ã„ã†ã¨ã“ã‚ã® PL/SQL (ã ã£ãŸã£ã‘)ã€€ã«ã‚ãŸã‚‹ SQL æ‰‹ç¶šãè¨€èªžã§ã™ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ä½¿ã†ã¨æ•°å›ž SQL ã‚’å®Ÿè¡Œã—ã¦ãã®çµæžœã‚’ã”ã«ã‚‡ã”ã«ã‚‡ã¾ã¨ã‚ãŸã‚Šã—ãŸçµæžœã‚’1å›žã® select æ–‡ã§å–ã‚Šå‡ºã›ãŸã‚Šã™ã‚‹ã®ã§ä¾¿åˆ©ãªã®ã§ã™ãŒã€CGI ã®ã‚³ãƒ¼ãƒ‰ã ã‘è¦‹ã¦ã‚‚æŠŠæ¡ã§ããªã„ã®ãŒé›£ã§ã™ãã€‚ ã§ã€äººãŒä½œã£ãŸã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ã¡ã‚‡ã£ã¨æ”¹é€ ã—ãªãã¦ã¯ã„ã‘ãªããªã£ã¦ã€function å®šç¾©ã‚’èªã‚“ã¡ã‚‡ã“ã¡ã‚‡ã“ã£ã¨æ‰‹ã‚’å…¥ã‚Œã¦ã¿ãŸã®ã§ã™ãŒæ€ã†ã‚ˆã†ã«å‹•ã‹ãªã„ã€‚ ç§ã¯ãƒ‡ãƒãƒƒã‚°ã™ã‚‹ã¨ãã«ã¯ãƒ‡ãƒãƒƒã‚¬ã¯ã»ã¨ã‚“ã©ä½¿ã£ã¦ã„ãªãã¦ã€ãƒ‡ãƒãƒƒã‚°ãƒ©ã‚¤ãƒˆã‚’å…¥ã‚Œã¾ãã£ã¦ã©ã®ã‚ˆã†ã«ã‚³ãƒ¼ãƒ‰ãŒå‹•ãã®ã‹æŠŠæ¡ã—ãªãŒã‚‰ç›´ã—ã¾ã™ã€‚ã€‚ã‚¢ãƒŠãƒã‚°ã™ãŽã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã“ã‚Œã§æ¡ˆå¤–äº‹è¶³ã‚Šã‚‹ã®ã§ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›ž
masakitk 2011/03/08
postgresql

sql
ãƒªãƒ³ã‚¯
Trasis Lab Â» PostgreSQLã§ç¾åœ¨å®Ÿè¡Œä¸ã®SQLã®ç¢ºèªã¨ã€ãƒ—ãƒã‚»ã‚¹ã®kill
æ¦‚è¦ PostgreSQLä¸Šã§å®Ÿè¡Œä¸ã®SQLã‚’åœæ¢ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚ Javaã‚µãƒ¼ãƒä¸Šã§æ™‚é–“ã®ã‹ã‹ã‚‹SQLã‚’å®Ÿè¡Œã—ã¦ã—ã¾ã„ã€Javaã‚µãƒ¼ãƒã‚’åœæ¢ã›ãšã«ãã®ã‚¹ãƒ¬ãƒƒãƒ‰ã ã‘ã‚’åœæ¢ã—ãŸã„å ´åˆãªã©ã«ãŠã„ã¦ã€æ¬¡ã®æ‰‹é †ã§å®Ÿè¡Œã•ã‚ŒãŸ SQL ã‚’åœæ¢ã§ãã‚‹ã€‚ æ‰‹é † ãƒ—ãƒã‚»ã‚¹ID(pid)ã®ç¢ºèª ã¾ãšã€å•é¡Œã®SQLãŒå®Ÿè¡Œã•ã‚Œã‚‹ãƒ—ãƒã‚»ã‚¹ã®IDã‚’èª¿ã¹ã‚‹ã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãªã©ã§ã€æ¬¡ã®SQLã‚’å®Ÿè¡Œã€‚ SELECT procpid, start, now() - start AS lap, current_query FROM (SELECT backendid, pg_stat_get_backend_pid(S.backendid) AS procpid, pg_stat_get_backend_activity_start(S.backendid) AS start, pg_stat_get_backen
masakitk 2010/12/16
PostgreSQL
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒãƒƒãƒã‚’ï¼Œãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’èžã‹ã‚Œãšã«å®Ÿè¡Œã™ã‚‹æ–¹æ³• ï¼ˆpsqlã‚‚è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ç·¨é›†ã‚‚ä¸è¦ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ãƒãƒƒãƒã®ã¾ã¨ã‚TOPã¸ PostgreSQLã‚’ãƒãƒƒãƒã§è‡ªå‹•å®Ÿè¡Œã™ã‚‹æ–¹æ³•ã€‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ãªã—ã€‚ PostgreSQLã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰åˆ©ç”¨ã™ã‚‹ãŸã‚ã«ã¯ï¼Œé€šå¸¸ã¯psqlã‚’çµŒç”±ã™ã‚‹ã€‚ psqlã¯å®Ÿè¡Œæ™‚ã«å¿…ãšãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’èžã‹ã‚Œã‚‹ã®ã§ï¼Œãƒãƒƒãƒã«ã‚ˆã‚‹è‡ªå‹•é‹è»¢ã¯ä¸å¯èƒ½ã€‚ æŠ€è¡“çš„é›‘è«‡-PostgreSQLã®è‡ªå‹•é‹è»¢ http://www.himajin2001.com/wiki.cgi?page=%B5%BB%BD%D1%C5%AA%BB%A8%C3%CC-PostgreSQL%A4%CE%BC%AB%C6%B0%B1%BF%C5%BE .pgpassã§ã®è¨å®šå†…å®¹ã¨ã€psqlã§ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒå®Œå…¨ã«ä¸€è‡´ã—ãªã„ã¨å¯¾è©±å½¢å¼ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãªã©ã‚’èžã„ã¦ãã¦ã—ã¾ã„ã¾ã™ã€‚ psqlã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æŒ‡å®šã™ã‚‹æ–¹æ³•ã¯ã€Œãªã„ã€ã®ã§ã”æ³¨æ„ãã ã•ã„ã€‚ã“ã‚Œã¯ä»•æ§˜ã§ã™ã€‚ Postgresã®ä½¿ã£ã¦ã„ã‚‹è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆpgpass
masakitk 2010/11/25
postgresql

build

hudson

TEST
ãƒªãƒ³ã‚¯
æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š: PostgreSQL 8.4.4 ä»˜å±žãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
PostgreSQL 8.4.4 ä»˜å±žãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ æ—¥æœ¬èªžä»˜å±žæ–‡æ›¸ã«ã¤ã„ã¦ æ–‡æ›¸ãƒ»æ›¸ç±é–¢é€£åˆ†ç§‘ä¼šã®æ´»å‹•ã®ä¸€ç’°ã¨ã—ã¦ã€8.4.xã®ç¿»è¨³ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒé€²è¡Œä¸ã§ã™ã€‚ ç¾åœ¨(2010-09-24)ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.4.4ã‚’ç¿»è¨³å¯¾è±¡ã¨ã—ã¦ã„ã¾ã™ã€‚ç¬¬ä¸€æ¬¡ç¿»è¨³ã¯å®Œäº†ã—ã€æŸ»èªè€…ãªã©ãƒœãƒ©ãƒ³ãƒ†ã‚£ã‚¢ã‚’å‹Ÿé›†ã—ã¦ã„ã¾ã™ã€‚ ã“ã“ãŒã¡ã‚‡ã£ã¨ãŠã‹ã—ã„ã¨ã‹ç†è§£ã«è‹¦ã—ã‚€ã¨ã„ã£ãŸã‚³ãƒ¡ãƒ³ãƒˆãŒã‚ã‚Œã°ã€ãŠæ°—è»½ã« doc at postgresql.jpå®›ãƒ¡ãƒ¼ãƒ«ã‚’é€ã£ã¦ä¸‹ã•ã„ã€‚ æ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ(HTMLç‰ˆ)(2010-09-24) æ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ(PDFç‰ˆ)ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(2010-09-24) æ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä¸€å¼ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(2010-09-24) ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãƒšãƒ¼ã‚¸ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(2010-06-26) Unix manã‚³ãƒžãƒ³ãƒ‰ç”¨) å†é…å¸ƒã‚„ã‚³ãƒ”ãƒ¼ã«ã¤ã„ã¦ã¯ã€PostgreSQL ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ¡ä»¶ã«å¾“ã£ã¦ä¸‹ã•ã„ã€‚ ãŸã ã€
masakitk 2010/10/01
postgresql

ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
ãƒªãƒ³ã‚¯
è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ˆpg_dump ã¨ pg_dumpallï¼‰ | Let's POSTGRES
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ éˆ´æœ¨ å¹¸å¸‚ 3. è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†ãƒ„ãƒ¼ãƒ«ã¯ pg_dump åŠã³ pg_dumpall ã§ã™ã€‚ pg_dump ã¯ PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ã®å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ã¾ã™ã€‚pg_dumpall ã¯ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ã«æ ¼ç´ã—ã¦ã‚ã‚‹å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ã¾ã™ã€‚ pg_dump ã‚‚ pg_dumpall ã‚‚ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¾©å…ƒã™ã‚‹ãŸã‚ã«å¿…è¦ãª SQL æ–‡ã§æ§‹æˆã•ã‚Œã¾ã™ã€‚ å¾“ã£ã¦ã€pg_dump ã‚„ pg_dumpall ã‚’ä½¿ã†ã¨ PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’åˆ¥ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã—ãŸã‚Šã€ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚ pg_dump, pg_dumpall ã‚’ä½¿ã†ãŸã‚ã«ã¯ç‰¹åˆ¥ãªç”¨æ„ã¯ã„ã‚Šã¾ã›ã‚“ãŒã€
masakitk 2010/08/24
DB

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