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
PGConf.ASIA 2018 2018/12/10ï¼æï¼ï½ 12ï¼æ°´ï¼ ï¼ ç§èåã³ã³ãã³ã·ã§ã³ãã¼ã« ã¢ã¸ã¢åæ大ç´ã® PostgreSQL ã¤ãã³ã è¿å¹´ãã¾ãã¾ãä¸çä¸ã§ PostgreSQL ãçãä¸ãããè¦ãã¦ããã å½å ã¦ã¼ã¶åãã®ãã¼ã«ã«ãªã¤ãã³ãã®ã¿ãªããã å½å å¤åããéçºè ã»ã¦ã¼ã¶ãéã¾ãå½éã«ã³ãã¡ã¬ã³ã¹ãå¢ãã¦ãã¾ãã ä¸æ¨å¹´ãPostgreSQL ã® 20 å¨å¹´ãè¨å¿µãã¦ãä¸çã®éçºè ã¨ã¢ã¸ã¢åã®æè¡è ã®äº¤æµã®æ©ä¼ ãè¨ãããã¨ãã¢ã¸ã¢ã®ä¸ã§ãå©ç¨ãçããªå½ã®ä¸ã¤ã§ããæ¥æ¬ããã¹ãã¨ã㦠ãPGConf.ASIAããå§ã¾ãã¾ããã æ¨å¹´ã®ã¤ãã³ãã«ã¯ãæµ·å¤ã®æè¡è 55 åãå«ã延㹠900 å以ä¸ã®æ¹ã«åå é ãã å ¨ä¸çã«å¯¾ãã¦ã¢ã¸ã¢åã§ã®çãä¸ããã大ããã¢ãã¼ã«ã§ãã¾ããã ãã®ç«ã絶ãããªãæ§ãæ¬å¹´ã PGConf.ASIA 2018 ã¨ã㦠åæ§ã®ã¤ã
NTTãã¼ã¿ã¨PostgreSQLãæãã ç·åæ¦ãPostgreSQLã極éã¾ã§ä½¿ãåã£ããã®å ã«è¦ããã®ã¨ã¯ï¼ï¼åç·¨ï¼ NTTãã¼ã¿ãªã¼ãã³ã½ã¼ã¹DAY2015 ç¾å¨ã®ã·ã¹ãã æ§ç¯ã§ã¯ããªã¼ãã³ã½ã¼ã¹ã®ã½ããã¦ã§ã¢ã使ããã¨ã¯å½ããåã«ãªã£ã¦ãã¦ãã¾ããPostgreSQLã¯ããããä¸ã§ä¸»ã«ã¨ã³ã¿ã¼ãã©ã¤ãºåãã®ãã¼ã¿ãã¼ã¹ã¨ãã¦çå®ã«äºä¾ãå¢ããã¦ãã¦ãã¾ãã ãã®ä¸ã§ãPostgreSQLã大è¦æ¨¡ãªããã·ã§ã³ã¯ãªãã£ã«ã«ãªã·ã¹ãã ã®ä¸ã§ä½¿ãã«ã¯ãã©ã®ãããªãã¦ãã¦ãæ±ããããã®ãããªã¼ãã³ã½ã¼ã¹ã®å©ç¨ã«ç©æ¥µçãªNTTãã¼ã¿ããã®äºä¾ãã1æ26æ¥ã«éå¬ãããã¤ãã³ããNTTãã¼ã¿ãªã¼ãã³ã½ã¼ã¹DAY 2015ãã®ã»ãã·ã§ã³ãNTTãã¼ã¿ã¨PostgreSQLãæãã ç·åæ¦ãPostgreSQLã極éã¾ã§ä½¿ãåã£ããã®å ã«è¦ããã®ã¨ã¯ï¼ãã§ç´¹ä»ãã¦ãã¾ããè¬æ¼å 容ããã¤ã¸ã§ã¹ãã«ãã¾ã
EnterpriseZineï¼ã¨ã³ã¿ã¼ãã©ã¤ãºã¸ã³ï¼ç·¨éé¨ã§ã¯ãæ å ±ã·ã¹ãã æ å½ãã»ãã¥ãªãã£æ å½ã®æ¹ã åãã«ãEnterpriseZine DayãSecurity Online DayãDataTechã¨ããã3ã¤ã®ã¤ãã³ããéå¬ãã¦ããã¾ããããããç·¨éé¨ç¬èªã®åãå£ã§ãæ¥çãã¬ã³ããææ°äºä¾ãç¶²ç¾ ãææ°ã®ååãç¥ããã¨ãã§ããå ´ã¨ãã¦ã好è©ãå¾ã¦ãã¾ãã
stop using numbers as IDs. just use UUIDs. seriously â Postgres: The Bits You Havenât Found by pvh UUID ã®éã v1 Generate a UUID from a host ID, sequence number, and the current time. v3 Generate a UUID from the MD5 hash of a namespace UUID and a name. v4 Generate a random UUID v5 Generate a UUID from the SHA-1 hash of a namespace UUID and a name. ãã®å ãID ã¨ãã¦å©ç¨ã§ããã®ã¯ v1 㨠v4 ã®2ã¤ãv1 ã¯æå¾ 48 ãããããã¼ãåºæã®ãã¼
ãã®ã¨ã³ããªã¯PostgreSQL Advent Calendar2013ã®ãã®ã¨ã³ããªã¯PostgreSQL Advent Calendar2013ã®19æ¥ç®ã«ãªãã¾ããä»åã¯ä¾¿å©ãã¼ã«ã¨ãã¦ãä»å¹´ä½ã£ãpgsqlenvã®è§£èª¬ãæ¸ãã¦ã¿ã¾ããã ãã®ãã¼ã«ã¯ãããããPostgreSQLã«ç¹åããhomebrewç°å¢ãæ§ç¯ãããã®ã§ãã³ãã³ãã§ã¤ã³ã¹ãã¼ã«ãåæåãèµ·åãçµäºãã®ã»ãã®ä½æ¥ãè¡ãã¾ããgithubã§å ¬éãã¦ãã¾ãã ã¤ã³ã¹ãã¼ã« ã¤ã³ã¹ãã¼ã«ã¯ç°¡åã§ãgitããåå¾ããåå¾ãããã¨ã§ããã«ãã¹ãéãã ãã§ãã以ä¸ã®ä¾ã§ã¯ã~/git/以ä¸ã«å±éããããã«ãã¦ãã¾ãã $ cd ~/git/ $ git clone http://github.com/yutakat/pgsqlenv/ $ export PATH=$PATH:~/git/pgsqlenv 使ãæ¹ pgs
postgresã«éããRDBMSã§ãã¼ãã«è¨è¨ãããä¸ã§é©åãªåãé¸ã¶ãã¨ã¯éè¦ã§ãã postgresã¯ã¦ã¼ã¶å®ç¾©ã®åãä½æã§ãããã¨ã¯ãåç¥ãã¨æãã¾ãããCè¨èªã§è¨è¿°ããå¿ è¦ãããããæ°è»½ã«æ¬²ããåãå®ç¾©ãã¨ã¯ä¸ã ããã¾ãããã§ãããpostgresã«ã¯æ¢åã®åãæ¡å¼µãããããªåãããã¤ãç¨æããã¦ãã¾ãããããã®åã使ããã¨ã§æè»ãªãã¼ã¿ã®è¡¨ç¾ãè¡ããã¨ãã§ããããã«ãªãã¾ããæ¬è¨äºã§ã¯ãã®ä¸ãã3種é¡ç´¹ä»ãã¾ãã®ã§ãæ¯éå©ç¨ãã¦ã¿ã¦ãã ããã 1. é å postgresã§ã¯ ä»»æã®å ã®é ååãç¨ãããã¨ãã§ãã¾ãã åã®å®ç¾© é åã«ãããåã®å¾ã«[]ãå ãã¾ã
31.15. ãã¹ã¯ã¼ããã¡ã¤ã«ã¦ã¼ã¶ã®ãã¼ã ãã£ã¬ã¯ããªã®.pgpassã¾ãã¯PGPASSFILEã§è¨å®ããããã¡ã¤ã«ã¯ãæ¥ç¶ã«ãã¹ã¯ã¼ããå¿ è¦ãªå ´å(ãã¤ãä»ã«æå®ããããã¹ã¯ã¼ããç¡ãã£ãå ´å)ã«ä½¿ç¨ãããã¹ã¯ã¼ããæ ¼ç´ãããã¡ã¤ã«ã§ãã Microsoft Windowsã§ã¯ããã®ãã¡ã¤ã«ã®ååã¯%APPDATA%\postgresql\pgpass.conf(ããã§%APPDATA%ã¯ã¦ã¼ã¶ã®ãããã¡ã¤ã«å ã®ã¢ããªã±ã¼ã·ã§ã³ãã¼ã¿ãã£ã¬ã¯ããª)ã§ãã ãã®ãã¡ã¤ã«å ã®è¡ã®æ¸å¼ã¯æ¬¡ã®éãã§ãã hostname:port:database:username:password ï¼ãã®ãã¡ã¤ã«ã§ã¯ãä¸ã®ãããªè¡ãã³ãã¼ãããã®å é ã«#ãã¤ãã¦å¿ããªãããã«ã³ã¡ã³ãã¨ãã¦æ®ããã¨ãã§ãã¾ããï¼ å é ã®4ãã£ã¼ã«ãã¯ãããããªãã©ã«å¤ã«ãããã¨ãããããã¯ãã¹ã¦ã«ä¸è´ãã*ã使ç¨ãããã¨ã
ã注æã pg_monzã¯Zabbix 5.0ã«ã¯å¯¾å¿ãããZabbix 4.0ã®ãã«ãµãã¼ãçµäº2021å¹´10æ31æ¥ããã£ã¦ã¡ã³ããã³ã¹ãçµäºãã¾ããã PostgreSQLç£è¦ã¯Zabbix 5.0以éã§ã¯æ¨æºãã³ãã¬ã¼ãã®å©ç¨ãæ¨å¥¨ãã¾ãã pg_monz ã¨ã¯ PostgreSQL monitoring template for Zabbix (pg_monz) ã¯ãZabbixã§PostgreSQLã®å種ç£è¦ãè¡ãããã®ãã³ãã¬ã¼ãã§ãã pg_monzã®ç®ç pg_monzãå°å ¥ãããã¨ã§ãPostgreSQLã®æ»æ´»ç£è¦ããªã½ã¼ã¹ç£è¦ãæ§è½ç£è¦ãªã©ãè¡ãã¾ãã PostgreSQLåä½ã§ç¨¼åããã·ã³ã°ã«æ§æã®ç¶æ ãPostgreSQLã®Streaming Replicationã使ã£ãåé·æ§æã®ç¶æ ãpgpool-IIã使ã£ãè² è·åæ£æ§æã®ç¶æ ã®ç£è¦ãè¡ããã¨ãã§ããPost
PostgreSQL Advent Calendar 2012ï¼å ¨é¨ä¿ºï¼ã®Day 11ã§ãã æè¿ãã¡ãã£ã¨ããå¯è¦åãã¼ã ã訪ãã¦ããã¾ãï¼å人çã«ï¼ã éç¨ç®¡çãå¯è¦åãããã¼ã«ããã©ã°ã¤ã³ãããããã¨å ¬éããã¦ããæ¨ä»ã§ãããå人çã«ã¯ã¡ãã£ã¨åãããGrowthForecastãã¨ãããã¼ã«ãæ°ã«ãªã£ã¦ãã¾ããã®ã§ãä»åã¯ããã使ã£ã¦PostgreSQLãå¯è¦åãã¦ã¿ããã¨æãã¾ãã â ãGrowthForecastãã¨ã¯ä½ã ãGrowthForecastã㯠@kazeburoæ° ã®éçºããã°ã©ããã¼ã«ã§ããåç¬ã§Webãµã¼ãã¨ãã¦åä½ããWebAPIãçµç±ãã¦å¯è¦åãã¹ããã¼ã¿ã®ç»é²ãåãä»ããHTTPãªã¯ã¨ã¹ãã§ã°ã©ãåãããç»åãã¼ã¿ãåå¾ãããã¨ãã§ããã½ããã¦ã§ã¢ã§ãã GrowthForecast - Lightning fast Graphing / Visual
PostgreSQL Advent Calendar 2012ï¼å ¨é¨ä¿ºï¼ã®Day 15ã§ãã PostgreSQLã«éãããRDBMSã«ããã¦ãç¹å®ã®ãã¼ãã«ã®æ´æ°å·®åã ããåå¾ããããã¨ããã®ã¯ãDBAã®å¤¢ã§ããã¨è¨ãã¾ãï¼ããï¼ï¼ã ãã©ã³ã¶ã¯ã·ã§ã³ãã°ã®ä¸ã«ã¯å½ç¶ãªãããæ´æ°æ å ±ããè¨é²ããã¦ããããã§ããããããåå©ç¨å¯è½ãªå½¢ã§åãåºãæ¹æ³ãç¡ããæ¶ã§æãæ¿¡ãããæãåºãæã¤DBAãå¤ããã¨ã§ããããå¤åã ããå°ãåãããããç³ãã¾ãã¨ãPostgreSQLã®ã¡ã¸ã£ã¼ãã¼ã¸ã§ã³ã¢ããã®éãªã©ã«ã¯pg_dumpã«ããexport/importãå¿ è¦ã¨ãªãããã§ããããã¼ã¿éãå¤ããªã£ã¦æ¥ã¦ããä»ããã¼ã¿ã®exportã«ãæéããããã¾ããã24x365ã®ã·ã¹ãã ãå¢ãã¦ãã¾ãã®ã§ã移è¡ãã¦ããéã«ããã¼ã¿ã®æ´æ°ãçºçãã¦ãã¾ãã¾ãã ãªã®ã§ããããã£ãä½æ¥ã®åéã«çºçããæ´æ°æ å ±ï¼
https://mariadb.com/kb/en/optimizer-switch/ã«ããããã«ãMariaDBã®ãªããã£ãã¤ã¶ã¯ããªãæ¹è¯ããã¦ããã ã§ã¯ãMariaDBã®ãªããã£ãã¤ã¶/ã¨ã¯ã¼ãã¥ã¼ã¿ã¯ã©ã®ç¨åº¦åªç§ããï¼ã¤ã®SELECTæã®å®è¡ãéãã¦MySQLã¨(ã¤ãã§ã«PostgreSQLã¨)æ¯è¼ãã¦ã¿ãã (2014.12.3追è¨ï¼ãªããã£ãã¤ã¶ã«ã¤ãã¦ã¯çç¥ãã¦ã¾ããããããªæ¬ãã§ã¾ãã) çµè«ãå ã«ããã°ãMySQLã¯æ¤ç´¢ãéããã¨ããã®ã¯é½å¸ä¼èª¬ãMariaDBã¯ããã°ã£ã¦ããã©PostgreSQLã«ã¯ã¾ã ã¾ã åã°ãã ï¼å¿µã®ãããããã¯ãã³ããã¼ã¯ãããªããããªããã£ãã¤ã¶/ã¨ã¯ã¼ãã¥ã¼ã¿ã®æ©è½æ¯è¼ã§ãã èªåã§å確èªãããå ´åã¯ãã¡ãã«ã¹ã¯ãªãã群ã¨å®é¨ã®ããæ¹ãç°¡åã«æ¸ããã®ã§åç §ã®ãã¨ã 調æ»ç°å¢ åä¸ãã·ã³ã«MySQL5.6.14ãMariaDB10.0.4ã
è¬æ¼åé é常è¬æ¼ã®åéã¯çµäºãããã¾ããã沢山ã®ãå¿åãããã¨ããããã¾ãã ã©ã¤ããã³ã°ãã¼ã¯ã®ã¹ãã¼ã«ã¼ãåéãã¦ããã¾ãã 17:10 ï½ 17:40 ã®ã¯ãã¼ã¸ã³ã°ã»ãã·ã§ã³ã®ä¸ã§ã©ã¤ããã³ã°ãã¼ã¯ãå®æ½ãããã¾ãã æ°åãï¼åéã§ã®çºè¡¨å 容ã®ã¿ã¤ãã«ãæ¦ç¥ãè¨è¼ã㦠jpug-pgcon @ ml.postgresql.jp å®ã¦ã«ãã©ã¤ããã³ã°ãã¼ã¯å¿åãã¡ã¼ã«è¡¨é¡ã«ã¦ã10ææ«æ¥ã¾ã§ã«ãç³è¾¼ã¿ãã ããã çºè¡¨è ã«ããã¾ãã¦ã¯ãæ親ä¼ããæå¾ ï¼ç¡æï¼ã¨ããã¦ããã ãã¾ãããã ããå ¥å ´ãã±ããï¼ã¾ãã¯ã¹ãã³ãµã¼ã«ããæå¾ å ¥å ´ç»é²ï¼ã¯å¿ è¦ã¨ãªãã¾ããçæ§ã®ãæ°è»½ãªãç³è¾¼ã¿ããå¾ ã¡ãã¦ããã¾ãã åå åé å ¥å ´ãã±ããã 10æ1æ¥ãã ãã¼ã½ã³ãã±ããã«ã¦è²©å£²ãã¦ããã¾ãããã¼ã½ã³ã»ããã¹ããã ã® Loppi端æ«ã¾ãã¯ããã¼ãã±.com ãµã¤ãã«ã¦è³¼å ¥ã§ãã¾ãã çºå£²æéï¼Â
PowerDNS is a leading provider of secure open-source and commercial DNS software. PowerDNS solutions are focused on large-scale DNS service providers, including mobile and fixed-line broadband operators, and hosting and cloud service providers. PowerDNS also underpins scalable security solutions from market-leading vendors. Providers trust PowerDNS to deliver an excellent user experience and prote
2. èªå·±ç´¹ä» ⢠æ°å â æ°¸å® æå² ï¼ãªããã ãã¨ãï¼ â¢ ç¥æ´ â 2004/4-2007/9 ï¼3å¹´6ãµæï¼ â¢ æ ªå¼ä¼ç¤¾NTTãã¼ã¿å ¥ç¤¾ã ⢠PostgreSQLã«ãã並ååæ£RDBMSã®ç 究éçºã ⢠SIããã¸ã§ã¯ãã®æè¡æ¯æ´ã並ååæ£PostgreSQLããã«ã¦ã§ã¢ã®è£½åãµãã¼ãããã³ä¿å®ã â 2007/10-2008/9 ï¼1å¹´ï¼ â¢ ãã¼ã¿ã»ã³ã¿ä¼ç»é¨éã«ã¦ã次ä¸ä»£ITãã©ãããã©ã¼ã ãµã¼ãã¹ã®ä¼ç»ã»éçºã â 2008/10-2009/10 ï¼1å¹´1ãµæï¼ â¢ ãã¼ã¿ã»ã³ã¿éç¨é¨éã«ã¦ãOSSç³»ã·ã¹ãã ã®åºç¤ä¿å®ã»éç¨ãããã³éç¨ãã¼ã ã®çµ±æ¬ã â¢ æ ªå¼ä¼ç¤¾NTTãã¼ã¿éè·ã â 2009/11- ⢠ã¢ããã¿ã¤ã ã»ãã¯ããã¸ã¼ãºåµæ¥ï¼å ±ååµæ¥è å ¼CEOï¼ã ⢠å°éåé â ãã¼ã¿ãã¼ã¹ã·ã¹ãã ã並ååæ£ã·ã¹ãã ãã¯ã©ã¹ã¿ã·ã¹ãã â ãªã¼ãã³ã½ã¼ã¹ã»ã¤ã³ã
ã¡ã¤ã³ã³ã³ãã³ãã«ç§»å ãç¥ãã Letâs Postgres éå¶ç®¡çã«ã¤ãã¦ã®ãç¥ãã ã³ã³ãã³ãã¡ãã¥ã¼ å°å ¥æ¤è¨ ã¨ å ¥é ã¤ã³ã¹ãã¼ã« éç¨ç®¡ç ãã¥ã¼ãã³ã° æ°æ©è½: 16 / 15/ 14 / 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 ãã©ãã«ã·ã¥ã¼ã ãµãã¼ãã¨FAQ äºä¾ç´¹ä» ã¤ãã³ãã¬ãã¼ã ãªã³ã¯é ã¬ããªã±ã¼ã·ã§ã³ / ã¯ã©ã¹ã¿æ§æ XML / PostGIS / æ¡å¼µã¢ã¸ã¥ã¼ã« ãã¼ãã£ã·ã§ãã³ã° / ããã¹ãæ¤ç´¢ Windowé¢æ° / å帰SQL / å¤é¨ãã¼ã¿é£æº ææ¸:ã15 / 14 / 13 / 12 / 11 / 10 / 9.6 / 9.5 Let's PostgreSQL ã¯ç¹å®éå¶å©æ´»åæ³äººæ¥æ¬PostgreSQLã¦ã¼ã¶ä¼ãéå¶ãã¦ãã¾ãã RSS feed
2013å¹´9æ19æ¥ 21:25 æ稿è ï¼ikeda 試ãã¦ã¿ã¾ããã æ± ç°ã§ããä»åã¯ã¨ã³ã¸ãã¢ãªæ± ç°ã§ããããã¨æãã¾ãã PostgreSQLã¯åè·ã§ã©ã£ã·ãã¨æµ¸ãã£ããªã¼ãã³ã½ã¼ã¹ã®ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã§ããããã®ãã³ãã§ãã9.3ããªãªã¼ã¹ãæ´æ°ã§ãããã¥ã¼ã®ãããªã¢ã©ã¤ãºããã¥ã¼ããCSVãã¡ã¤ã«ãSQliteãªã©ã®å¤é¨èç©ãã¼ã¿ãééçã«åãè¾¼ãã§ã¬ã³ã¼ãã¨ãã¦æ±ããã©ããã¼æ©è½ãªã©é¢ç½ãããªå®è£ ãç®ç½æ¼ããªã®ã§ãããã®ä¸ã§ãç§ãæã注ç®ããã®ã¯1ç§ä»¥å ã¨å®£ä¼ããã¦ããé«éãã§ã¤ã«ãªã¼ãã¼ã§ãã 9.0ããå®è£ ããããã¤ãã£ããªã¹ããªã¼ãã³ã°ã¬ããªã±ã¼ã·ã§ã³æ©è½ã¯ç´ æ´ãããã®ã§ãããå®éã«é害ãçºçããã¨ãã«ãçµå±ãã¹ã¿ã¼ãããã¼ã¿ããã©ã¼ãªã³ã°ãç´ãããã¼ãã¨ãªã£ã¦ãã¾ããã¨ãã¾ã¾ãã£ãããã§ãã ã¨ã«ãããã£ã¦ã¿ããã¨ãããã¨ã§ãæå ã®VMwareã«ä½¿ãæ £ãã¦ããC
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}