PostgREST

Databases & DataMIT

Turns a PostgreSQL schema directly into a RESTful API.

Latest v16.4 · by PostgRESTWritten in HaskellWebsitePostgREST/postgrestRSS

Branches

16
v16.4
14
v14.18

Release activity

Release activity — 16 releases across 16 days since Apr 3, 2026. Each cell is one day; darker means more releases that day. Nothing is recorded before Apr 3, 2026. Older weeks are hidden at this screen width.
JulAugSepOct
SundayNo releases on Jun 28, 2026No releases on Jul 5, 2026No releases on Jul 12, 2026No releases on Jul 19, 2026No releases on Jul 26, 2026No releases on Aug 2, 2026No releases on Aug 9, 2026No releases on Aug 16, 2026No releases on Aug 23, 2026No releases on Aug 30, 2026No releases on Sep 6, 2026No releases on Sep 13, 2026No releases on Sep 20, 2026No releases on Sep 27, 2026No releases on Oct 4, 2026No releases on Oct 11, 2026
Monday1 release on Jun 29, 2026No releases on Jul 6, 20261 release on Jul 13, 2026No releases on Jul 20, 20261 release on Jul 27, 2026No releases on Aug 3, 2026No releases on Aug 10, 2026No releases on Aug 17, 2026No releases on Aug 24, 2026No releases on Aug 31, 2026No releases on Sep 7, 2026No releases on Sep 14, 2026No releases on Sep 21, 2026No releases on Sep 28, 2026No releases on Oct 5, 2026No releases on Oct 12, 2026
TuesdayNo releases on Jun 30, 2026No releases on Jul 7, 2026No releases on Jul 14, 2026No releases on Jul 21, 2026No releases on Jul 28, 2026No releases on Aug 4, 20261 release on Aug 11, 2026No releases on Aug 18, 2026No releases on Aug 25, 2026No releases on Sep 1, 2026No releases on Sep 8, 2026No releases on Sep 15, 2026No releases on Sep 22, 2026No releases on Sep 29, 2026No releases on Oct 6, 2026No releases on Oct 13, 2026
WednesdayNo releases on Jul 1, 2026No releases on Jul 8, 2026No releases on Jul 15, 2026No releases on Jul 22, 2026No releases on Jul 29, 2026No releases on Aug 5, 2026No releases on Aug 12, 2026No releases on Aug 19, 2026No releases on Aug 26, 2026No releases on Sep 2, 2026No releases on Sep 9, 2026No releases on Sep 16, 2026No releases on Sep 23, 2026No releases on Sep 30, 2026No releases on Oct 7, 2026No releases on Oct 14, 2026
ThursdayNo releases on Jul 2, 2026No releases on Jul 9, 2026No releases on Jul 16, 2026No releases on Jul 23, 2026No releases on Jul 30, 2026No releases on Aug 6, 20261 release on Aug 13, 2026No releases on Aug 20, 2026No releases on Aug 27, 2026No releases on Sep 3, 20261 release on Sep 10, 2026No releases on Sep 17, 20261 release on Sep 24, 2026No releases on Oct 1, 2026No releases on Oct 8, 2026No releases on Oct 15, 2026
FridayNo releases on Jul 3, 2026No releases on Jul 10, 2026No releases on Jul 17, 2026No releases on Jul 24, 2026No releases on Jul 31, 20261 release on Aug 7, 2026No releases on Aug 14, 20261 release on Aug 21, 2026No releases on Aug 28, 2026No releases on Sep 4, 20261 release on Sep 11, 2026No releases on Sep 18, 2026No releases on Sep 25, 2026No releases on Oct 2, 2026No releases on Oct 9, 2026No releases on Oct 16, 2026
SaturdayNo releases on Jul 4, 2026No releases on Jul 11, 2026No releases on Jul 18, 2026No releases on Jul 25, 2026No releases on Aug 1, 2026No releases on Aug 8, 2026No releases on Aug 15, 2026No releases on Aug 22, 2026No releases on Aug 29, 2026No releases on Sep 5, 2026No releases on Sep 12, 2026No releases on Sep 19, 2026No releases on Sep 26, 2026No releases on Oct 3, 2026No releases on Oct 10, 2026

16 releases since Apr 3, 2026

Changelog

What changed from 14 to 16
Filter releases by branch
16 of 16 releases

v16.4

Latest
Fixed 2
  • Fix response on root endpoint when schema name is in mixed case
  • Fix config jwt-cache-max-entries not loaded from the database

From PostgREST

Changes
  • Fix response on root endpoint when schema name is in mixed case by @taimoorzaeem in #5158
  • Fix config jwt-cache-max-entries not loaded from the database by @mkleczek in #5269
View originalPermalink
How v16.4 went

v16.3

Fixed 2
  • Fix sporadic PGRST303 JWT issued at future errors
  • Fix wrong time appearing on logs after long idle periods
View originalRead the notes
How v16.3 went

v14.18

Fixed 2
  • Fix sporadic PGRST303 JWT issued at future errors
  • Fix wrong time appearing on logs after long idle periods
View originalRead the notes
How v14.18 went

v16.2

Added 2
  • Make jwt-role-claim-key config backwards compatible
  • Add deprecation policy documentation
Deprecated 1
  • The old (pre-v16) syntax for JSPath in jwt-role-claim-key is deprecated, with warnings logged when old syntax is used
View originalRead the notes
How v16.2 went

v14.17

Fixed 1
  • JWT validation now uses the correct current time, fixing a bug in auto-update
View originalRead the notes
How v14.17 went

v16.1

Fixed 1
  • JWT validation uses correct current time, fixing a bug in auto-update
View originalRead the notes
How v16.1 went

v16.0

Added 8
  • Add graceful shutdown support to the HTTP server
  • Add server-reuseport configuration option to allow starting multiple PostgREST instances using the same port on supported platforms
  • Add Prefer: timezone support for numeric offsets like 05:00 or -4
  • Add Vary header to responses
  • Add GHC runtime metrics to observability
  • Add client-error-verbosity configuration option to customize response error verbosity
  • Add admin-server-unix-socket and admin-server-unix-socket-mode configuration options to run the admin server on a unix socket
  • Publish docker images to Github Container Registry in addition to Docker Hub
Changed 7
  • Optimize schema cache domain type resolution by using pg_basetype on PostgreSQL 17+
  • Prefer: count=exact no longer does a double count on requests that do not use ranges or db-max-rows
  • Prefer: timezone no longer requires the schema cache
  • JWT Role Extraction now supports the standard JSON Path defined in RFC 9535
  • Make aarch64-linux executable static instead of Ubuntu-based
  • Build docker image for aarch64-linux from scratch instead of being Ubuntu-based
  • log-level configuration is now reloadable
Fixed 5
  • Fix unexpected results when embedding and filtering the same table more than once
  • Fix automatic transaction retries on 40001 serialization_failure errors to prevent replication lag
  • Fix responding with Something went wrong on Admin server when under EMFILE
  • Fix requests failing when the schema cache fails to reload by continuing to serve requests in best effort mode
  • Fix reporting 503 errors unnecessarily while the schema cache is loading at startup
Removed 1
  • Drop support for PostgreSQL 13 which reached end of life
Deprecated 1
  • Deprecate filters, orders and limits with the name of an embedded table when it has an alias
View originalRead the notes
How v16.0 went

v14.16

Fixed 1
  • Fix admin server crashing without a way to recover
View originalRead the notes
How v14.16 went

v14.14

Fixed 1
  • Fix admin server not logging cause of failure
View originalRead the notes
How v14.14 went

v14.13

Fixed 2
  • Remove redundant "Retrying the connection." from PGRST000 error message because it is logged separately
  • Fix request failures when work_mem is set on a role
View originalRead the notes
How v14.13 went

v14.12

Fixed 1
  • Fix race condition in pool_available metric causing negative values during network instability
View originalRead the notes
How v14.12 went

v14.11

Fixed 4
  • Fix login with uppercase and mixed case role names
  • Restore Listener query shape so it can be found in pg_stat_activity
  • The LISTEN channel now automatically recovers when it stops working due to a PostgreSQL bug
  • Fix misleading "Functions" name on schema cache summary in startup logs
View originalRead the notes
How v14.11 went

v14.10

Added 1
  • Log when the pool is released during schema cache reload on log-level=debug
Fixed 1
  • Fix unnecessary connection pool flushes during schema cache reloading
View originalRead the notes
How v14.10 went

v14.9

Added 1
  • Log host, port and pg version of listener database connection
Fixed 1
  • Remove red herring warp logs on default log-level, only emit them on log-level=debug
View originalRead the notes
How v14.9 went

v14.8

Added 1
  • Log a HINT when the LISTEN channel stops working due to a PostgreSQL bug
Fixed 1
  • Fix invalid OpenAPI 2.0 format for integer types (smallint, integer, bigint)
View originalRead the notes
How v14.8 went
View all

Discussion

If you publish PostgREST, you can claim this product by proving you administer its repository.