¥µ¥Ý¡¼¥È
PostgreSQL/PowerGres ¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹
Âбþ¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Ë¡¢HP-UX¡¢ IBM Power Systems ¤òÄɲä·¤Þ¤·¤¿¡£
ÂåɽŪ¤Ê¥ª¡¼¥×¥ó¥½¡¼¥¹¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤¢¤ë PostgreSQL ¤ÎÍøÍѤò»Ù±ç¤¹¤ë¥µ¥Ý¡¼¥È¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
PostgreSQL ¤òÍøÍѤ·¤¿¥·¥¹¥Æ¥à¤Î³«È¯»þ¤«¤é±¿ÍѤޤǡ¢Éý¹¤¯³èÍѤ¤¤¿¤À¤±¤ë¥µ¡¼¥Ó¥¹ÆâÍÆ¤È¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£
ÆüËܤǺǽé¤Ë PostgreSQL ¤Î¥µ¥Ý¡¼¥È¤ò³«»Ï¤·¤¿Åö¼Ò¤¬¡¢Ä¹Ç¯¤Î·Ð¸³¤ò³è¤«¤·¤Æ¡¢ ¹âÉʼÁ¤«¤Ä¿×®¤ÊÂбþ¤ò¼Â»Ü¤·¤Æ¤¤¤Þ¤¹¡£
Ä̾ï¤Î¥µ¥Ý¡¼¥È¤Ç¤ÏÂоݳ°¤È¤Ê¤ë¡¢À߷פä¥Á¥å¡¼¥Ë¥ó¥°¤È¤¤¤Ã¤¿¹âÅÙ¤ÊÆâÍÆ¤â¥µ¥Ý¡¼¥È¤Ë´Þ¤ó¤Ç¤ª¤ê¡¢
PostgreSQL ¤Î³«È¯¤Ë´Ø¤ï¤ëÅö¼Ò¤¬¥½¡¼¥¹¥³¡¼¥É¥ì¥Ù¥ë¤ÇÂбþ¤µ¤»¤Æ¤¤¤¿¤À¤¯¡¢ÉʼÁ½Å»ë¤Î¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
SRA OSS ¤Î¥µ¡¼¥Ó¥¹¤Ï¤³¤³¤¬°ã¤¦¡ª
- ¥½¡¼¥¹¥³¡¼¥É¥ì¥Ù¥ë¤ÇÄ´ºº³Îǧ¤ò¹Ô¤¦¡¢¹âÉʼÁ¤Ê¥Ø¥ë¥×¥Ç¥¹¥¯¥µ¡¼¥Ó¥¹
- PostgreSQL ÍѤΥ¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤â¥µ¥Ý¡¼¥È
- ¥Ê¥ì¥Ã¥¸¥Ù¡¼¥¹¡¢¥Ë¥å¡¼¥¹ÇÛ¿®¤Ê¤É¡¢¼þÊÕ¥µ¡¼¥Ó¥¹¤â½¼¼Â
¥µ¡¼¥Ó¥¹ÆâÍÆ (³µÍ×)
¥Ø¥ë¥×¥Ç¥¹¥¯
¡ã ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤Î¥Ø¥ë¥×¥Ç¥¹¥¯ÂбþÈÏ°Ï ¡ä
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥ÐËÜÂΡ¢contrib¥Ä¡¼¥ë¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»
¥¤¥ó¥¹¥È¡¼¥ë¡¢ÀßÄê¡¢´ÉÍý¥Ä¡¼¥ë¤Î»È¤¤Êý¡ÊPowerGres¤Î¾ì¹ç¡Ë¡¢¥Þ¥Ë¥å¥¢¥ë¥ì¥Ù¥ë¤Î¤ªÌä¹ç¤»¡¢
¥Ç¡¼¥¿¥Ù¡¼¥¹À߷ס¢¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¥Á¥å¡¼¥Ë¥ó¥°¡¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»¡Ê°Ü¹Ô´ü´Ö¤Ë¸Â¤ë¡Ë - ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤ËÀܳ¤¹¤ë API
C¡Êlibpq¡Ë, JDBC, ODBC¡ÊpsqlODBC¡Ë, PHP, Npgsql
¡ã ¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤Î¥Ø¥ë¥×¥Ç¥¹¥¯ÂбþÈÏ°Ï ¡ä
- ¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»
¹½À®À߷ס¢¥¤¥ó¥¹¥È¡¼¥ë¡¢ÀßÄê¡¢´ÉÍý¥Ä¡¼¥ë¤Î»È¤¤Êý¡ÊÉÕ°¥Ä¡¼¥ë¤Ë¸Â¤ë¡Ë¡¢¥Þ¥Ë¥å¥¢¥ë¥ì¥Ù¥ë¤Î¤ªÌä¹ç¤»¡¢
¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¥Á¥å¡¼¥Ë¥ó¥°¡¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤Ë´Ø¤¹¤ë¤ªÌä¹ç¤»¡Ê°Ü¹Ô´ü´Ö¤Ë¸Â¤ë¡Ë
¾ã³²Âбþ
¾ã³²¸¶°ø¤òÄ´ºº¤·¡¢²þÁ±ºö¤ò¤´Ä󼨤¤¤¿¤·¤Þ¤¹¡£²þÁ±ºö¤ÎÄ󼨤ÏÉüµìÊýË¡¡¢²óÈòÊýË¡¤òÃæ¿´¤È¤·¤Þ¤¹¤¬¡¢
¥½¥Õ¥È¥¦¥§¥¢¤Î½¤Àµ¤Ç¤·¤«Âбþ¤Ç¤¤Ê¤¤¾ì¹ç¡¢²Äǽ¤Ê¸Â¤ê¥½¥Õ¥È¥¦¥§¥¢ËÜÂΤؤν¤Àµ¤ò¹Ô¤¤¤Þ¤¹¡£
¾ðÊóÇÛ¿®¥µ¡¼¥Ó¥¹
¥µ¥Ý¡¼¥ÈÂоݤΥ½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¾ðÊó¤äºÇ¿·¾ðÊó¤ò¿ï»þ¡¢ÅŻҥ᡼¥ë¤Ë¤Æ¤ªÃΤ餻¤·¤Þ¤¹¡£
¥Ê¥ì¥Ã¥¸¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹
¤´·ÀÌó¤Î¥½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¡¢¤è¤¯¤¢¤ë¤´¼ÁÌä¤ä¡¢²áµî¤Î²óÅú»öÎã¤Ê¤É¤ò±ÜÍ÷¤¤¤¿¤À¤±¤ë¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
¥µ¥Ý¡¼¥È¤ªÌ䤤¹ç¤ï¤»ÍѤÎWeb¥·¥¹¥Æ¥à¤«¤é»²¾È¤¤¤¿¤À¤±¤Þ¤¹¡£
¡¡¡¡¡¡
¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¥½¥Õ¥È¥¦¥§¥¢¤ÎÄó¶¡
¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¥½¥Õ¥È¥¦¥§¥¢¤ò̵½þ¤Ç¤´Ä󶡤¤¤¿¤·¤Þ¤¹¡£
¥µ¡¼¥Ó¥¹¥á¥Ë¥å¡¼
3 ¼ïÎà¤Î¥á¥Ë¥å¡¼¤È¡¢¤½¤ì¤¾¤ì¤Ë¥Ó¥¸¥Í¥¹¥¿¥¤¥à¥µ¥Ý¡¼¥È¤È24 »þ´Ö 365 Æü¡Ê°Ê¹ß 24¡ß365¡Ë¥µ¥Ý¡¼¥È¤¬ÍѰդµ¤ì¤Æ¤¤¤Þ¤¹¡£
¡Ê¥Ó¥¸¥Í¥¹¥¿¥¤¥à¥µ¥Ý¡¼¥È¤È 24¡ß365¥µ¥Ý¡¼¥È¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤´°ÆÆâ PDF ¤Î
¡Ö3.¼õÉÕÊýË¡¤ÈÂбþ»þ´Ö¡×¤ò¤´»²¾È¤¯¤À¤µ¤¤¡£¡Ë
¤³¤Î¤Û¤«¡¢µì¥Ð¡¼¥¸¥ç¥ó¥µ¥Ý¡¼¥È¡¢µºÜ°Ê³°¤Î¥×¥é¥Ã¥È¥Õ¥©¡¼¥àÂбþ¡¢¥Î¡¼¥ÉÄɲäʤɤò¥ª¥×¥·¥ç¥ó¤Ç¾µ¤ê¤Þ¤¹¡£ ¾Ü¤·¤¯¤Ï¤´ÁêÃ̤¯¤À¤µ¤¤¡£
| ¥µ¡¼¥Ó¥¹¥á¥Ë¥å¡¼ | ¥×¥é¥Á¥Ê | ¥´¡¼¥ë¥É | ¥·¥ë¥Ð¡¼ |
|---|---|---|---|
| Âбþ¥Ç¡¼¥¿¥Ù¡¼¥¹ ¥½¥Õ¥È¥¦¥§¥¢ |
PostgreSQL PowerGres on Windows PowerGres on Linux |
||
| Âбþ¥¯¥é¥¹¥¿ ¥½¥Õ¥È¥¦¥§¥¢ |
pgpool-II,Slony-I,pgpool-HA, Corosync/Heartbeat,DRBD |
- | |
| Âбþ¥×¥é¥Ã¥È¥Õ¥©¡¼¥à |
¡Ú Linux¡§ x86 / x86_64 ¡Û
Red Hat Enterprise Linux (V4.0 °Ê¹ß) CentOS (V4.0 °Ê¹ß)¡¢Debian (V4.0 °Ê¹ß)
¡Ú Linux¡§ IBM POWER Systems ¡Û
Red Hat Enterprise Linux 6 for IBM POWER Systems
¡Ú Windows¡§ ÆüËܸìÈÇ¥Õ¥¡¥¤¥ë¥·¥¹¥Æ¥à NTFS ¡Û
Windows XP¡¢Windows Server 2003¡¢Windows Server 2008¡¢Windows 7
¡Ú Solaris¡§ SPARC/x86 ¡Û
Solaris 9, 10
¡Ú HP-UX¡§Itanium ¡Û
HP-UX 11i v3 |
||
| DB ¥µ¡¼¥Ð¥Î¡¼¥É¿ô ¢¨ 1 | 20 | 4 | 1 |
| ¼ÁÌäôÅö¼Ô¿ô | 20̾ | 4̾ | 1̾ |
| ¼ÁÌä·ï¿ô | ̵À©¸Â | ||
| ·ÀÌó´ü´Ö | 1 ǯ´Ö | ||
| ɸ½à¥á¥Ë¥å¡¼ Àǹþ²Á³Ê¢¨2 | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 2,100,000±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 840,000±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 420,000±ß |
| 24¡ß365 4,200,000±ß | 24¡ß365 1,680,000±ß | 24¡ß365 840,000±ß | |
| pgpool-HA ¥ª¥×¥·¥ç¥ó ²Á³Ê ¢¨3 | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 787,500 ±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 315,000 ±ß | - |
| 24¡ß365 1,575,000±ß | 24¡ß365 630,000±ß | - | |
| Pacemaker / Heartbeat + DRBD ¥ª¥×¥·¥ç¥ó ²Á³Ê ¢¨4 | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 1,050,000 ±ß | ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 420,000 ±ß | - |
| 24¡ß365 2,100,000±ß | 24¡ß365 840,000±ß | - | |
- ¢¨ 1
- ¥Î¡¼¥É¤È¤ÏÆÈΩ¤·¤ÆÆ°ºî¤¹¤ë¥³¥ó¥Ô¥å¡¼¥¿¤ò»Ø¤·¤Þ¤¹¡£ÊªÍýCPU¤ä¥½¥±¥Ã¥È¤Ç¤Î²Ý¶â¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¥¯¥é¥¹¥¿¥·¥¹¥Æ¥à¤Î¾ì¹ç¤Ë¤Ï¥¯¥é¥¹¥¿¤ò¹½À®¤¹¤ë³Æ¥³¥ó¥Ô¥å¡¼¥¿¤ÏÊ̤ΥΡ¼¥É¤È¤·¤Æ¼è¤ê°·¤ï¤ì¤Þ¤¹¡£ - ¢¨ 2
- ɸ½à²Á³Ê¤ÎµºÜ¤Ç¤¹¡£ ¤½¤Î¾¡¢µìPostgreSQL¤Î¥Ð¡¼¥¸¥ç¥ó¥µ¥Ý¡¼¥ÈÅù¤Ë¤è¤ê¡¢¥ª¥×¥·¥ç¥ó¶â³Û¤ÎÀßÄ꤬¤´¤¶¤¤¤Þ¤¹¡£¾Ü¤·¤¯¤Ï¤ªÌä¹ç¤»¤¯¤À¤µ¤¤¡£
- ¢¨ 3
- Pacemaker/Heartbeat¤Ë¤è¤ë¹â²ÄÍÑÀ¥¯¥é¥¹¥¿¤Ç pgpool-HA ¥ê¥«¥Ð¥ê¥¨¡¼¥¸¥§¥ó¥È¤ò»È¤¤ pgpool-II ¤òÊݸ¤ë¹½À®¤Ç¤¹¡£
- ¢¨ 4
- Pacemaker/Heartbeat ¤Ë¤è¤ë¹â²ÄÍÑÀ¥¯¥é¥¹¥¿¤Ç DRBD ¤Ë¤è¤ë¥ì¥×¥ê¥±¡¼¥·¥ç¥ó¤Ç PostgreSQL ¤òÊݸ¤ë¹½À®¤Ç¤¹¡£
IBM Power Systems ¤Ø¤ÎÂбþ¤Ë¤Ä¤¤¤Æ
IBM Power Systems
¤Ø¤ÎÂбþ¤Ë¤Ä¤¤¤Æ¡¢¤è¤ê´Ê°×¤Ë¤´ÍøÍѤ¤¤¿¤À¤¯¤¿¤á¤Ë¡¢
ËÜ¥µ¥Ý¡¼¥È¤ÎÂоݥ½¥Õ¥È¥¦¥§¥¢¤Î RPM ¥Ñ¥Ã¥±¡¼¥¸¤òÄ󶡤·¤Æ¤ª¤ê¤Þ¤¹¡£
Red Hat Enterprise Linux 6 for IBM POWER ÍÑ PostgreSQL ´ØÏ¢¥½¥Õ¥È¥¦¥§¥¢ RPM ¥Ñ¥Ã¥±¡¼¥¸¥À¥¦¥ó¥í¡¼¥É
¤½¤Î¾¤Î¥ß¥É¥ë¥¦¥§¥¢¡¦Äɲå⥸¥å¡¼¥ë¤È¤ÎÁȤ߹ç¤ï¤»
PostgreSQL ¤ÈÁȤ߹ç¤ï¤»¤ÆÍøÍѤ¹¤ë¤½¤Î¾¥ß¥É¥ë¥¦¥§¥¢¤äÄɲå⥸¥å¡¼¥ë¤ò»È¤¦¾ì¹ç¤Ë
¤½¤ì¤é¤ËÂФ¹¤ë¥µ¥Ý¡¼¥È¤â¤´Ä󶡤¤¤¿¤·¤Þ¤¹¡£
¸ÄÊ̤ˤªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£
¥µ¥Ý¡¼¥È¾ÜºÙ
¾Ü¤·¤¤¥µ¥Ý¡¼¥ÈÆâÍÆ¤Ï¡ÖPostgreSQL/PowerGres ¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹¤Î¤´°ÆÆâ (
PDF ·Á¼°/256 KB)¡×¤ò¤´Í÷¤¯¤À¤µ¤¤¡£
¾åµ°Ê³°¤Ë¡¢¥½¥Õ¥È¥¦¥§¥¢¥Ù¥ó¥À¡¼Íͤ䥢¥×¥ê¥±¡¼¥·¥ç¥ó¥µ¡¼¥Ó¥¹¥×¥í¥Ð¥¤¥À¡¼Í͸þ¤±¤Î¡Ö¥Ù¥ó¥À¡¼¥¢¥é¥¤¥¢¥ó¥¹¥×¥í¥°¥é¥à¡×¤â¤´ÍѰդ·¤Æ¤ª¤ê¤Þ¤¹¡£
¾ÜºÙ¤Ï
¤Þ¤Ç¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£
¤ª¿½¤·¹þ¤ß
Web ¥Ú¡¼¥¸¤«¤é¤ª¿½¤·¹þ¤ß¤ò¼õ¤±ÉÕ¤±¤Æ¤ª¤ê¤Þ¤¹¡£
¤ª¸«ÀѤâ¤ê¤¬É¬Íפʾì¹ç¤Ï
¤Þ¤Ç¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£
µì¥Ð¡¼¥¸¥ç¥ó¤Î¥µ¥Ý¡¼¥È¤ä¥µ¥Ý¡¼¥ÈÂоݳ°¤Î¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Ë¤Ä¤¤¤Æ¤â¤´ÁêÃ̤¯¤À¤µ¤¤¡£







