我的书签
添加书签
移除书签18. 服務配置與維運
本章討論如何設定和運行資料庫伺服器及其與作業系統的互動。
18. 服務配置與維運
- 簡介
- 前言
- I. 新手教學
- II. SQL 查詢語言
- 4. SQL 語法
- 5. 定義資料結構
- 6. 資料處理
- 7. 資料查詢
- 8. 資料型別
- 9. 函式及運算子
- 9.1. 邏輯運算子
- 9.2. 比較函式及運算子
- 9.3. 數學函式及運算子
- 9.4. 字串函式及運算子
- 9.5. 位元字串函式及運算子
- 9.6. 二元字串函式及運算子
- 9.7. 特徵比對
- 9.8. 型別轉換函式
- 9.9 日期時間函式及運算子
- 9.10. 列舉型別函式
- 9.11. 地理資訊函式及運算子
- 9.12. 網路位址函式及運算子
- 9.13. 文字檢索函式及運算子
- 9.14. XML 函式
- 9.15. JSON 函式及運算子
- 9.16. 序列函式
- 9.17. 條件表示式
- 9.18. 陣列函式及運算子
- 9.19. 範圍函式及運算子
- 9.20. 彙總函數
- 9.21. Window 函式
- 9.22. 子查詢
- 9.23. 資料列與陣列的比較運算
- 9.24. 集合回傳函式
- 9.25. 系統資訊函數
- 9.26. 系統管理函式
- 9.27. 觸發函式
- 9.28. 事件觸發函式
- 10. 型別轉換
- 11. 索引（Index）
- 12. 全文檢索
- 13. 一致性管理（MVCC）
- 14. 效能技巧
- 15. 平行查詢
- III. 系統管理
- 16. 用原始碼安裝
- 17. 用原始碼在 Windows 上安裝
- 18. 服務配置與維運
- 18.1. PostgreSQL 使用者帳號
- 18.2. Creating a Database Cluster
- 18.3. Starting the Database Server
- 18.4. 核心資源管理
- 18.5. Shutting Down the Server
- 18.6. Upgrading a PostgreSQL Cluster
- 18.7. Preventing Server Spoofing
- 18.8. Encryption Options
- 18.9. Secure TCP/IP Connections with SSL
- 18.10. Secure TCP/IP Connections with GSSAPI Encryption
- 18.11. Secure TCP/IP Connections with SSH Tunnels
- 18.12. 在 Windows 註冊事件日誌
- 19. 服務組態設定
- 19.1. Setting Parameters
- 19.2. File Locations
- 19.3. 連線與認證
- 19.4. 資源配置
- 19.5. Write Ahead Log
- 19.6. 複寫（Replication）
- 19.7. 查詢規畫
- 19.8. 錯誤回報與日誌記錄
- 19.9. 執行階段統計資訊
- 19.10. 自動資料庫清理
- 19.11. 用戶端連線預設參數
- 19.12. 交易鎖定管理
- 19.13. 版本與平台的相容性
- 19.14. Error Handling
- 19.15. 預先配置的參數
- 19.16. Customized Options
- 19.17. Developer Options
- 19.18. Short Options
- 20. 使用者認證
- 21. 資料庫角色
- 22. Managing Databases
- 23. 語系
- 24. 例行性資料庫維護工作
- 25. 備份及還原
- 26. High Availability, Load Balancing, and Replication
- 27. 監控資料庫活動
- 28. 監控磁碟使用情況
- 29. 高可靠度及預寫日誌
- 30. 邏輯複寫（Logical Replication）
- 31. Just-in-Time Compilation（JIT）
- 32. 迴歸測試
- IV. 用戶端介面
- 33. libpq - C Library
- 33.1. 資料庫連線控制函數
- 33.2. 連線狀態函數
- 33.3. Command Execution Functions
- 33.4. Asynchronous Command Processing
- 33.5. Retrieving Query Results Row-By-Row
- 33.6. Canceling Queries in Progress
- 33.7. The Fast-Path Interface
- 33.8. Asynchronous Notification
- 33.9. Functions Associated with the COPY Command
- 33.10. Control Functions
- 33.11. Miscellaneous Functions
- 33.12. Notice Processing
- 33.13. Event System
- 33.14. 環境變數
- 33.15. 密碼檔
- 33.16. The Connection Service File
- 33.17. LDAP Lookup of Connection Parameters
- 33.18. SSL Support
- 33.19. Behavior in Threaded Programs
- 33.20. Building libpq Programs
- 33.21. Example Programs
- 34. Large Objects
- 35. ECPG - Embedded SQL in C
- 36.1. The Concept
- 36.2. Managing Database Connections
- 36.3. Running SQL Commands
- 36.4. Using Host Variables
- 36.5. Dynamic SQL
- 36.6. pgtypes Library
- 36.7. Using Descriptor Areas
- 36.8. Error Handling
- 36.9. Preprocessor Directives
- 36.10. Processing Embedded SQL Programs
- 36.11. Library Functions
- 36.12. Large Objects
- 36.13. C++ Applications
- 36.14. Embedded SQL Commands
- 36.15. Informix Compatibility Mode
- 36.16. Internals
- 36. The Information Schema
- 36.1. The Schema
- 36.2. Data Types
- 36.3. information_schema_catalog_name
- 36.4. administrable_role_authorizations
- 36.5. applicable_roles
- 36.6. attributes
- 36.7. character_sets
- 36.8. check_constraint_routine_usage
- 36.9. check_constraints
- 36.10. collations
- 36.11. collation_character_set_applicability
- 36.12. column_domain_usage
- 36.13. column_options
- 36.14. column_privileges
- 36.15. column_udt_usage
- 36.16. columns
- 36.17. constraint_column_usage
- 37.18. constraint_table_usage
- 37.19. data_type_privileges
- 37.20. domain_constraints
- 37.21. domain_udt_usage
- 37.22. domains
- 37.23. element_types
- 37.24. enabled_roles
- 37.25. foreign_data_wrapper_options
- 37.26. foreign_data_wrappers
- 37.27. foreign_server_options
- 37.28. foreign_servers
- 37.29. foreign_table_options
- 37.30. foreign_tables
- 37.31. key_column_usage
- 37.32. parameters
- 37.33. referential_constraints
- 37.34. role_column_grants
- 37.35. role_routine_grants
- 37.36. role_table_grants
- 37.37. role_udt_grants
- 37.38. role_usage_grants
- 37.39. routine_privileges
- 37.40. routines
- 37.41. schemata
- 37.42. sequences
- 37.43. sql_features
- 37.44. sql_implementation_info
- 37.45. sql_languages
- 37.46. sql_packages
- 37.47. sql_parts
- 37.48. sql_sizing
- 37.49. sql_sizing_profiles
- 37.50. table_constraints
- 37.51. table_privileges
- 37.52. tables
- 37.53. transforms
- 37.54. triggered_update_columns
- 37.55. triggers
- 37.56. udt_privileges
- 37.57. usage_privileges
- 37.58. user_defined_types
- 37.59. user_mapping_options
- 37.60. user_mappings
- 37.61. view_column_usage
- 37.62. view_routine_usage
- 37.63. view_table_usage
- 37.64. views
- 33. libpq - C Library
- V. 資料庫程式設計
- 37. SQL 延伸功能
- 37.1. How Extensibility Works
- 37.2. The PostgreSQL Type System
- 37.3. 使用者自訂函數
- 37.4. User-defined Procedures
- 37.5. Query Language (SQL) Functions
- 37.6. Function Overloading
- 37.7. 函數易變性類別
- 37.8. Procedural Language Functions
- 37.9. Internal Functions
- 37.10. C-Language Functions
- 37.11. Function Optimization Information
- 37.12. User-defined Aggregates
- 37.13. User-defined Types
- 37.14. User-defined Operators
- 37.15. Operator Optimization Information
- 37.16. Interfacing Extensions To Indexes
- 37.17. 封裝相關物件到延伸功能中
- 37.18. Extension Building Infrastructure
- 38. Triggers
- 39. Event Triggers
- 40. 規則系統
- 41. Procedural Languages（程序語言）
- 43. PL/pgSQL - SQL Procedural Language
- 44. PL/Tcl - Tcl Procedural Language
- 45. PL/Perl - Perl Procedural Language
- 46. PL/Python - Python Procedural Language
- 47. Server Programming Interface
- 48. Background Worker Processes
- 49. Logical Decoding
- 50. Replication Progress Tracking
- 37. SQL 延伸功能
- VI. 參考資訊
- I. SQL 指令
- ALTER DATABASE
- ALTER DEFAULT PRIVILEGES
- ALTER EXTENSION
- ALTER FUNCTION
- ALTER INDEX
- ALTER LANGUAGE
- ALTER MATERIALIZED VIEW
- ALTER POLICY
- ALTER PUBLICATION
- ALTER ROLE
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER STATISTICS
- ALTER SUBSCRIPTION
- ALTER SYSTEM
- ALTER TABLE
- ALTER TABLESPACE
- ALTER TRIGGER
- ALTER TYPE
- ALTER VIEW
- ANALYZE
- CLUSTER
- COMMENT
- COPY
- CREATE CAST
- CREATE DATABASE
- CREATE EXTENSION
- CREATE FOREIGN TABLE
- CREATE FOREIGN DATA WRAPPER
- CREATE FUNCTION
- CREATE INDEX
- CREATE LANGUAGE
- CREATE MATERIALIZED VIEW
- CREATE DOMAIN
- CREATE POLICY
- CREATE PROCEDURE
- CREATE PUBLICATION
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE STATISTICS
- CREATE SUBSCRIPTION
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLESPACE
- CREATE TRANSFORM
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- DELETE
- DO
- DROP DATABASE
- DROP EXTENSION
- DROP FUNCTION
- DROP INDEX
- DROP LANGUAGE
- DROP MATERIALIZED VIEW
- DROP OWNED
- DROP POLICY
- DROP ROLE
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP STATISTICS
- DROP SUBSCRIPTION
- DROP TABLE
- DROP TABLESPACE
- DROP TRANSFORM
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP VIEW
- EXECUTE
- EXPLAIN
- GRANT
- IMPORT FOREIGN SCHEMA
- INSERT
- LISTEN
- LOAD
- NOTIFY
- PREPARE TRANSACTION
- REASSIGN OWNED
- REFRESH MATERIALIZED VIEW
- REINDEX
- RESET
- REVOKE
- SECURITY LABEL
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- TRUNCATE
- UNLISTEN
- UPDATE
- VACUUM
- VALUES
- II. PostgreSQL 用戶端工具
- III. PostgreSQL 伺服器應用程式
- I. SQL 指令
- VII. 資料庫進階
- 50. Overview of PostgreSQL Internals
- 51. 系統目錄
- 51.3. pg_am
- 51.7. pg_attribute
- 51.8. pg_authid
- 51.9. pg_auth_members
- 51.11 pg_class
- 51.12. pg_collation
- 51.13. pg_constraint
- 51.15 pg_database
- 51.22. pg_extension
- 51.26 pg_index
- 51.29. pg_language
- 51.32. pg_namespace
- 51.33. pg_opclass
- 51.38. pg_policy
- 51.39. pg_proc
- 51.44. pg_rewrite
- 51.50. pg_statistic
- 51.51. pg_statistic_ext
- 51.54. pg_tablespace
- 51.56. pg_trigger
- 51.62. pg_type
- 51.66. pg_available_extensions
- 51.67. pg_available_extension_versions
- 51.74. pg_locks
- 51.79. pg_replication_origin_status
- 51.82 pg_roles
- 51.85. pg_settings
- 51.87. pg_stats
- 52. Frontend/Backend Protocol
- 52.1. Overview
- 52.2. Message Flow
- 52.3. SASL Authentication
- 52.4. Streaming Replication Protocol
- 52.5. Logical Streaming Replication Protocol
- 52.6. Message Data Types
- 52.7. Message Formats
- 52.8. Error and Notice Message Fields
- 52.9. Logical Replication Message Formats
- 52.10. Summary of Changes since Protocol 2.0
- 53. PostgreSQL 程式撰寫慣例
- 54. Native Language Support
- 55. 撰寫程序語言的處理程序
- 56. Writing a Foreign Data Wrapper
- 64. GiST Indexes
- 65. SP-GiST Indexes
- 66. GIN 索引
- 67. BRIN Indexes
- 68. 資料庫實體儲存格式
- 70. How the Planner Uses Statistics
- VIII. 附錄
- 參考書目
暂无相关搜索结果！
本文档使用 BookStack 构建
