
PostgreSQL 19 was released yesterday 19-Nov-2026 Some important features in this release :
🔹 Logical replication supports sequence synchronization
🔹 Logical replication can be enabled without restarting
🔹 REPACK (CONCURRENTLY) for reclaiming table bloat without blocking reads/writes
🔹 ON CONFLICT DO SELECT for cleaner get-or-create queries without dead tuples
🔹 WAIT FOR LSN to guarantee read-your-writes consistency on replicas
🔹 Native query plan guardrails with pg_plan_advice
You can spin up a quick container using:
docker run -d \ --name postgres19_server \ -p 0.0.0.0:5432:5432 \ -v postgres19_data:/var/lib/postgresql \ -e POSTGRES_USER=postgres \ -e POSTGRES_PASSWORD='YourPassword321##' \ -e POSTGRES_DB=demodb \ --restart always \ postgres:19
## Connect and check :
docker exec -it postgres19_server psql -U postgres -d postgres
## To remove the container :
docker rm -f postgres19_server