DBA1
Basic PostgreSQL Administration
Installation, server architecture, basic configuration and day-to-day PostgreSQL administration.
Baseline: English; English 16 extracted; Russian 16 retained for comparison; 17 topics.
Authors and translator
Course authors and publisher
Postgres Professional
The official training team, including Egor Rogov, Pavel Luzanov, Ilya Bashtanov and Aleksei Beresnev.
Chinese editor and translator
Vonng / Ruohang Feng
A PostgreSQL hacker and Pigsty founder preparing the Chinese catalog, source notes and future translation work.
What the scaffold contains
8courses
402language topic pages
216English/Russian source topics
5351PDF pages
Eight independent course books
From core administration to enterprise features
Every course keeps its topic order, language routes, source metadata and whole-book output. Open a course and continue topic by topic.
DBA2
Configuration and Monitoring of PostgreSQL
MVCC, WAL, locks, extensions, localization, monitoring and upgrades.
Baseline: English; English 16 extracted; Russian 16 retained for comparison; 18 topics.
DBA3
Backup and Replication
Logical and physical backup, WAL archiving, physical and logical replication, and cluster architectures.
Baseline: English; English 16-20260917 extracted; Russian 16 retained for comparison; 9 topics.
DBS
PostgreSQL Security Basics
Roles, membership, row-level security, authentication, SSL and external identity integration.
Baseline: Русский; English source pending; Russian 16 retained for comparison; 8 topics.
DEV1
Basic Server-Side Application Development
SQL and PL/pgSQL functions, procedures, triggers, dynamic commands and server-side logic.
Baseline: English; English 16 extracted; Russian 16 retained for comparison; 21 topics.
DEV2
Advanced Server-Side Application Development
Extensions, custom types, operator classes, asynchronous processing, full-text search and FDW.
Baseline: Русский; English source pending; Russian 16 retained for comparison; 21 topics.
PGPRO
Postgres Pro Enterprise Features
Postgres Pro Enterprise features for performance, security, backup and high availability.
Baseline: Русский; English source pending; Russian 16 retained for comparison; 23 topics.
QPT
Query Performance Tuning
Query planning and execution, access methods, joins, statistics and practical query tuning.
Baseline: English; English 16-20251018 extracted; Russian 16 retained for comparison; 17 topics.
Editorial workspace
From source inventory to page-by-page translation
Courses follow the official topic keys. English and Russian pages come from structured PDF text extraction; Chinese pages keep the same routes and order so translation, terminology, figures and cross-references can be added in place.
- Course catalog: see each course scope and topic count.
- Version matrix: inspect source packages and checksums.
- Work checklist: track review, translation and release gates.
- Sources and permissions: keep upstream links and redistribution boundaries visible.
Current state
Fix the structure first, then edit the content
This site first establishes a readable OINK library for the public course material. English and Russian pages have native Markdown; Chinese pages are translation scaffolds. Complex figures, formulas, tables, code and speaker notes still need page-by-page review against the source PDFs, and permission to translate, modify and redistribute the material must be confirmed separately.