PostgreSQL 9 Administration Cookbook中文版（第2版）

目錄第1章　邁出第一步...................................................................................................................11.1　介紹 ..................................................................................................................................11.2　獲取PostgreSQL ..............................................................................................................71.3　連接到PostgreSQL服務 ..................................................................................................81.4　啟用網(wǎng)絡/遠程用戶訪問 ............................................................................................... 111.5　使用圖形化管理工具 ....................................................................................................121.6　使用 psql 查詢和腳本工具 ...........................................................................................161.7　安全地修改你的密碼 ....................................................................................................191.8　避免硬編碼你的密碼 ....................................................................................................201.9　使用連接服務文件 ........................................................................................................221.10　連接失敗故障排除 ......................................................................................................23第2章　瀏覽數(shù)據(jù)庫.................................................................................................................252.1　介紹 ................................................................................................................................252.2　當前服務程序的版本號是多少 ....................................................................................262.3　服務程序運行時間是多少？ ........................................................................................272.4　定位數(shù)據(jù)庫服務的數(shù)據(jù)文件 ........................................................................................282.5　定位數(shù)據(jù)庫服務的日志文件 ........................................................................................312.6　定位數(shù)據(jù)庫的系統(tǒng)標識 ................................................................................................332.7　列出數(shù)據(jù)庫服務中的數(shù)據(jù)庫 ........................................................................................352.8　數(shù)據(jù)庫中有多少張表 ....................................................................................................382.9　一個數(shù)據(jù)庫占用了多少磁盤空間 ................................................................................40PostgreSQL 9 Administration Cookbook（第2版）中文版XX2.10　一張表占用了多少磁盤空間 ......................................................................................412.11　哪張表是最大的表 ......................................................................................................422.12　表里有多少行記錄 ......................................................................................................432.13　快速估算表里的記錄總數(shù) ..........................................................................................442.14　列出數(shù)據(jù)庫中的擴展模塊 ..........................................................................................482.15　理解對象的依賴關系 ..................................................................................................49第3章　配置............................................................................................................................ 523.1　介紹 ................................................................................................................................523.2　閱讀手冊（RTFM） .....................................................................................................533.3　規(guī)劃一個新數(shù)據(jù)庫 ........................................................................................................543.4　在程序中更改參數(shù) ........................................................................................................553.5　查看當前的配置參數(shù) ....................................................................................................573.6　哪些參數(shù)為非默認設置 ................................................................................................583.7　更新參數(shù)文件 ................................................................................................................603.8　為特定用戶組設置參數(shù) ................................................................................................623.9　基本服務配置清單 ........................................................................................................633.10　添加一個外部模塊到PostgreSQL服務中 ..................................................................643.11　使用已安裝的模塊 ......................................................................................................683.12　管理已安裝的擴展 ......................................................................................................70第4章　服務控制.....................................................................................................................744.1　介紹 ................................................................................................................................744.2　手動啟動數(shù)據(jù)庫服務 ....................................................................................................754.3　安全快速地停止服務 ....................................................................................................774.4　在緊急情況下關閉服務 ................................................................................................774.5　重新加載服務配置文件 ................................................................................................784.6　快速重啟服務 ................................................................................................................804.7　阻止新的連接 ................................................................................................................814.8　限制每個用戶只允許一個會話 ....................................................................................834.9　斷開用戶連接 ................................................................................................................844.10　為多租戶進行數(shù)據(jù)庫設計 ..........................................................................................864.11　使用多個模式（schema） ..........................................................................................874.12　單獨給用戶分配數(shù)據(jù)庫 ..............................................................................................89目錄XXI4.13　在一個系統(tǒng)上運行多個服務 ......................................................................................904.14　配置連接池 ..................................................................................................................924.15　在相同的主機和端口上訪問多個服務 ......................................................................95第5章　表和數(shù)據(jù).....................................................................................................................985.1　介紹 ................................................................................................................................985.2　為數(shù)據(jù)庫對象選擇恰當?shù)拿Q ....................................................................................995.3　處理使用雙引號括起來的對象名 ..............................................................................1005.4　確保相同的名稱和相同的列定義 ............................................................................