postgres/postgres: REL_18_6
Stamp 18.6.
Topic · Edition
PostgreSQL
Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock
Oracle Database 26ai is now available on Amazon RDS for Oracle, bringing generative AI, vector search, and machine learning into the engine. In this post, part 1 of a three-part series, learn how to set up Select AI to…
Enforcing TLS and managing certificate rotation for RDS and Amazon Aurora PostgreSQL
When an Amazon RDS or Amazon Aurora PostgreSQL certificate expires and client trust stores aren't updated, connections fail without warning. This post shows how to enforce TLS for all PostgreSQL connections, configure…
Migrate RDS and Aurora logs to CloudWatch Infrequent Access
Organizations running Amazon RDS and Amazon Aurora often pay full CloudWatch Logs ingestion rates for database logs they rarely access. This post shows how to build an automated, tag-driven solution that migrates RDS…
Building search experiences for JSON data with Amazon OpenSearch Service
In this post, you learn how to use Amazon OpenSearch Service as a discovery layer that combines full-text, vector, and geospatial search across JSON documents in a single query, using a restaurant discovery app as a…
supabase/postgres: 17.9.0.014-orioledb-test-3
feat: Bump admin-api to 0.114.0 admin-api 0.114.0 contains optimized orioledb config feature according to the worksheet https://linear.app/supabase/issue/ORI-119/orioledb-variable-guc-settings-depending-on-ec2-size
supabase/postgres: 17.9.0.014-orioledb-test-3-x86
feat: Bump admin-api to 0.114.0 admin-api 0.114.0 contains optimized orioledb config feature according to the worksheet https://linear.app/supabase/issue/ORI-119/orioledb-variable-guc-settings-depending-on-ec2-size
supabase/postgres: 17.9.0.013-orioledb-mmlb-for-tests-x86
No content.
Dimitri Fontaine: Introducing sqlfmt: an SQL gofmt-style formatter
Formatting SQL tends to bring some of the same questions again and again: should we uppercase clause keywords? should we put the separating comma at the start of a line to ease refactoring? how to align the SQL clauses…
Tudor Golubenco: Multi-tenant BYOK encryption in PostgreSQL with pgcrypto
Implement multi-tenant BYOK column encryption in PostgreSQL with pgcrypto using customer-managed encryption keys.
supabase/supabase: self-hosted/v0.8.0
Self-hosted Supabase v0.8.0: Envoy is the default API gateway (breaki…
Wellingtone Luvonga: Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO
You have probably read a dozen tutorials on setting up PostgreSQL High Availability (HA). On paper, it looks simple: spin up a primary instance, spin up a standby, and let them replicate. But what happens when you move…
Christophe Pettus: All Your GUCs in a Row: IntervalStyle
IntervalStyle changes how PostgreSQL parses interval input, not just formats output—and in one case, it silently flips the sign of your data.