[B! pgpool] yagitoshiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yagitoshiro id:yagitoshiro

pgpoolã«é–¢ã™ã‚‹yagitoshiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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 7.4ã§pgpool-IIã®ãƒªã‚«ãƒãƒªæ©Ÿèƒ½ã‚’ä½¿ã†ï½žè¨å®šç·¨ | Ikeda->Weblog();
ã»ã‚“ã£ã¨ã«ãƒ¡ãƒ¢ã§ã™ï¼¾ï¼¾ï¼› pgpool-II å…¬å¼ãƒšãƒ¼ã‚¸ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚ˆã‚‹ã¨ã€è¡Œã†ã¹ãã“ã¨ã¯ pgpoolã®è¨å®š Cè¨€èªžé–¢æ•°ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒªã‚«ãƒãƒªã‚¹ã‚¯ãƒªãƒ—ãƒˆã®é…ç½® ã®3ç‚¹ã€‚ pgpoolã®è¨å®š pgpool.confã®ä»¥ä¸‹ã®å€¤ã‚’è¨å®šã—ã¾ã™ã€‚ backend_data_directory ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª($PGDATA)ã€‚ recovery_user ãƒªã‚«ãƒãƒªã«ä½¿ç”¨ã™ã‚‹ãƒ¦ãƒ¼ã‚¶IDã€‚ recovery_password ãƒã‚°ã‚¤ãƒ³ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã€‚ recovery_1st_stage_command recovery_2nd_stage_command pgpoolã§ã¯2ã¤ã®ã‚¹ãƒ†ãƒ¼ã‚¸ã«åˆ†ã‘ã¦ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒªãŒè¡Œã‚ã‚Œã¾ã™ã€‚ã“ã“ã«ãã‚Œãžã‚Œã®ã‚¹ãƒ†ãƒ¼ã‚¸ã§å®Ÿè¡Œã™ã¹ãã‚³ãƒžãƒ³ãƒ‰ã‚’æŒ‡å®šã—ã¾ã™ã€‚ Cè¨€èªžé–¢æ•°ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒªã‚«ãƒãƒªã‚’å®Ÿæ–½ã™ã‚‹ãŸã‚ã®Cè¨€èªžé–¢æ•°ã‚’å…¨ãƒŽãƒ¼ãƒ‰ã® template1 ãƒ‡ãƒ¼
yagitoshiro 2010/03/11
PostgreSQL

pgpool
ãƒªãƒ³ã‚¯
pgpool-II user manual
yagitoshiro 2009/07/13
Multi-statement Query (for all modes) pgpool-II cannot process multi-statement query.

PostgreSQL

pgpool

Replication
ãƒªãƒ³ã‚¯
ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ï¼šã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã—ã¾ã—ãŸã€‚
ã€Œã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ã€ã¯ 2023å¹´1æœˆ31æ—¥ ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹æä¾›ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ 2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Š19å¹´è¿‘ãã‚‚ã®é–“ã€æ²¢å±±ã®çš†ã•ã¾ã«ã”æ„›ç”¨ã„ãŸã ãã¾ã—ãŸã“ã¨ã‚’å¿ƒã‚ˆã‚ŠãŠç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ä»Šå¾Œã¨ã‚‚ã€BIGLOBEã‚’ã”æ„›é¡§è³œã‚Šã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ â€»å¼•ã£è¶Šã—å…ˆãƒ–ãƒã‚°ã¸ã®ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã¯2024å¹´1æœˆ31æ—¥ã§çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ BIGLOBEã®ã‚µãƒ¼ãƒ“ã‚¹ä¸€è¦§
yagitoshiro 2008/12/22
PostgreSQL

pgpool
ãƒªãƒ³ã‚¯
Â» ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æ´»å‹• - æ ªå¼ä¼šç¤¾SRA OSS
å¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«ã§ TRUNCATE ãƒˆãƒªã‚¬ã®ä½¿ç”¨ã‚’å¯èƒ½ã«(PostgreSQL 16) make_ctags ã¨ make_etags ã®æ”¹å–„(PostgreSQL 16) pgbench ã®æ”¹è‰¯(PostgreSQL 14, PostgreSQL 15) ãƒ“ãƒ¥ãƒ¼ã®ãƒãƒƒã‚¯æ©Ÿèƒ½ã®å®Ÿè£…(PostgreSQL 11) ã‚·ã‚¹ãƒ†ãƒ ã‚«ã‚¿ãƒã‚°æƒ…å ±ã‚’å–å¾—ã™ã‚‹é–¢æ•°ã®è¿½åŠ (PostgreSQL 9.4) ãƒ©ãƒ¼ã‚¸ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ä¸Šé™ã‚µã‚¤ã‚ºã®æ”¹è‰¯(PostgreSQL 9.3) Windows 64 ãƒ“ãƒƒãƒˆå¯¾å¿œï¼ˆPostgreSQL 9.0ï¼‰ å†å¸° SQLï¼ˆPostgreSQL 8.4ï¼‰
yagitoshiro 2007/11/21
pgpool
ãƒªãƒ³ã‚¯
[SQL] 1.ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯
2007.2.12ã€€æ ªå¼ä¼šç¤¾å››æ¬¡å…ƒãƒ‡ãƒ¼ã‚¿ã€€å®®æ¾¤äº†ç¥ãƒ»å†…ç”°åº·ä»‹ PosgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨æ©Ÿèƒ½æ¯”è¼ƒ 1ç« ã€€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ 1.1. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ 1.2. pgpool-II 1.3. PGCluster 1.4. PostgresForest 1.5. ã‚¦ã‚©ãƒ¼ãƒ ã‚¹ã‚¿ãƒ³ãƒã‚¤ 1.6. ã¾ã¨ã‚ 1.1. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ã€åŒã˜å†…å®¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(è¤‡è£½ï¼ãƒ¬ãƒ—ãƒªã‚«)ã‚’ä½œæˆã™ã‚‹ã“ã¨ã§è² è·åˆ†æ•£ã‚„è€éšœå®³æ€§ã‚’é«˜ã‚ã‚‹æŠ€è¡“ã§ã™ã€‚ åŒæœŸã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ã‚‚ã®ã¨ã€éžåŒæœŸã§è¡Œã†ã‚‚ã®ã®äºŒç¨®ã«åˆ†ã‹ã‚Œã¾ã™ã€‚ éžåŒæœŸæ–¹å¼ã¯ã€ãƒžã‚¹ã‚¿ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦ã®æ›´æ–°æƒ…å ±ã‚’ä¿å˜ã—ã€å¾Œã§ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ›´æ–°æƒ…å ±ã‚’é€ä¿¡ã—ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ã¨ã„ã£ãŸæ–¹æ³•ã‚’ç”¨ã„ã¾ã™ã€‚ æ€§èƒ½åŠ£åŒ–ãŒå°‘ãªã„ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãŒå®Œå…¨ã«ä¸€è‡´ã—ãªã„æ™‚é–“ãŒå˜åœ¨ã™ã‚‹ã¨ã„ã†ãƒ‡ãƒ¡ãƒªãƒƒãƒˆã‚‚ã‚ã‚Šã¾ã™ã€‚
yagitoshiro 2007/06/11
æœ€è¿‘ã®pgpoolã¯å¾©æ—§ãƒ„ãƒ¼ãƒ«ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã‘ã©ãã€‚

PostgreSQL

pgpool

pgcluster

postgresforest
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

pgpoolã«é–¢ã™ã‚‹yagitoshiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬5é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬4é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

pgpoolã«é–¢ã™ã‚‹yagitoshiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

[ãƒ¡ãƒ¢] PostgreSQL 7.4ã§pgpool-IIã®ãƒªã‚«ãƒãƒªæ©Ÿèƒ½ã‚’ä½¿ã†ï½žè¨­å®šç·¨ | Ikeda->Weblog();

pgpool-II user manual

ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒ­ã‚°ï¼šã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã—ã¾ã—ãŸã€‚

Â» ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æ´»å‹• - æ ªå¼ä¼šç¤¾SRA OSS

[SQL] 1.ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬5é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬4é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

pgpoolã«é–¢ã™ã‚‹yagitoshiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

[ãƒ¡ãƒ¢] PostgreSQL 7.4ã§pgpool-IIã®ãƒªã‚«ãƒãƒªæ©Ÿèƒ½ã‚’ä½¿ã†ï½žè¨å®šç·¨ | Ikeda->Weblog();

ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ï¼šã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã—ã¾ã—ãŸã€‚

Â» ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æ´»å‹• - æ ªå¼ä¼šç¤¾SRA OSS

[SQL] 1.ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬5é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬4é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹