PostgreSQL 19 Beta 1 is now available in Amazon RDS Database Preview Environment

Amazon Web Services has made PostgreSQL 19 Beta 1 available in its RDS Database Preview Environment, giving developers and database administrators early access to test the upcoming major release of the open-source database system. The beta introduces several significant technical enhancements, including native graph query support through SQL Property Graph Queries (SQL/PGQ), which allows users to perform complex relationship traversals directly in standard SQL without requiring separate application logic or data synchronization across multiple databases. The release also brings operational improvements for production environments, particularly concurrent table repacking that enables storage reclamation and table rebuilds while maintaining database accessibility during maintenance operations. Additionally, PostgreSQL 19 enhances logical replication by automatically synchronizing sequence values to replicas and enabling dynamic activation without server restarts, addressing common pain points during major version upgrades and reducing planned downtime. The preview environment operates under AWS's standard testing constraints, with database instances automatically deleted after 60 days and snapshots limited to the preview environment. Organizations can use PostgreSQL's native dump and load functionality to migrate data in and out of the preview environment for testing purposes.