PostgreSQL 19 is here !

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

Leave a Reply