Postgres:The First Experience

1. Figure 3.1 — Selecting installation components
2. Figure 3.2 — Choosing the data directory
3. Figure 3.3 — Setting server connection options
4. Figure 3.4 — Choosing server configuration defaults
5. Figure 4.1 — Launching SQL Shell from the Start menu
6. Figure 5.1 — Bookings database relationships
7. Figure 5.2 — Airports and routes in the demo database
8. Figure 7.1 — Connecting a 1C infobase to PostgreSQL
9. Figure 8.1 — Registering a server in pgAdmin
10. Figure 8.2 — Browsing database objects in pgAdmin
11. Figure 8.3 — Running a query in pgAdmin
12. Figure 10.1 — Administration course pathways
13. Figure 10.2 — Development course pathways
14. Figure 10.3 — Postgres Pro Enterprise course prerequisites
15. Figure 10.4 — PostgreSQL. SQL Basics — book cover
16. Figure 10.5 — Evgeny Morgunov
17. Figure 10.6 — Database Technology Fundamentals — book cover
18. Figure 10.7 — Boris Novikov
19. Figure 10.8 — PostgreSQL 14 Internals — book cover
20. Figure 10.9 — Egor Rogov
21. Figure 10.10 — PostgreSQL Monitoring — book cover
22. Figure 10.11 — Alexey Lesovsky
23. Figure 10.12 — A Database Guide — book cover
24. Figure 10.13 — Vladimir Komarov

© Postgres Professional, 2016–2025. The English text and illustrations are reproduced from the 11th edition · PostgreSQL 17 PDF. This web edition keeps the original chapter order, examples, and version-specific behavior. Original page references link to their corresponding locations in the chapters.

Publisher and original editions · Publication and credits

These notes were added by the web edition after checking the supplied PDF against the PostgreSQL 17 documentation. The chapter text and examples retain the original wording. Chapter summaries and descriptive figure captions are also additions to aid navigation. Page numbers below refer to the printed book; the PDF page number is one higher.

Replication slot status — p. 18

In Logical replication, conflicting and invalidation_reason belong to pg_replication_slots. The source names pg_stat_replication in error. See the PostgreSQL 17 view definition.

Direct TLS — p. 20

In Access control, use sslnegotiation=direct together with sslmode=require, verify-ca, or verify-full. The source’s requiredirect is not a valid value. See the libpq connection parameters.

Grouping keys — p. 20

In Query planning and execution, the planner reorders GROUP BY keys, rather than tables, to use an available ordering. See enable_group_by_reordering.

Parallel functions — p. 20

The same section needs a qualification: a function using a subtransaction for error recovery may be explicitly marked PARALLEL SAFE when all its operations meet the safety requirements. Functions remain PARALLEL UNSAFE by default; an EXCEPTION block does not automatically make them safe. See CREATE FUNCTION.

Synchronization option — p. 23

In Miscellaneous, the utility option is --sync-method. The source spells it --synch-method. See the PostgreSQL 17 release notes.

Combined I/O size — p. 23

In that section, an io_combine_limit value written without a unit is measured in database blocks, normally 8 kB each. It is not a raw byte count. The default is 128 kB. See io_combine_limit.

Logical replication during upgrades — p. 17

The upgrade description applies when the old cluster is PostgreSQL 17 or later. It does not promise preservation of logical slots and subscriptions when upgrading a pre-17 cluster to 17. See the PostgreSQL 17 release notes.

Debian and Ubuntu installation — p. 30

The repository command needs a space: $(lsb_release -cs). The PDF prints $(lsb_release-cs), which attempts to run a different command. The distribution list and apt-key workflow also reflect the original edition. For a new installation, follow the PostgreSQL project’s current Debian or Ubuntu instructions and select PostgreSQL 17 to match this book.

SELECT documentation link — p. 53

The original link at the end of Grouping returned HTTP 404 during this review. The displayed address preserves the source wording; its link now opens the PostgreSQL 17 GROUP BY reference. The original destination is recorded in the source manifest.