Goodbye MongoDB, Hello PostgreSQL
Olery was founded almost 5 years ago. What started out as a single product (Olery Reputation) developed by a Ruby development agency grew into a set of different products and many different applications as the years passed. Today we have not only Reputation as a product but also Olery Feedback, the Hotel Review Data API, widgets that can be embedded on a website and more products/services in the n
PostgreSQLã®ãƒªã‚«ãƒãƒªè¶…入門(ã‚‚ã—ãã¯WALã€CHECKPOINTã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿)
PostgreSQLã®ãƒªã‚«ãƒãƒªè¶…入門(ã‚‚ã—ãã¯WALã€CHECKPOINTã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿) 29回勉強会資料「PostgreSQLã®ãƒªã‚«ãƒãƒªè¶…入門〠See also http://www.interdb.jp/pgsql (Coming soon!) åˆå¿ƒè€…å‘ã‘。PostgreSQLã®WALã€CHECKPOINT〠オンラインãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿è§£èª¬ã€‚ ã“れを見ãŸã‚‰ã€æ¬¡ã¯â†’　 http://www.slideshare.net/satock/29shikumi-backup
PostgreSQLåˆæœŸè¨å®šã“ã‚Œã ã‘ã¯å¤‰ãˆã¦ãŠã“ã†
PostgreSQL Advent Calendar 2012（全部俺）ã®Day 1ã§ã™ã€‚ åˆæ—¥ã¯ã€ã¾ãšPostgreSQLを使ã„始ã‚ã‚‹éš›ã®åŸºæœ¬çš„ãªãŠä½œæ³•ã§ã‚ã‚‹åˆæœŸè¨å®šã«ã¤ã„ã¦ç°¡å˜ã«ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ PostgreSQLã¯ã€ãƒ‘ラメータã®è¨å®šã‚’変更ã›ãšã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã®ã¾ã¾ä½¿ã„始ã‚ã¦ã‚‚ã€ã‚‚ã¡ã‚ã‚“å‹•ãã“ã¨ã¯å‹•ãã®ã§ã™ãŒã€å¾Œã‹ã‚‰ã„ã‚ã„ã‚ã¨å•é¡ŒãŒå‡ºã¦ãã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã—ã€ç‰¹ã«æ€§èƒ½é–¢é€£ã®ãƒ‘ラメータã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã¯ã‚ã¾ã‚Šã«å°ã•ãã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°äº‘々以å‰ã®å•é¡Œã ã£ãŸã‚Šã—ã¾ã™ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ç§ãŒæ™®æ®µPostgreSQLをインストールã—ã¦ä½¿ã„始ã‚る時ã€é–‹ç™ºæ©Ÿã§ã‚ã£ã¦ã‚‚ã„ãã¤ã‹ãƒ‘ラメータをåˆæœŸè¨å®šã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ 使ã„始ã‚ã‚‹å‰ã«è¨å®šã‹ã‚‰å…¥ã‚‹ã®ã¯ç¢ºã‹ã«é¢å€’ãªã®ã§ã™ãŒã€æœ€åˆã«è¨å®šãŒå¿…è¦ãªãƒ‘ラメータã¯å°‘数（今回紹介ã™ã‚‹ã®ã¯5ã¤ï¼‰ã§ã™ã®ã§ã€ã¾ãšã¯æœ€åˆã«å¿…è¦æœ€ä½Žé™ã®è¨å®šã‚’ã—ã¦ã‹ã‚‰ä½¿ã„始ã‚ã¾ã—ょã†ã€ã¨ã„ã†ã®ãŒæœ¬ã‚¨
psqlコマンドã®ãŠå‹§ã‚è¨å®š - é’木ブãƒã‚°
実ã¯psqlコマンドã¯è‰²ä»˜ãプãƒãƒ³ãƒ—トを始ã‚ã¨ã—ã¦æ„外ã¨ä¾¿åˆ©ãªè¨å®šãŒã§ãるよã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ã‚ãŸã—ãŒä½¿ã£ã¦ã„ã‚‹ãŠã™ã™ã‚ã® ~/.psqlrc を書ã„ã¦ãŠãã¾ã™ã€‚ \set PROMPT1 '%[%033[1;32m%]%n %`date +%H:%M` %R%#%[%033[0m%] ' \set PROMPT2 '%[%033[1;32m%]%R%#%[%033[0m%] ' \timing on \set HISTSIZE 1000000 以下解説 PROMPT1, PROMPT2 ãŠç´„æŸã®è‰²ä»˜ãプãƒãƒ³ãƒ—ト。 上記è¨å®šã¯ç·‘ã®ãƒœãƒ¼ãƒ«ãƒ‰ã«ã—ã¦ã„ã¦ã€è‰²ã‚’抜ã‹ã™ã¨ã“ã†â†“ãªã‚Šã¾ã™ã€‚ '%n %`date +%H:%M` %R%# ' 表示ã™ã‚‹ã¨ã€Œaamine 18:05 =>ã€ã¿ãŸã„ãªæ„Ÿã˜ã§ã™ã€‚以下解説。 %[...%] : エスケープãŒæœ‰åŠ¹ %033 : ESCæ–‡å— %n : ユーザーå %
psqlコマンドã®ã‚ªãƒ—ションã¨ãƒ‘スワード入力をçœç•¥ã™ã‚‹ - é’木ブãƒã‚°
psqlコマンドã®è¨å®šã‚·ãƒªãƒ¼ã‚ºç¬¬äºŒå¼¾ã€‚ ホストåã¨ã‹ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚’è¨å®šã™ã‚‹ psqlã§DBã«æŽ¥ç¶šã™ã‚‹ã¨ãã¯ã“ã‚“ãªã‚³ãƒžãƒ³ãƒ‰ã§æŽ¥ç¶šã—ã¾ã™ãŒâ€¦â€¦ psql -h xxxx.ap-northeast-1.redshift.amazonaws.com -p 5439 -U myuser dev ã“れオプション多ãã¦é¢å€’ã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ ãã“ã§ä»¥ä¸‹ã®ã‚ˆã†ã«ç’°å¢ƒå¤‰æ•°ã‚’è¨å®šã—ã¦ãŠã‘ã°ã‚ªãƒ—ションã¯å…¨éƒ¨çœç•¥ã§ãã¾ã™ã€‚ export PGHOST=xxxx.ap-northeast-1.redshift.amazonaws.com export PGPORT=5439 export PGDATABASE=dev export PGUSER=myuser ユーザーåã ã‘変ãˆãŸã„ã¿ãŸã„ãªã¨ãã¯ã€ 変ãˆãŸã„ã‚‚ã®ã ã‘明示的ã«ã‚ªãƒ—ションを指定ã™ã‚Œã°ã‚ˆã„ã§ã™ã€‚ パスワード入力をçœç•¥ã™ã‚‹ 最後ã«æ®‹ã‚‹ã®ãŒãƒ‘スワード入力ã§ã™ãŒã€
MySQLユーザーã®ãŸã‚ã®PostgreSQL対応表 - ã‹ã¿ã½ã‚ーる
毎回ã‚ã‹ã‚‰ãªããªã£ã¦ã‚°ã‚°ã£ã¦ã‚‹ã‹ã‚‰ä»Šåº¦ã‹ã‚‰ã“ã“ã«è¿½è¨˜ã—ã¦ã„ã。 MySQL PostgreSQL SHOW DATABASES; \l USE dbname \c dbname SHOW TABLES; \dt SELECT * FROM tblname\G \x on SELECT * FROM tblname; SELECT * FROM information_schema.processlist; SELECT * FROM pg_stat_activity; KILL <pid>; SELECT pg_terminate_backend(pid); KILL QUERY <pid>; SELECT pg_cancel_backend(pid); table / column ã®æƒ…å ± MySQL PostgreSQL SHOW TABLE STATUS FROM dbname; ã‚
Amazon RDS for PostgreSQL – Now Available | Amazon Web Services
AWS News Blog Amazon RDS for PostgreSQL – Now Available The Amazon Relational Database Service (RDS among friends) launched in 2009 with support for MySQL. We added Oracle Database in 2011 and Windows SQL Server in 2012. Today we are adding support for PostgreSQL. After personally fielding hundreds requests for this database engine over the last couple of years, I am more than happy to be making t
1
ランã‚ング
ランã‚ング
ãŠçŸ¥ã‚‰ã›
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
NTT DATA 㨠PostgreSQL ãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦
PG-Strom
データベース技術ã®ç¾…é‡ç›¤
https://postgres.heroku.com/
Heroku | Login
{{#tags}}- {{label}}
{{/tags}}