问题描述

该笔记将记录：在 PostgreSQL 中，进行服务维护的方法以及相关问题的解决办法。

解决方案

该部分的主要内容均来自于官方文档，但是提取出在各章节中我们关注的内容，让我们形成对 PostgreSQL 的整体认识。

该部分内容主要来自官方文档的以下章节，偏向于 PostgreSQL 服务的维护及系统管理：

III）Server Administration
— 16）Installation from Binaries => Installing and Upgrading
— 17）Installation from Source Code => Installing and Upgrading
— 18）Installation from Source Code on Windows => Installing and Upgrading
— 19）Server Setup and Operation => Problems Solving and How-to
— 20）Server Configuration => Maintenance, Administration
— 21）Client Authentication => Client Authentication
— 22）Database Roles
— 23）Managing Databases
— 24）Localization
— 25）Routine Database Maintenance Tasks
— 26）Backup and Restore
— 27）High Availability, Load Balancing, and Replication
— 28）Monitoring Database Activity
— 29）Monitoring Disk Usage
— 30）Reliability and the Write-Ahead Log
— 31）Logical Replication
— 32）Just-in-Time Compilation (JIT)
— 33）Regression Tests

参考文献

PostgreSQL: The world’s most advanced open source database
PostgreSQL: Documentation: 14: Part III. Server Administration