# PostgreSQL 管理：基础课程

> 从安装、服务器架构和基本配置开始，建立 PostgreSQL 日常管理的基础。

---

LLMS 索引： [llms.txt](/llms.txt)

---

<!-- Generated by scripts/generate_skeleton.py. -->

这里整理 PGPRO 培训的八门 PostgreSQL 课程。中文页先固定课程顺序、主题键和来源关系，下一步可以逐页加工译文。

> **资料状态:** 中文译文骨架，正文待加工

> **翻译基线:** English。英文完整 16 版课程包已公开，俄文完整 16 版用于逐章交叉核对。

## 课程定位

从安装、服务器架构和基本配置开始，建立 PostgreSQL 日常管理的基础。

## 资料状态

| 语言 | 当前公开包 | 版本 | 主题数 | 课程页 |
| --- | --- | --- | ---: | --- |
| English | [DBA1-handouts-16-en.zip](https://edu.postgrespro.com/16/DBA1-handouts-16-en.zip) | 16 | 17 | [HTTP 200](https://postgrespro.com/community/courses/DBA1) |
| Русский | [DBA1-handouts-16.zip](https://edu.postgrespro.ru/16/DBA1-handouts-16.zip) | 16 | 17 | [HTTP 200](https://postgrespro.ru/education/courses/DBA1) |

## 课程目录

- [00 Basic Course](/dba1/dba1-00-introduction/)
- [01 Server Installation and Management](/dba1/dba1-01-tools-install/)
- [02 Using psql](/dba1/dba1-02-tools-psql/)
- [03 Server Configuration](/dba1/dba1-03-tools-configuration/)
- [04 PostgreSQL Fundamentals](/dba1/dba1-04-arch-general/)
- [05 Isolation and MVCC](/dba1/dba1-05-arch-mvcc-overview/)
- [06 Vacuuming](/dba1/dba1-06-arch-vacuum-overview/)
- [07 Buffer Cache and WAL](/dba1/dba1-07-arch-wal-overview/)
- [08 Databases and Schemas](/dba1/dba1-08-data-databases/)
- [09 System Catalog](/dba1/dba1-09-data-catalog/)
- [10 Tablespaces](/dba1/dba1-10-data-tablespaces/)
- [11 Low Level](/dba1/dba1-11-data-lowlevel/)
- [12 Monitoring](/dba1/dba1-12-admin-monitoring/)
- [13 Overview](/dba1/dba1-13-access-overview/)
- [14 Overview](/dba1/dba1-14-backup-overview/)
- [15 Overview of Physical Replication](/dba1/dba1-15-replica-overview-physical/)
- [16 Overview of Logical Replication](/dba1/dba1-16-replica-overview-logical/)

## 辅助资料

- `catalogs.pdf`
- `dba1_new_features.pdf`
- `dba1_student_guide.pdf`
- `unix_commands.pdf`

## 编辑状态

英文和俄文页已经从官方 PDF 提取为原生 Markdown；中文页保留同一主题结构，用于后续翻译、术语统一、图表重建和交叉引用。

- [课程版本矩阵](/versions/)
- [可执行翻译清单](/checklist/)
- [来源与许可](/about/)

---

本节页面：

- [第 00 讲：PostgreSQL Administration / Basic Course（待翻译）](/dba1/dba1-00-introduction/): 中文译稿占位页：PostgreSQL Administration / Basic Course
- [第 01 讲：Basic Tools / Server Installation and Management（待翻译）](/dba1/dba1-01-tools-install/): 中文译稿占位页：Basic Tools / Server Installation and Management
- [第 02 讲：Basic Tools / Using psql（待翻译）](/dba1/dba1-02-tools-psql/): 中文译稿占位页：Basic Tools / Using psql
- [第 03 讲：Basic Tools / Server Configuration（待翻译）](/dba1/dba1-03-tools-configuration/): 中文译稿占位页：Basic Tools / Server Configuration
- [第 04 讲：Architecture / PostgreSQL Fundamentals（待翻译）](/dba1/dba1-04-arch-general/): 中文译稿占位页：Architecture / PostgreSQL Fundamentals
- [第 05 讲：Architecture / Isolation and MVCC（待翻译）](/dba1/dba1-05-arch-mvcc-overview/): 中文译稿占位页：Architecture / Isolation and MVCC
- [第 06 讲：Architecture / Vacuuming（待翻译）](/dba1/dba1-06-arch-vacuum-overview/): 中文译稿占位页：Architecture / Vacuuming
- [第 07 讲：Architecture / Buffer Cache and WAL（待翻译）](/dba1/dba1-07-arch-wal-overview/): 中文译稿占位页：Architecture / Buffer Cache and WAL
- [第 08 讲：Data Organization / Databases and Schemas（待翻译）](/dba1/dba1-08-data-databases/): 中文译稿占位页：Data Organization / Databases and Schemas
- [第 09 讲：Data Organization / System Catalog（待翻译）](/dba1/dba1-09-data-catalog/): 中文译稿占位页：Data Organization / System Catalog
- [第 10 讲：Data Organization / Tablespaces（待翻译）](/dba1/dba1-10-data-tablespaces/): 中文译稿占位页：Data Organization / Tablespaces
- [第 11 讲：Data Organization / Low Level（待翻译）](/dba1/dba1-11-data-lowlevel/): 中文译稿占位页：Data Organization / Low Level
- [第 12 讲：Administrative Tasks / Monitoring（待翻译）](/dba1/dba1-12-admin-monitoring/): 中文译稿占位页：Administrative Tasks / Monitoring
- [第 13 讲：Access Control / Overview（待翻译）](/dba1/dba1-13-access-overview/): 中文译稿占位页：Access Control / Overview
- [第 14 讲：Backup / Overview（待翻译）](/dba1/dba1-14-backup-overview/): 中文译稿占位页：Backup / Overview
- [第 15 讲：Replication / Overview of Physical Replication（待翻译）](/dba1/dba1-15-replica-overview-physical/): 中文译稿占位页：Replication / Overview of Physical Replication
- [第 16 讲：Replication / Overview of Logical Replication（待翻译）](/dba1/dba1-16-replica-overview-logical/): 中文译稿占位页：Replication / Overview of Logical Replication