没有合适的资源?快使用搜索试试~ 我知道了~
首页PostgreSQL 13.1官方文档:许可与免责声明
PostgreSQL 13.1官方文档:许可与免责声明
需积分: 9 7 下载量 148 浏览量
更新于2024-07-15
收藏 12.62MB PDF 举报
"PostgreSQL 13.1文档是PostgreSQL全球开发组发布的一份官方资料,该版本的PostgreSQL是开源的关系型数据库管理系统。它在1996年至2020年期间持续更新和发展,版权归属于PostgreSQL Global Development Group。这份文档包含了对PostgreSQL 13.1特性和功能的详细介绍,包括安装、配置、数据类型、查询语言(SQL)、事务处理、并发控制、存储过程、索引、安全性、备份恢复等方面的知识。
文档强调了其自由和开源的特性,用户可以根据GNU General Public License (GPL)条款无费用地使用、复制、修改和分发此软件及文档,但必须保留版权声明和特定的许可条款,包括关于责任限制的法律声明。用户在使用过程中应注意,尽管PostgreSQL提供了广泛的使用权限,但加州大学及其代表并不对因使用软件或文档而产生的任何直接、间接、特殊、附带或后果性损失承担责任,这包括但不限于经济损失。
PostgreSQL 13.1在设计上注重性能和可靠性,它支持先进的查询优化技术,以及对JSON和数组等现代数据类型的高效处理。此外,它还强化了安全性措施,如SSL/TLS加密、角色和权限管理,以及针对SQL注入攻击的防护。文档详细介绍了如何配置防火墙规则和设置用户访问策略,确保数据的安全存储和传输。
在备份与恢复方面,文档提供了多种备份方法,包括热备份、冷备份和 WAL 日志备份,以及如何进行故障恢复和数据一致性维护。对于分布式部署和高可用性解决方案,也有所涉及,帮助用户构建可扩展的数据库架构。
PostgreSQL 13.1文档是一份全面且详尽的技术指南,无论是初学者还是高级用户都能从中找到所需的信息,以充分利用PostgreSQL的功能,并遵循其开源精神进行定制化开发和应用。"
PostgreSQL 13.1 Documentation
51.9. pg_auth_members ....................................................................... 2086
51.10. pg_cast ...................................................................................... 2087
51.11. pg_class .................................................................................... 2088
51.12. pg_collation ............................................................................ 2090
51.13. pg_constraint .......................................................................... 2091
51.14. pg_conversion .......................................................................... 2092
51.15. pg_database .............................................................................. 2093
51.16. pg_db_role_setting ................................................................ 2094
51.17. pg_default_acl ........................................................................ 2094
51.18. pg_depend .................................................................................. 2095
51.19. pg_description ........................................................................ 2097
51.20. pg_enum ...................................................................................... 2097
51.21. pg_event_trigger .................................................................... 2098
51.22. pg_extension ............................................................................ 2098
51.23. pg_foreign_data_wrapper ...................................................... 2099
51.24. pg_foreign_server .................................................................. 2100
51.25. pg_foreign_table .................................................................... 2100
51.26. pg_index .................................................................................... 2101
51.27. pg_inherits .............................................................................. 2102
51.28. pg_init_privs .......................................................................... 2102
51.29. pg_language .............................................................................. 2103
51.30. pg_largeobject ........................................................................ 2104
51.31. pg_largeobject_metadata ...................................................... 2104
51.32. pg_namespace ............................................................................ 2105
51.33. pg_opclass ................................................................................ 2105
51.34. pg_operator .............................................................................. 2106
51.35. pg_opfamily .............................................................................. 2107
51.36. pg_partitioned_table ............................................................ 2107
51.37. pg_policy .................................................................................. 2108
51.38. pg_proc ...................................................................................... 2108
51.39. pg_publication ........................................................................ 2111
51.40. pg_publication_rel ................................................................ 2111
51.41. pg_range .................................................................................... 2111
51.42. pg_replication_origin .......................................................... 2112
51.43. pg_rewrite ................................................................................ 2112
51.44. pg_seclabel .............................................................................. 2113
51.45. pg_sequence .............................................................................. 2113
51.46. pg_shdepend .............................................................................. 2114
51.47. pg_shdescription .................................................................... 2115
51.48. pg_shseclabel .......................................................................... 2116
51.49. pg_statistic ............................................................................ 2116
51.50. pg_statistic_ext .................................................................... 2117
51.51. pg_statistic_ext_data .......................................................... 2118
51.52. pg_subscription ...................................................................... 2119
51.53. pg_subscription_rel .............................................................. 2119
51.54. pg_tablespace .......................................................................... 2120
51.55. pg_transform ............................................................................ 2120
51.56. pg_trigger ................................................................................ 2121
51.57. pg_ts_config ............................................................................ 2122
51.58. pg_ts_config_map .................................................................... 2123
51.59. pg_ts_dict ................................................................................ 2123
51.60. pg_ts_parser ............................................................................ 2123
51.61. pg_ts_template ........................................................................ 2124
51.62. pg_type ...................................................................................... 2124
51.63. pg_user_mapping ...................................................................... 2128
51.64. System Views ................................................................................ 2128
51.65. pg_available_extensions ...................................................... 2129
51.66. pg_available_extension_versions ...................................... 2130
xvi
PostgreSQL 13.1 Documentation
51.67. pg_config .................................................................................. 2130
51.68. pg_cursors ................................................................................ 2131
51.69. pg_file_settings .................................................................... 2131
51.70. pg_group .................................................................................... 2132
51.71. pg_hba_file_rules .................................................................. 2132
51.72. pg_indexes ................................................................................ 2133
51.73. pg_locks .................................................................................... 2134
51.74. pg_matviews .............................................................................. 2136
51.75. pg_policies .............................................................................. 2136
51.76. pg_prepared_statements ........................................................ 2137
51.77. pg_prepared_xacts .................................................................. 2138
51.78. pg_publication_tables .......................................................... 2138
51.79. pg_replication_origin_status ............................................ 2139
51.80. pg_replication_slots ............................................................ 2139
51.81. pg_roles .................................................................................... 2140
51.82. pg_rules .................................................................................... 2141
51.83. pg_seclabels ............................................................................ 2141
51.84. pg_sequences ............................................................................ 2142
51.85. pg_settings .............................................................................. 2143
51.86. pg_shadow .................................................................................. 2145
51.87. pg_shmem_allocations ............................................................ 2145
51.88. pg_stats .................................................................................... 2146
51.89. pg_stats_ext ............................................................................ 2147
51.90. pg_tables .................................................................................. 2148
51.91. pg_timezone_abbrevs .............................................................. 2149
51.92. pg_timezone_names .................................................................. 2149
51.93. pg_user ...................................................................................... 2150
51.94. pg_user_mappings .................................................................... 2150
51.95. pg_views .................................................................................... 2151
52. Frontend/Backend Protocol ........................................................................... 2152
52.1. Overview ........................................................................................ 2152
52.2. Message Flow .................................................................................. 2154
52.3. SASL Authentication ........................................................................ 2166
52.4. Streaming Replication Protocol ........................................................... 2168
52.5. Logical Streaming Replication Protocol ................................................ 2175
52.6. Message Data Types ......................................................................... 2176
52.7. Message Formats .............................................................................. 2176
52.8. Error and Notice Message Fields ......................................................... 2193
52.9. Logical Replication Message Formats .................................................. 2195
52.10. Summary of Changes since Protocol 2.0 ............................................. 2199
53. PostgreSQL Coding Conventions ................................................................... 2201
53.1. Formatting ....................................................................................... 2201
53.2. Reporting Errors Within the Server ...................................................... 2201
53.3. Error Message Style Guide ................................................................. 2205
53.4. Miscellaneous Coding Conventions ...................................................... 2209
54. Native Language Support ............................................................................. 2211
54.1. For the Translator ............................................................................. 2211
54.2. For the Programmer .......................................................................... 2213
55. Writing a Procedural Language Handler .......................................................... 2217
56. Writing a Foreign Data Wrapper .................................................................... 2220
56.1. Foreign Data Wrapper Functions ......................................................... 2220
56.2. Foreign Data Wrapper Callback Routines .............................................. 2220
56.3. Foreign Data Wrapper Helper Functions ............................................... 2234
56.4. Foreign Data Wrapper Query Planning ................................................. 2235
56.5. Row Locking in Foreign Data Wrappers ............................................... 2237
57. Writing a Table Sampling Method ................................................................. 2239
57.1. Sampling Method Support Functions .................................................... 2239
58. Writing a Custom Scan Provider .................................................................... 2242
xvii
PostgreSQL 13.1 Documentation
58.1. Creating Custom Scan Paths ............................................................... 2242
58.2. Creating Custom Scan Plans ............................................................... 2243
58.3. Executing Custom Scans .................................................................... 2244
59. Genetic Query Optimizer .............................................................................. 2247
59.1. Query Handling as a Complex Optimization Problem .............................. 2247
59.2. Genetic Algorithms ........................................................................... 2247
59.3. Genetic Query Optimization (GEQO) in PostgreSQL .............................. 2248
59.4. Further Reading ............................................................................... 2250
60. Table Access Method Interface Definition ....................................................... 2251
61. Index Access Method Interface Definition ....................................................... 2252
61.1. Basic API Structure for Indexes .......................................................... 2252
61.2. Index Access Method Functions .......................................................... 2254
61.3. Index Scanning ................................................................................ 2260
61.4. Index Locking Considerations ............................................................. 2261
61.5. Index Uniqueness Checks .................................................................. 2262
61.6. Index Cost Estimation Functions ......................................................... 2263
62. Generic WAL Records ................................................................................. 2267
63. B-Tree Indexes ........................................................................................... 2269
63.1. Introduction ..................................................................................... 2269
63.2. Behavior of B-Tree Operator Classes ................................................... 2269
63.3. B-Tree Support Functions .................................................................. 2270
63.4. Implementation ................................................................................ 2273
64. GiST Indexes ............................................................................................. 2275
64.1. Introduction ..................................................................................... 2275
64.2. Built-in Operator Classes ................................................................... 2275
64.3. Extensibility .................................................................................... 2276
64.4. Implementation ................................................................................ 2288
64.5. Examples ........................................................................................ 2288
65. SP-GiST Indexes ........................................................................................ 2289
65.1. Introduction ..................................................................................... 2289
65.2. Built-in Operator Classes ................................................................... 2289
65.3. Extensibility .................................................................................... 2290
65.4. Implementation ................................................................................ 2299
65.5. Examples ........................................................................................ 2300
66. GIN Indexes .............................................................................................. 2301
66.1. Introduction ..................................................................................... 2301
66.2. Built-in Operator Classes ................................................................... 2301
66.3. Extensibility .................................................................................... 2301
66.4. Implementation ................................................................................ 2304
66.5. GIN Tips and Tricks ......................................................................... 2306
66.6. Limitations ...................................................................................... 2306
66.7. Examples ........................................................................................ 2307
67. BRIN Indexes ............................................................................................ 2308
67.1. Introduction ..................................................................................... 2308
67.2. Built-in Operator Classes ................................................................... 2309
67.3. Extensibility .................................................................................... 2310
68. Database Physical Storage ............................................................................ 2313
68.1. Database File Layout ........................................................................ 2313
68.2. TOAST ........................................................................................... 2315
68.3. Free Space Map ............................................................................... 2318
68.4. Visibility Map .................................................................................. 2318
68.5. The Initialization Fork ....................................................................... 2318
68.6. Database Page Layout ....................................................................... 2319
69. System Catalog Declarations and Initial Contents ............................................. 2323
69.1. System Catalog Declaration Rules ....................................................... 2323
69.2. System Catalog Initial Data ................................................................ 2324
69.3. BKI File Format ............................................................................... 2329
69.4. BKI Commands ............................................................................... 2329
xviii
PostgreSQL 13.1 Documentation
69.5. Structure of the Bootstrap BKI File ..................................................... 2330
69.6. BKI Example ................................................................................... 2331
70. How the Planner Uses Statistics .................................................................... 2332
70.1. Row Estimation Examples ................................................................. 2332
70.2. Multivariate Statistics Examples .......................................................... 2337
70.3. Planner Statistics and Security ............................................................ 2341
71. Backup Manifest Format .............................................................................. 2343
71.1. Backup Manifest Top-level Object ....................................................... 2343
71.2. Backup Manifest File Object .............................................................. 2343
71.3. Backup Manifest WAL Range Object .................................................. 2344
VIII. Appendixes ...................................................................................................... 2345
A. PostgreSQL Error Codes ............................................................................... 2351
B. Date/Time Support ....................................................................................... 2360
B.1. Date/Time Input Interpretation ............................................................. 2360
B.2. Handling of Invalid or Ambiguous Timestamps ....................................... 2361
B.3. Date/Time Key Words ........................................................................ 2362
B.4. Date/Time Configuration Files ............................................................. 2363
B.5. POSIX Time Zone Specifications ......................................................... 2364
B.6. History of Units ................................................................................ 2366
C. SQL Key Words .......................................................................................... 2368
D. SQL Conformance ....................................................................................... 2392
D.1. Supported Features ............................................................................ 2393
D.2. Unsupported Features ......................................................................... 2404
D.3. XML Limits and Conformance to SQL/XML ......................................... 2412
E. Release Notes .............................................................................................. 2416
E.1. Release 13.1 ..................................................................................... 2416
E.2. Release 13 ........................................................................................ 2420
E.3. Prior Releases ................................................................................... 2438
F. Additional Supplied Modules .......................................................................... 2439
F.1. adminpack ........................................................................................ 2440
F.2. amcheck ........................................................................................... 2441
F.3. auth_delay ........................................................................................ 2444
F.4. auto_explain ...................................................................................... 2445
F.5. bloom .............................................................................................. 2447
F.6. btree_gin .......................................................................................... 2451
F.7. btree_gist .......................................................................................... 2451
F.8. citext ............................................................................................... 2452
F.9. cube ................................................................................................. 2455
F.10. dblink ............................................................................................. 2459
F.11. dict_int ........................................................................................... 2491
F.12. dict_xsyn ........................................................................................ 2492
F.13. earthdistance .................................................................................... 2493
F.14. file_fdw .......................................................................................... 2495
F.15. fuzzystrmatch .................................................................................. 2497
F.16. hstore ............................................................................................. 2500
F.17. intagg ............................................................................................. 2507
F.18. intarray ........................................................................................... 2508
F.19. isn ................................................................................................. 2512
F.20. lo ................................................................................................... 2515
F.21. ltree ............................................................................................... 2516
F.22. pageinspect ...................................................................................... 2524
F.23. passwordcheck ................................................................................. 2532
F.24. pg_buffercache ................................................................................. 2533
F.25. pgcrypto ......................................................................................... 2534
F.26. pg_freespacemap .............................................................................. 2546
F.27. pg_prewarm .................................................................................... 2547
F.28. pgrowlocks ...................................................................................... 2548
F.29. pg_stat_statements ............................................................................ 2549
xix
PostgreSQL 13.1 Documentation
F.30. pgstattuple ....................................................................................... 2556
F.31. pg_trgm .......................................................................................... 2560
F.32. pg_visibility .................................................................................... 2566
F.33. postgres_fdw ................................................................................... 2567
F.34. seg ................................................................................................. 2573
F.35. sepgsql ........................................................................................... 2576
F.36. spi ................................................................................................. 2584
F.37. sslinfo ............................................................................................ 2585
F.38. tablefunc ......................................................................................... 2587
F.39. tcn ................................................................................................. 2596
F.40. test_decoding ................................................................................... 2598
F.41. tsm_system_rows ............................................................................. 2598
F.42. tsm_system_time .............................................................................. 2599
F.43. unaccent ......................................................................................... 2599
F.44. uuid-ossp ........................................................................................ 2601
F.45. xml2 .............................................................................................. 2603
G. Additional Supplied Programs ........................................................................ 2608
G.1. Client Applications ............................................................................ 2608
G.2. Server Applications ............................................................................ 2615
H. External Projects .......................................................................................... 2620
H.1. Client Interfaces ................................................................................ 2620
H.2. Administration Tools .......................................................................... 2620
H.3. Procedural Languages ........................................................................ 2620
H.4. Extensions ........................................................................................ 2621
I. The Source Code Repository ........................................................................... 2622
I.1. Getting the Source via Git .................................................................... 2622
J. Documentation ............................................................................................. 2623
J.1. DocBook ........................................................................................... 2623
J.2. Tool Sets .......................................................................................... 2623
J.3. Building the Documentation ................................................................. 2625
J.4. Documentation Authoring .................................................................... 2626
J.5. Style Guide ....................................................................................... 2627
K. PostgreSQL Limits ....................................................................................... 2629
L. Acronyms ................................................................................................... 2630
M. Glossary .................................................................................................... 2636
N. Color Support .............................................................................................. 2648
N.1. When Color is Used .......................................................................... 2648
N.2. Configuring the Colors ....................................................................... 2648
Bibliography ............................................................................................................ 2649
Index ...................................................................................................................... 2651
xx
剩余2714页未读,继续阅读
2020-05-21 上传
2021-01-11 上传
2023-06-22 上传
2023-11-30 上传
2023-05-15 上传
2023-11-11 上传
2023-09-25 上传
2023-10-12 上传
2024-01-15 上传
harrypenny
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 磁性吸附笔筒设计创新,行业文档精选
- Java Swing实现的俄罗斯方块游戏代码分享
- 骨折生长的二维与三维模型比较分析
- 水彩花卉与羽毛无缝背景矢量素材
- 设计一种高效的袋料分离装置
- 探索4.20图包.zip的奥秘
- RabbitMQ 3.7.x延时消息交换插件安装与操作指南
- 解决NLTK下载停用词失败的问题
- 多系统平台的并行处理技术研究
- Jekyll项目实战:网页设计作业的入门练习
- discord.js v13按钮分页包实现教程与应用
- SpringBoot与Uniapp结合开发短视频APP实战教程
- Tensorflow学习笔记深度解析:人工智能实践指南
- 无服务器部署管理器:防止错误部署AWS帐户
- 医疗图标矢量素材合集:扁平风格16图标(PNG/EPS/PSD)
- 人工智能基础课程汇报PPT模板下载
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功