# Basic PostgreSQL Administration

> Installation, server architecture, basic configuration and day-to-day PostgreSQL administration.

---

LLMS index: [llms.txt](/en/llms.txt)

---

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

This course keeps the official topic order and exposes the English handout as readable, native Markdown for review and future editorial work.

> **Source status:** 官方 PDF 已提取为原生 Markdown

> **Translation baseline:** English baseline. The current English archive is the working baseline; the Russian edition is retained for chapter-level cross-checking.

## Course scope

Installation, server architecture, basic configuration and day-to-day PostgreSQL administration.

## Source status

| Language | Current package | Version | Topics | Course page |
| --- | --- | --- | ---: | --- |
| 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) |

## Contents

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

## Supplementary materials

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

## Editorial status

The available English handout is extracted from the official PDF. Where no current English archive was found, the route remains ready for a later source edition.

- [Version matrix](/en/versions/)
- [Work checklist](/en/checklist/)
- [Sources and permissions](/en/about/)

---

Section pages:

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