PostgreSQL 19 Released with WAIT FOR LSN
Start here
PostgreSQL 19 has been released, about two months later than the usual September schedule. Simon Willison attributes the delay mainly to the volume of vulnerability issues the PostgreSQL team had to address, which he describes as part of an ongoing wave of AI-reported vulnerabilities. The release adds WAIT FOR LSN, which lets a standby session wait until it has replayed the WAL up to a given log sequence number before running a query. This allows applications reading from replicas to see writes just made on the primary. A timeout is optional; if one is set and the replica does not catch up within the specified time, the session raises an error.
Generated from reports · updated 2 h ago
Report timeline
Follow the reports to see the event from different sides.
- Simon WillisonPostgreSQL 19 Released with WAIT FOR LSN for Read-Your-Writes Consistency
PostgreSQL 19 has shipped, roughly two months later than the usual September release, after the team worked through a wave of AI-reported vulnerability issues. The release adds WAIT FOR LSN, which lets a standby session wait until it has replayed the WAL up to a given log sequence number before running a query, so applications reading from replicas can see writes just made on the primary. An optional timeout raises an error if the replica does not catch up in time.
Heat for this event
Not enough continuous observations yet to draw a trend.