Appendix A: Glossary and Indexes
Appendix A: Glossary and Indexes
← 7. Evolution | Index | Next: Appendix B. References →
A.1 Term Definitions
| Term | Definition |
|---|---|
| Apache AGE | A PostgreSQL extension that adds graph data types and query capabilities. Previously included in the container image; now removed. |
| Debezium | A CDC platform that consumes PostgreSQL logical decoding streams and publishes change events to downstream systems. |
| Logical decoding | A PostgreSQL feature that streams logical changes from the write-ahead log (WAL) for CDC consumers. |
| pg_cron | A PostgreSQL extension that provides scheduled job execution inside the database server. The only extension that remains in the container image. |
| pg_net | A PostgreSQL extension that provides network and HTTP helper functions. Previously included in the container image; now removed. |
| pg_upgrade | A PostgreSQL tool for major-version upgrades that migrates a data directory to a new server version while preserving data. |
| pgvector | A PostgreSQL extension that provides vector types and similarity indexing. Previously included in the container image; now removed. |
| PgBouncer transaction pooling | A pool mode where connections are returned to the pool at transaction boundaries. Used for application workloads. |
| PgBouncer session pooling | A pool mode where a client retains a dedicated server connection for the session. Used for migration and administrative workflows. |
| Prisma baselining | The process of marking the current database schema as the new migration baseline, replacing the historical migration chain with a snapshot of the current state. |
| wal_level | A PostgreSQL configuration setting that determines WAL verbosity; the value logical is required for logical decoding. |
A.2 ADR Index
| ADR | Decision | Rationale | Defined In |
|---|---|---|---|
| ADR-001 | Standardize on PostgreSQL 18 for all containers | 6.2.1 | 2.3 |
| ADR-002 | Uniform baseline across metadata and tenant databases | 6.2.2 | 2.3 |
| ADR-003 | Remove AGE, pgvector, and pg_net from container image | 5.6.1 | 4.8 |
| ADR-004 | Baseline Prisma migrations to align extension surface | 5.6.2 | 4.7.1 |
A.3 Invariant Index
| Invariant | Title | Section |
|---|---|---|
| 1 | Baseline Version | 2.3 |
| 2 | Data Integrity Preservation | 2.3 |
| 3 | Rollback Capability | 2.3 |
| 4 | Logical Decoding Continuity | 2.3 |
| 5 | Extension Availability | 2.3 |
| 6 | Pooler Compatibility | 2.3 |
A.4 Diagram Index
| Diagram | Type | Section | Description |
|---|---|---|---|
| Figure 3-1 | flowchart | 3.1 | Containerized PostgreSQL 18 stack interactions and CDC flow |
Document Navigation
| Previous | Index | Next |
|---|---|---|
| ← 7. Evolution | Table of Contents | Appendix B. References → |
End of Appendix A