PostgreSQL Lab: PostgreSQL 18 in Docker, psql, pgAdmin and Porting Bookstore
In the PostgreSQL 18 image the volume is now mounted at /var/lib/postgresql and the data lives in an 18/docker subdirectory; with data at the old /data path the image refuses to start. A permanent Bookstore lab: a named volume, separate owner, app and superuser roles, ALTER DEFAULT PRIVILEGES, a ported schema with snake_case, IDENTITY and one million orders, psql meta-commands and psqlrc, pg_hba.conf, reload versus restart with ALTER SYSTEM, and the quoted "Books" table trap from EF Core.
14 Nov 2026
·
16 min
·
3
