All news with #postgresql tag

AWS DMS Schema Conversion Adds SAP ASE to PostgreSQL

🤖 AWS Database Migration Service (DMS) Schema Conversion now supports conversions from SAP Adaptive Server Enterprise (ASE) to both Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. The integrated generative AI capability helps automatically translate complex database code such as stored procedures, functions, triggers, cursors, and other ASE-specific constructs that traditionally require manual conversion. Schema Conversion also provides detailed assessment reports to help migration teams plan, estimate effort, and reduce risk when executing migrations to PostgreSQL-compatible managed databases on AWS.

Amazon RDS for PostgreSQL: New Minor Versions Available

🐘 Amazon RDS for PostgreSQL now supports minor versions 17.7, 16.11, 15.15, 14.20, and 13.23; AWS recommends upgrading to address known security vulnerabilities and receive community bug fixes. The release adds the pgcollection extension for RDS PostgreSQL 15.15 and above (including 16.11 and 17.7), providing an ordered, efficient key-value collection type usable inside PostgreSQL functions to speed in-memory data processing. Extension updates include pg_tle 1.5.2 and H3_PG 4.2.3, and operators can use automatic minor version upgrades or Blue/Green deployments to minimize disruption during upgrades.

Gemini CLI Brings Natural Language to PostgreSQL Workflows

🔎 The Gemini CLI extension for PostgreSQL brings natural-language queries and command-line convenience directly to database tasks. It can detect required tools (for example, pg_trgm for fuzzy search), check whether they are installed and install them automatically, and suggest performance improvements such as creating GIN or GIST indexes. The extension also generates schema-derived code snippets and supports lifecycle actions like creating instances, users, and permissions, streamlining development workflows.

Amazon RDS for PostgreSQL Extended Support Updates

🔒 Amazon RDS for PostgreSQL now provides Extended Support minor versions 12.22-rds.20250814 and 11.22-rds.20250814, delivering critical security patches and bug fixes for affected instances. We recommend upgrading RDS instances to these releases to maintain security and performance. Extended Support offers up to three years of additional fixes after community support ends. Use automatic minor upgrades or RDS Blue/Green deployments to apply updates during maintenance windows.

Amazon RDS: PostgreSQL 18.0 Available in Public Preview

🆕 Amazon RDS for PostgreSQL 18.0 is now available in the RDS Database Preview Environment, enabling evaluation of new PostgreSQL capabilities within a fully managed sandbox. PostgreSQL 18.0 introduces multicolumn B-tree skip scan, improved WHERE handling for OR/IN conditions, parallel GIN builds, updated join behavior, and UUIDv7 support. The preview preserves instances for up to 60 days, restricts snapshots to the preview environment, and supports database import/export via dump/load; pricing follows the US East (Ohio) Region.

AlloyDB on Axion C4A Instances Reaches General Availability

🚀 AlloyDB on Axion-powered C4A virtual machines is now generally available. AlloyDB on C4A offers substantial efficiency gains—up to 45% better price-performance versus N‑series VMs and up to 2× higher throughput versus Amazon Aurora on Graviton4—targeting transactional and data‑intensive workloads. C4A supports shapes from 1 to 72 vCPUs (including a new 48‑vCPU option and a cost‑effective 1‑vCPU/8GB shape for dev/sandbox). Deploy or upgrade C4A instances via the AlloyDB console in supported regions.

Aurora PostgreSQL Limitless Now Supports PostgreSQL 16.9

🚀 Amazon Aurora PostgreSQL Limitless Database now supports PostgreSQL 16.9 compatibility. This release delivers PostgreSQL community bug fixes and performance improvements along with Aurora-specific additions, including support for the hstore and auto_explain extensions. The serverless, distributed engine transparently scales compute and queries across multiple Aurora Serverless instances while preserving single-database transactional consistency, distributed query planning, and transaction management. Available across multiple AWS regions; review the documentation and pricing for details.

Amazon RDS: PostgreSQL 18 RC1 in Preview Environment

🆕 Amazon RDS for PostgreSQL 18 Release Candidate 1 (RC1) is now available in the Amazon RDS Database Preview Environment, letting customers evaluate a fully managed pre-release. PostgreSQL 18 adds skip scan support for multicolumn B-tree indexes, parallel GIN index builds, improved OR/IN WHERE handling, and updated join behavior. Observability enhancements expose buffer usage counts, index lookup details during execution, and a per-connection I/O utilization metric. Preview instances are retained for up to 60 days, snapshots remain usable only within the preview, and pricing follows the US East (Ohio) region.

Amazon RDS for PostgreSQL Adds Delayed Read Replicas

🕒 Amazon RDS for PostgreSQL now supports delayed read replicas, allowing you to specify a minimum time period for a replica to intentionally lag behind its source. This configurable time buffer helps protect against human errors such as accidental table drops or unwanted data modifications by preserving a recoverable replica state. In recovery workflows you can pause replication before problematic changes are applied, resume replication to a specific log position, and promote the replica as the new primary to achieve faster recovery than lengthy point-in-time restores.