# PostgreSQL

Published articles for PostgreSQL.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Write End-to-End Tests in Your Backend's Language

DevFeed: [Write End-to-End Tests in Your Backend's Language](<https://devfeed.tech/articles/write-end-to-end-tests-in-your-backend-s-language-41361.md>)

Original publisher: [Read original article](<https://spin.atomicobject.com/write-end-to-end-tests-in-your-backends-language/>)

Author: James McConkey

Published: 2026-09-17T12:00:42Z

Content type: tutorial

Language: en

Sources: [Atomic Object](<https://devfeed.tech/sources/atomic-object.md>)

Topics: [Testing](<https://devfeed.tech/topics/testing.md>), [Playwright](<https://devfeed.tech/topics/playwright.md>), [FastAPI](<https://devfeed.tech/topics/fastapi.md>), [Python](<https://devfeed.tech/topics/python.md>), [test data](<https://devfeed.tech/topics/test-data.md>), [Pydantic](<https://devfeed.tech/topics/pydantic.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [ASP.NET Core](<https://devfeed.tech/topics/asp-net-core.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>)

Tags: [asp-net-core](<https://devfeed.tech/tags/asp-net-core.md>), [code](<https://devfeed.tech/tags/code.md>), [data](<https://devfeed.tech/tags/data.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [fastapi](<https://devfeed.tech/tags/fastapi.md>), [playwright](<https://devfeed.tech/tags/playwright.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [project-team-management](<https://devfeed.tech/tags/project-team-management.md>), [python](<https://devfeed.tech/tags/python.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>), [tests](<https://devfeed.tech/tags/tests.md>), [the-software-life](<https://devfeed.tech/tags/the-software-life.md>)

### AI overview

This article argues that end-to-end test-data setup is often the main design challenge, because tests must create consistent domain records while running alongside other tests. It recommends using browser-testing tools in the backend's language when possible, keeping meaningful relationships inline, and extracting small creation helpers without hiding scenario intent.

### Source excerpt

The browser is often the easiest part of an end-to-end test. Consider a test that verifies a user can complete an overdue task. The visible interaction is small: sign in, find the task, click Complete, and observe the new status. Before any of that can happen, the test needs a workspace, a user, a project, and [...] The post Write End-to-End Tests in Your Backend's Language appeared first on Atomic Spin.

## pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?

DevFeed: [pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?](<https://devfeed.tech/articles/pgbackrest-compression-how-much-cpu-is-a-smaller-backup-worth-35042.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/pgbackrest-compression-how-much-cpu-is-a-smaller-backup-worth/>)

Author: Agustín Gallego

Published: 2026-09-16T21:43:06Z

Content type: comparison

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Compression](<https://devfeed.tech/topics/compression.md>), [Algorithms](<https://devfeed.tech/topics/algorithms.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [algorithms](<https://devfeed.tech/tags/algorithms.md>), [backup](<https://devfeed.tech/tags/backup.md>), [compare](<https://devfeed.tech/tags/compare.md>), [compression](<https://devfeed.tech/tags/compression.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [percona](<https://devfeed.tech/tags/percona.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

This comparison measures pgBackRest compression algorithms and levels on Percona Distribution for PostgreSQL 18.4. It finds that low-level Zstandard offers a favorable balance between CPU use and backup size, with zst(3) near the efficiency curve's shoulder.

### Source excerpt

In this blog post, we'll compare pgBackRest's compression algorithms and levels to find where spending more CPU stops buying a meaningfully smaller backup. The short version of the answer, which we'll build up to with real numbers, is that Zstandard at a low level is the sweet spot, and its default (zst(3)) already sits right ... Continued The post pgBackRest Compression: How Much CPU Is a Smaller Backup Worth? appeared first on Percona.

## Running OpenBao on Kubernetes with a CloudNativePG PostgreSQL backend

DevFeed: [Running OpenBao on Kubernetes with a CloudNativePG PostgreSQL backend](<https://devfeed.tech/articles/running-openbao-on-kubernetes-with-a-cloudnativepg-postgresql-backend-30887.md>)

Original publisher: [Read original article](<https://www.cncf.io/blog/2026/09/16/running-openbao-on-kubernetes-with-a-cloudnativepg-postgresql-backend/>)

Author: Gabriele Bartolini (EnterpriseDB) and CNCF Ambassador, Rob Kenefeck (ControlPlane)

Published: 2026-09-16T11:30:00Z

Content type: tutorial

Language: en

Sources: [Cloud Native Computing Foundation](<https://devfeed.tech/sources/cloud-native-computing-foundation.md>)

Topics: [CloudNativePG](<https://devfeed.tech/topics/cloudnativepg.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [vendor lock-in](<https://devfeed.tech/topics/vendor-lock-in.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [cloudnativepg](<https://devfeed.tech/tags/cloudnativepg.md>), [docker](<https://devfeed.tech/tags/docker.md>), [hashicorp-vault](<https://devfeed.tech/tags/hashicorp-vault.md>), [helm](<https://devfeed.tech/tags/helm.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [linux-foundation](<https://devfeed.tech/tags/linux-foundation.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [secrets](<https://devfeed.tech/tags/secrets.md>), [vendor-lock-in](<https://devfeed.tech/tags/vendor-lock-in.md>)

### AI overview

A tutorial describes deploying OpenBao on Kubernetes with a three-instance CloudNativePG PostgreSQL cluster as its storage backend. It explains certificate-based authentication and a local Kind-based test environment.

### Source excerpt

Managing infrastructure secrets on Kubernetes needs a backend that is self-healing and free of vendor lock-in, and that is exactly what OpenBao (the Linux Foundation's open-source fork of HashiCorp Vault) and CloudNativePG give you: an entirely...

## pgAssistant 3.8.0 : continuous improvement loop for Postgres

DevFeed: [pgAssistant 3.8.0 : continuous improvement loop for Postgres](<https://devfeed.tech/articles/pgassistant-3-8-0-continuous-improvement-loop-for-postgres-30889.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgassistant-380-continuous-improvement-loop-for-postgres-3378/>)

Author: Pgassistant Dev Team

Published: 2026-09-16T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [recommendations](<https://devfeed.tech/topics/recommendations.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [real-time](<https://devfeed.tech/topics/real-time.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [measurements](<https://devfeed.tech/tags/measurements.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [recommendations](<https://devfeed.tech/tags/recommendations.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

pgAssistant 3.8.0 expands the PostgreSQL analysis and tuning tool into a continuous improvement platform. It adds historical workload and environment measurements, compares consecutive collections, tracks recommendations and configuration changes, and helps teams measure changes while distinguishing correlation from causation.

### Source excerpt

With this release, pgAssistant is evolving beyond PostgreSQL analysis and tuning to become a continuous PostgreSQL improvement platform. The new positioning is built around a continuous improvement loop: Observe -> Diagnose -> Prioritize -> Plan -> Implement -> Collect again -> Measure pgAssistant already helped identify what should be improved and turn recommendations into a prioritized Executive Plan with clear DEV and OPS ownership. Combined with pgAssistant Collector, version 3.8.0 goes further by adding historical workload and environment measurements. The objective is to answer four essential questions: What should we improve? What did we decide to do? What did we actually change? What was the result? Workload Insights compares consecutive collections and highlights: new and no-longer-detected recommendations; changes to the PostgreSQL version and configuration; workload evolution by statement type; changes in execution time and call volume; the queries with the greatest impact on the overall workload. The ambition is to correlate the application of pgAssistant recommendations and the Executive Plan with observed performance changes. Correlation is not causation, and a recommendation that is no longer detected does not necessarily prove that it was implemented. pgAssistant keeps these distinctions explicit while bringing the relevant evidence together in one place. pgAssistant is not intended to replace real-time monitoring. Monitoring shows what is happening now; pgAssistant helps teams decide what to improve next, organize the remediation work, and measure what changed afterwards. From recommendations to action--and from action to measurable evidence. pgAssistant 3.8.0: https://github.com/beh74/pgassistant-community pgAssistant Collector: https://github.com/beh74/pgassistant-collector pgAssistant Grafana : https://github.com/beh74/pgassistant-grafana

## Plan Advice in PostgreSQL 19

DevFeed: [Plan Advice in PostgreSQL 19](<https://devfeed.tech/articles/plan-advice-in-postgresql-19-34622.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2026/09/plan-advice-in-postgresql-19/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2026-09-15T16:27:53Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [version](<https://devfeed.tech/topics/version.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>)

Tags: [analyze](<https://devfeed.tech/tags/analyze.md>), [beta](<https://devfeed.tech/tags/beta.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [pg-plan-advice](<https://devfeed.tech/tags/pg-plan-advice.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

This tutorial explains PostgreSQL 19's pg_plan_advice and pg_stash_advice modules, which represent query-plan decisions as reusable advice and can apply that advice by query ID. It also describes reconstructing comparable plan advice from ordinary plan output on earlier PostgreSQL versions.

### Source excerpt

There is a conversation that happens in every PostgreSQL shop eventually. A query that has been fine for a year gets slow overnight. Nothing was deployed. The data grew a little, ANALYZE ran, and the planner -- entirely reasonably, on the numbers it had -- picked a different plan. The old plan was better. You would like it back. PostgreSQL 19 ships two new modules for exactly this: pg_plan_advice, which can read a plan back out as a string and enforce it later, and pg_stash_advice, which keeps those strings keyed by query id and applies them automatically. ▸ Every query below ran against the Lab, the free dataset bundle used throughout this blog, on PostgreSQL 19 Beta 3: POSTGRES_VERSION=19beta3 PG_MAJOR=19 docker compose up. Both modules are contrib, and the Lab image ships them; nothing below runs a LOAD to enable them, because the server already has them -- pg_plan_advice in session_preload_libraries, pg_stash_advice in shared_preload_libraries (it can survive a restart, which needs loading that way). One line each in postgresql.conf, or the equivalent server-start flag, and you're done. pg_stash_advice still needs its own CREATE EXTENSION, further down, for its SQL functions -- that's independent of how the module itself got loaded.

## Vondra: PostgreSQL development activity

DevFeed: [Vondra: PostgreSQL development activity](<https://devfeed.tech/articles/vondra-postgresql-development-activity-26597.md>)

Original publisher: [Read original article](<https://lwn.net/Articles/1094470/>)

Author: jzb

Published: 2026-09-15T13:20:30Z

Content type: news

Language: en

Sources: [LWN.net](<https://devfeed.tech/sources/lwn-net.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Development](<https://devfeed.tech/topics/development.md>)

Tags: [blog-post](<https://devfeed.tech/tags/blog-post.md>), [development](<https://devfeed.tech/tags/development.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

A PostgreSQL contributor's analysis examines development activity from the late 1990s to the present. It reports roughly 50 commits per week today, compared with about 25 per week around 2010, alongside an approximately twofold increase in active committers.

### Source excerpt

PostgreSQL contributor Tomas Vondra has published a blog post looking at development activity in the project, with data from the late 1990s to today. We're doing ~50 commits per week, give or take. In ~2010 we were doing maybe 25/week, and the trend seems to be a slow and consistent growth. The monthly average makes the trend a bit easier to spot. Which is good, although there's a lot of other important details (size of commits, are they new features or fixes, ...). It however nicely aligns with the number of active committers, which also grew ~2x between 2010 and today. So maybe that's working as expected.

## Kubernetes 1.36 restores a lost guarantee for database backups

DevFeed: [Kubernetes 1.36 restores a lost guarantee for database backups](<https://devfeed.tech/articles/kubernetes-1-36-restores-a-lost-guarantee-for-database-backups-26610.md>)

Original publisher: [Read original article](<https://thenewstack.io/kubernetes-volume-group-snapshots/>)

Author: Shubham Pampattiwar

Published: 2026-09-15T13:00:00Z

Content type: news

Language: en

Sources: [Kubernetes Overview, News and Trends | The New Stack](<https://devfeed.tech/sources/kubernetes-overview-news-and-trends-the-new-stack.md>), [The New Stack](<https://devfeed.tech/sources/the-new-stack.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [backups](<https://devfeed.tech/tags/backups.md>), [cncf](<https://devfeed.tech/tags/cncf.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [post-contributed](<https://devfeed.tech/tags/post-contributed.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [snapshots](<https://devfeed.tech/tags/snapshots.md>), [sponsor-cncf](<https://devfeed.tech/tags/sponsor-cncf.md>), [sponsored-post-contributed](<https://devfeed.tech/tags/sponsored-post-contributed.md>), [stateful](<https://devfeed.tech/tags/stateful.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

The article explains how Kubernetes 1.36 restores coordinated snapshots for applications whose state spans multiple volumes, addressing inconsistent database backups caused by taking individual PersistentVolumeClaim snapshots at different times.

### Source excerpt

It's 2 a.m., and you're restoring a PostgreSQL cluster from last night's backup. Its data directory lives on one PersistentVolumeClaim The post Kubernetes 1.36 restores a lost guarantee for database backups appeared first on The New Stack.

## PostgreSQL 19 graph queries fail the 'would you ship this?' test

DevFeed: [PostgreSQL 19 graph queries fail the 'would you ship this?' test](<https://devfeed.tech/articles/postgresql-19-graph-queries-fail-the-would-you-ship-this-test-26619.md>)

Original publisher: [Read original article](<https://www.theregister.com/databases/2026/09/15/postgresql-19-graph-queries-fail-the-would-you-ship-this-test/5296343>)

Author: Lindsay Clark

Published: 2026-09-15T09:42:59Z

Content type: news

Language: en

Sources: [www.theregister.com - Articles](<https://devfeed.tech/sources/www-theregister-com-articles.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Graphs](<https://devfeed.tech/topics/graphs.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [bugs](<https://devfeed.tech/tags/bugs.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [databases](<https://devfeed.tech/tags/databases.md>), [graph](<https://devfeed.tech/tags/graph.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

The article reports that PostgreSQL 19's SQL/PGQ graph queries were rejected because of unresolved bugs. It also discusses concurrent REPACK as a way to reduce overnight maintenance calls for database administrators.

### Source excerpt

SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs

## What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog

DevFeed: [What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog](<https://devfeed.tech/articles/what-s-new-in-cypex-v2-0-0-tenancy-moves-from-the-query-to-the-catalog-26241.md>)

Original publisher: [Read original article](<https://www.cybertec-postgresql.com/en/whats-new-in-cypex-v2-0-0-tenancy-moves-from-the-query-to-the-catalog/>)

Author: Svitlana Lytvynenko

Published: 2026-09-15T06:06:05Z

Content type: article

Language: en

Sources: [CYBERTEC PostgreSQL | Services & Support](<https://devfeed.tech/sources/cybertec-postgresql-services-support.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [tenant data protection](<https://devfeed.tech/topics/tenant-data-protection.md>), [Security](<https://devfeed.tech/topics/security.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [cypex](<https://devfeed.tech/tags/cypex.md>), [data-protection](<https://devfeed.tech/tags/data-protection.md>), [database](<https://devfeed.tech/tags/database.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [news](<https://devfeed.tech/tags/news.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [product](<https://devfeed.tech/tags/product.md>), [schema](<https://devfeed.tech/tags/schema.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

CYPEX 2.0.0 moves tenant isolation from application-level query filters into PostgreSQL row-level security policies stored in the database catalog. The policies use JWT claims to apply organization-specific access rules to every connection and query.

### Source excerpt

This blog highlights the details of CYPEX 2.0, with each feature being explained in detail. Read to know more. The post What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog appeared first on CYBERTEC PostgreSQL | Services & Support.

## Appwrite Init 2026 recap: Everything we shipped

DevFeed: [Appwrite Init 2026 recap: Everything we shipped](<https://devfeed.tech/articles/appwrite-init-2026-recap-everything-we-shipped-26795.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/appwrite-init-2026-recap>)

Author: Aishwari Pahwa

Published: 2026-09-15T00:00:00Z

Content type: release

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [releases](<https://devfeed.tech/topics/releases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Firewall](<https://devfeed.tech/topics/firewall.md>), [OAuth 2.0](<https://devfeed.tech/topics/oauth2.md>), [Self-hosted](<https://devfeed.tech/topics/self-hosted.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [firewall](<https://devfeed.tech/tags/firewall.md>), [init](<https://devfeed.tech/tags/init.md>), [oauth2](<https://devfeed.tech/tags/oauth2.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [recap](<https://devfeed.tech/tags/recap.md>), [release](<https://devfeed.tech/tags/release.md>), [releases](<https://devfeed.tech/tags/releases.md>), [s3](<https://devfeed.tech/tags/s3.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>)

### AI overview

An Appwrite Init 2026 recap covering five days of launches, including Appwrite 2.0, a redesigned Console, native PostgreSQL, VectorsDB, DocumentsDB, MySQL, S3-compatible Storage, Firewall, OAuth2, and Domains.

### Source excerpt

An Appwrite Init 2026 recap of all five days of launches, from Appwrite 2.0 and native PostgreSQL to VectorsDB, S3 support, Firewall, OAuth2, and Domains.

## What Managed Postgres Services Handle for Teams

DevFeed: [What Managed Postgres Services Handle for Teams](<https://devfeed.tech/articles/managed-postgres-what-lakebase-actually-takes-off-your-plate-26721.md>)

Original publisher: [Read original article](<https://www.databricks.com/blog/managed-postgres>)

Author: Databricks Staff

Published: 2026-09-14T23:36:59Z

Content type: article

Language: en

Sources: [Databricks](<https://devfeed.tech/sources/databricks.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [databricks](<https://devfeed.tech/topics/databricks.md>), [AI Development](<https://devfeed.tech/topics/ai-development.md>)

Tags: [data-plus-ai-foundations](<https://devfeed.tech/tags/data-plus-ai-foundations.md>), [database](<https://devfeed.tech/tags/database.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [developer-tooling](<https://devfeed.tech/tags/developer-tooling.md>), [migration](<https://devfeed.tech/tags/migration.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [security](<https://devfeed.tech/tags/security.md>), [serverless](<https://devfeed.tech/tags/serverless.md>)

### AI overview

The article defines managed Postgres by the operational responsibilities a provider assumes, including patching, scaling, failover, and backups. It discusses how these responsibilities can vary between providers and describes Lakebase Postgres as a serverless offering with automatic scaling, PostgreSQL compatibility, recovery, and Databricks integrations.

### Source excerpt

Every Postgres vendor calls itself "managed." Few of them agree on what that word...

## Percona and HexaCluster: Faster, Safer Oracle Migration

DevFeed: [Percona and HexaCluster: Faster, Safer Oracle Migration](<https://devfeed.tech/articles/percona-and-hexacluster-faster-safer-oracle-migration-26240.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-and-hexacluster-faster-safer-oracle-migration/>)

Author: Percona Team

Published: 2026-09-14T22:19:16Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Tooling](<https://devfeed.tech/topics/tooling.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [migration](<https://devfeed.tech/tags/migration.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [partners](<https://devfeed.tech/tags/partners.md>), [percona](<https://devfeed.tech/tags/percona.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [tooling](<https://devfeed.tech/tags/tooling.md>), [validation](<https://devfeed.tech/tags/validation.md>)

### AI overview

Percona and HexaCluster describe a partnership for moving organizations from Oracle, SQL Server, DB2, and Sybase ASE to supported open source databases, primarily PostgreSQL. HexaCluster provides assessment and migration engineering through DMAT and HexaRocket, while Percona provides distributions, operators, and long-term support. HexaRocket combines schema migration, data migration, validation, change data capture, live replication, and reverse replication in one platform.

### Source excerpt

Percona and HexaCluster have partnered to remove the hardest part of an open source database migration: getting off Oracle, SQL Server, DB2 or Sybase ASE with confidence, on a predictable timeline, without a multi-year consulting program. Percona brings open source expertise, its own distributions, operators and enterprise support. HexaCluster brings the assessment and migration engineering ... Continued The post Percona and HexaCluster: Faster, Safer Oracle Migration appeared first on Percona.

## Intelligence is yours. Let's keep it that way.

DevFeed: [Intelligence is yours. Let's keep it that way.](<https://devfeed.tech/articles/intelligence-is-yours-let-s-keep-it-that-way-19892.md>)

Original publisher: [Read original article](<https://www.digitalocean.com/blog/intelligence-is-yours>)

Author: Paddy Srinivasan

Published: 2026-09-14T21:11:13Z

Content type: opinion

Language: en

Sources: [DigitalOcean](<https://devfeed.tech/sources/digitalocean.md>)

Topics: [Open Source](<https://devfeed.tech/topics/open-source.md>), [Software](<https://devfeed.tech/topics/software.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [React](<https://devfeed.tech/topics/react.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [competition](<https://devfeed.tech/tags/competition.md>), [github](<https://devfeed.tech/tags/github.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [intellectual-property](<https://devfeed.tech/tags/intellectual-property.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [models](<https://devfeed.tech/tags/models.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [news](<https://devfeed.tech/tags/news.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [opencode](<https://devfeed.tech/tags/opencode.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [react](<https://devfeed.tech/tags/react.md>)

### AI overview

The article argues that founders should retain ownership and control of their companies' intelligence rather than depend on a single intelligence provider. It advocates an Open Intelligence movement built from open-source models, agents, harnesses, data technologies, and infrastructure, drawing comparisons with the adoption of Linux, PostgreSQL, MySQL, Kubernetes, and other open technologies.

### Source excerpt

Intelligence was yours. A founder's intellectual property, business logic, differentiation, their intelligence, was once theirs alone. You built it, you owned it, and no tools/platform vendor stood between you and your customers. This is no longer clear. It is starting to look like it is "theirs." Intelligence can now be manufactured: the models, the agents and the harnesses that drive them, and the compute they run on. Providers who own all these can produce the application, and the differentiation, in every industry. That power runs the risk of becoming increasingly concentrated in a handful of companies. The race for the application layer is not about interfaces or go-to-market; it is a fight over who owns the intelligence layer itself. We have seen this before but we must act before its too late. Linux started behind Unix and Windows and now runs most of the world's servers. PostgreSQL and MySQL started behind Oracle and now underpin most new software. Kubernetes arrived after proprietary orchestrators and made them irrelevant. Each began less capable and won anyway: builders could see inside it, run it anywhere, and never had to ask permission. The same is happening now. Open weight models have repeatedly reached the frontier this past year. Open harnesses like OpenCode have grown to tens of trillions of tokens a day. Hermes reached more than 200,000 GitHub stars in five months, a milestone that took React a decade to achieve. Along with the near total adoption of open source data technologies, this collection of open technologies power an Open Intelligence movement. Open Intelligence restores the order. It returns to founders ownership of what makes their companies theirs. Founders should be free to build without tying their future to a single intelligence provider: their choice of agents, harnesses, data technologies, models, and infrastructure, with open source transparency, control, and competition keeping every layer honest. The stakes go beyond business.

## Resolve Amazon Aurora PostgreSQL lock contention with Database Insights: Part 2

DevFeed: [Resolve Amazon Aurora PostgreSQL lock contention with Database Insights: Part 2](<https://devfeed.tech/articles/resolve-amazon-aurora-postgresql-lock-contention-with-database-insights-part-2-20842.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/resolve-amazon-aurora-postgresql-lock-contention-with-database-insights-part-2/>)

Author: Sameer Kumar

Published: 2026-09-14T16:02:16Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Database](<https://devfeed.tech/topics/database.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [AWS CloudFormation](<https://devfeed.tech/topics/aws-cloudformation.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cloudformation](<https://devfeed.tech/tags/aws-cloudformation.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [simulation](<https://devfeed.tech/tags/simulation.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial explains how to diagnose and resolve lock contention in Amazon Aurora PostgreSQL using Amazon CloudWatch Database Insights. It demonstrates Lock Analysis and the Lock Tree visualization for identifying blocking sessions, then covers immediate fixes, configuration changes, optimistic concurrency control, asynchronous processing, SKIP LOCKED, and row splitting.

### Source excerpt

Part 1 showed how row lock contention degrades Amazon Aurora PostgreSQL throughput. In Part 2, use Amazon CloudWatch Database Insights and its Lock Tree to pinpoint blocking sessions, then resolve contention with query termination, timeout parameters, and architectural patterns such as SKIP LOCKED and row splitting that restore throughput.

## Troubleshooting row lock contention in Amazon Aurora PostgreSQL: Part 1 - Understanding row lock contention in PostgreSQL

DevFeed: [Troubleshooting row lock contention in Amazon Aurora PostgreSQL: Part 1 - Understanding row lock contention in PostgreSQL](<https://devfeed.tech/articles/troubleshooting-row-lock-contention-in-amazon-aurora-postgresql-part-1-understanding-row-lock-contention-in-postgresql-20843.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/troubleshooting-row-lock-contention-in-amazon-aurora-postgresql-part-1-understanding-row-lock-contention-in-postgresql/>)

Author: Sameer Kumar

Published: 2026-09-14T16:02:08Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Extension](<https://devfeed.tech/topics/extension.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [availability](<https://devfeed.tech/tags/availability.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database](<https://devfeed.tech/tags/database.md>), [database-performance](<https://devfeed.tech/tags/database-performance.md>), [extension](<https://devfeed.tech/tags/extension.md>), [locks](<https://devfeed.tech/tags/locks.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [production](<https://devfeed.tech/tags/production.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [troubleshooting](<https://devfeed.tech/tags/troubleshooting.md>)

### AI overview

This first part of a two-part series explains row lock contention in PostgreSQL and Amazon Aurora PostgreSQL. It covers how concurrent transactions competing for the same rows can reduce throughput and cause timeouts despite healthy CPU and I/O, then introduces PostgreSQL locking internals and monitoring techniques using system views, functions, the pgrowlocks extension, and log_lock_waits. The article notes that the same behavior and investigation approach apply to Amazon RDS for PostgreSQL.

### Source excerpt

Row lock contention can collapse database throughput during a flash sale even when CPU and I/O look healthy. In Part 1 of this series, learn how PostgreSQL row locking works and how to monitor lock contention in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using system views, the pgrowlocks extension, and the log_lock_waits parameter.

## PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum

DevFeed: [PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum](<https://devfeed.tech/articles/postgresql-monitoring-and-schema-linting-for-laravel-with-vacuum-22290.md>)

Original publisher: [Read original article](<https://laravel-news.com/vacuum-laravel-postgresql-monitoring>)

Author: Paul Redmond

Published: 2026-09-14T04:24:35Z

Content type: article

Language: en

Sources: [Laravel](<https://devfeed.tech/sources/laravel.md>)

Topics: [Laravel](<https://devfeed.tech/topics/laravel.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [ci](<https://devfeed.tech/topics/ci.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [ci](<https://devfeed.tech/tags/ci.md>), [github](<https://devfeed.tech/tags/github.md>), [laravel](<https://devfeed.tech/tags/laravel.md>), [laravel-packages](<https://devfeed.tech/tags/laravel-packages.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

Vacuum is a PostgreSQL monitoring and schema-linting package for Laravel. It analyzes PostgreSQL statistics, reports issues such as bloat, wraparound, dead tuples, unused indexes, slow statements, and unindexed foreign keys, and provides SQL remediation guidance, health scores, dashboards, CI commands, history, and explainers.

### Source excerpt

Vacuum checks PostgreSQL in Laravel apps for bloat, wraparound, and unused indexes, and flags unindexed foreign keys in migrations during CI. The post PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum appeared first on Laravel News. Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

## Encore for Python

DevFeed: [Encore for Python](<https://devfeed.tech/articles/encore-for-python-17794.md>)

Original publisher: [Read original article](<https://encore.dev/blog/encore-py>)

Author: Ivan Cernja

Published: 2026-09-14T00:00:00Z

Content type: article

Language: en

Sources: [Encore Updates](<https://devfeed.tech/sources/encore-updates.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [FastAPI](<https://devfeed.tech/topics/fastapi.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Terraform](<https://devfeed.tech/topics/terraform.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>)

Tags: [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [coding-agents](<https://devfeed.tech/tags/coding-agents.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [git](<https://devfeed.tech/tags/git.md>), [iam](<https://devfeed.tech/tags/iam.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

Encore is introducing Encore.py, an upcoming beta that brings Encore's type-safe infrastructure primitives to Python and works alongside frameworks such as FastAPI. The article describes how application-level resource declarations can drive infrastructure provisioning while platform teams retain control over environment-specific settings in AWS, GCP, Terraform, or existing infrastructure. It also highlights preview environments where coding agents can implement and verify features against infrastructure configured to resemble production.

### Source excerpt

An early look at Encore for Python, entering beta soon.

## How to Prevent Race Conditions in Django

DevFeed: [How to Prevent Race Conditions in Django](<https://devfeed.tech/articles/how-to-prevent-race-conditions-in-django-4340.md>)

Original publisher: [Read original article](<https://www.freecodecamp.org/news/how-to-prevent-race-conditions-in-django/>)

Author: Mari

Published: 2026-09-11T21:50:46Z

Content type: tutorial

Language: en

Sources: [freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More](<https://devfeed.tech/sources/freecodecamp-programming-tutorials-python-javascript-git-more.md>)

Topics: [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Database](<https://devfeed.tech/topics/database.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Docker](<https://devfeed.tech/topics/docker.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database](<https://devfeed.tech/tags/database.md>), [django](<https://devfeed.tech/tags/django.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [race-condition](<https://devfeed.tech/tags/race-condition.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

A Django tutorial that demonstrates a credit-spending race condition and explains how database transactions and row locks prevent concurrent requests from using the same credit.

### Source excerpt

Let's say you have enough credit left to generate one more image in an AI app. You submit a request in one browser tab, then submit another in a second tab before the first finishes. The app accepts b

## CERN PGDay 2027: Announcement and CfP

DevFeed: [CERN PGDay 2027: Announcement and CfP](<https://devfeed.tech/articles/cern-pgday-2027-announcement-and-cfp-4715.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/cern-pgday-2027-announcement-and-cfp-3375/>)

Author: Swiss PostgreSQL Users Group

Published: 2026-09-11T00:00:00Z

Content type: news

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [AI search](<https://devfeed.tech/topics/ai-search.md>), [Retrieval Augmented Generation (RAG)](<https://devfeed.tech/topics/retrieval-augmented-generation-rag.md>)

Tags: [announcement](<https://devfeed.tech/tags/announcement.md>), [community](<https://devfeed.tech/tags/community.md>), [conference](<https://devfeed.tech/tags/conference.md>), [database](<https://devfeed.tech/tags/database.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

CERN PGDay 2027 is an announcement and call for papers for a single-day PostgreSQL community conference at CERN in Geneva. Proposed talk themes include large-scale database performance, AI and vector-search workloads, security, and PostgreSQL extensibility.

### Source excerpt

CERN PGDay 2027 Date: Friday, February 12, 2027 Location: CERN Campus, Geneva, Switzerland / Suisse Romande Language: English Organizers: Swiss PostgreSQL Users Group (SwissPUG) & CERN Format: Single-track (6-7 sessions) followed by networking social event Homepage: swisspug.org/cern-pgday-2027 About the Event Continuing in the line of work of the past editions, CERN PGDay 2027 returns as the annual gathering for PostgreSQL users, developers, and enthusiasts across Suisse Romande (western Switzerland) and the neighboring French border regions. Co-organized by CERN and SwissPUG, this single-day community conference offers a premier opportunity to network, share practical experiences, and explore the future of the world's most advanced open-source database. The event takes place in the unique, international environment of Geneva--a hub for major scientific institutions, non-governmental organizations, and financial and tech enterprises. Format & Venue Single-Track Schedule: The program consists of a single track featuring 6 to 7 technical sessions presented entirely in English. Social Event & Networking: Following the technical presentations, a social event will take place to facilitate community networking, discussions, and collaboration in the inspiring atmosphere of CERN. CERN Visits: Attendees are encouraged to arrange their schedules before or after the event to take advantage of the conference location and visit CERN, the European Organization for Nuclear Research. Call for Papers (CfP) Speaker proposals for CERN PGDay 2027 can be entered online via Indico. Call for Papers Closes: November 8, 2026 (23:59 CET) Call for Sponsors (CfS) Sponsors proposals for CERN PGDay 2027 are welcome. Please find the contract with all details online. Key Themes We welcome talk proposals covering broader PostgreSQL and community trends and localized enterprise & scientific topics: High-Performance Science & Big Data: Managing massive datasets, extreme write throughput, partitioning

## \[$\] PostgreSQL 19's "scary patch contest"

DevFeed: [\[$\] PostgreSQL 19's "scary patch contest"](<https://devfeed.tech/articles/postgresql-19-s-scary-patch-contest-8492.md>)

Original publisher: [Read original article](<https://lwn.net/Articles/1092003/>)

Author: jzb

Published: 2026-09-10T17:29:06Z

Content type: news

Language: en

Sources: [LWN.net](<https://devfeed.tech/sources/lwn-net.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [patches](<https://devfeed.tech/topics/patches.md>), [Testing](<https://devfeed.tech/topics/testing.md>), [bug](<https://devfeed.tech/topics/bug.md>)

Tags: [beta](<https://devfeed.tech/tags/beta.md>), [bug](<https://devfeed.tech/tags/bug.md>), [patches](<https://devfeed.tech/tags/patches.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [stable](<https://devfeed.tech/tags/stable.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

The PostgreSQL 19 release faced concerns about the readiness of several patches after unusually many bug fixes and ongoing revisions. One patch was reverted, and an extra beta release was scheduled for additional testing.

### Source excerpt

PostgreSQL 19 was expected to be released in September, in keeping with the database project's longstanding tradition of a major release every year. However, some late-breaking concerns about several of the features slated for inclusion has some developers worried about the quality of the release. On August 25, PostgreSQL contributor Robert Haas sent an email with the subject "scary patch contest" about several patches that have required an unusually large number of bug fixes leading up to the release, which has raised questions about their readiness for a stable release. One of the patches has been reverted, but several are still under heavy revision, and an extra beta release has been slotted in to allow for additional testing.

## Kubernetes disaster recovery: Guidance from three reproducible failure scenarios

DevFeed: [Kubernetes disaster recovery: Guidance from three reproducible failure scenarios](<https://devfeed.tech/articles/kubernetes-disaster-recovery-guidance-from-three-reproducible-failure-scenarios-4602.md>)

Original publisher: [Read original article](<https://www.cncf.io/blog/2026/09/10/kubernetes-disaster-recovery-guidance-from-three-reproducible-failure-scenarios/>)

Author: Saiyam Pathak, Saloni Narang | CNCF Ambassadors

Published: 2026-09-10T11:37:00Z

Content type: article

Language: en

Sources: [Cloud Native Computing Foundation](<https://devfeed.tech/sources/cloud-native-computing-foundation.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [data](<https://devfeed.tech/topics/data.md>), [GitOps](<https://devfeed.tech/topics/gitops.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [data](<https://devfeed.tech/tags/data.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [git](<https://devfeed.tech/tags/git.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

Guidance for recovering stateful Kubernetes applications through three reproducible failure scenarios, focusing on backup validation, declared versus stored state, and multi-volume consistency.

### Source excerpt

Scope This document describes three failure scenarios that separate having backups from being able to recover, and the guidance that follows from each. Every scenario is reproducible on a laptop from the lab repository above, and...

## Contributing to OpenSRE and Integrating It with Yandex Cloud

DevFeed: [Contributing to OpenSRE and Integrating It with Yandex Cloud](<https://devfeed.tech/articles/350-24896.md>)

Original publisher: [Read original article](<https://habr.com/ru/companies/yandex/articles/1080524/>)

Author: nowhere\_in\_space (Яндекс, Yandex Cloud & Yandex Infrastructure)

Published: 2026-09-10T07:00:10Z

Content type: article

Language: ru

Sources: [Яндекс - Как мы делаем Яндекс / Статьи](<https://devfeed.tech/sources/source.md>)

Topics: [SRE](<https://devfeed.tech/topics/sre.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [ai-e2239b5ae8fa](<https://devfeed.tech/tags/ai-e2239b5ae8fa.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [llm](<https://devfeed.tech/tags/llm.md>), [opensre](<https://devfeed.tech/tags/opensre.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sre](<https://devfeed.tech/tags/sre.md>), [tag-831b63de9433](<https://devfeed.tech/tags/tag-831b63de9433.md>), [tag-e1321f9c36de](<https://devfeed.tech/tags/tag-e1321f9c36de.md>)

### AI overview

The author describes contributing to OpenSRE, an early public-alpha tool for AI SRE agents that investigate and resolve production incidents, and pursuing an integration with Yandex Cloud. The article cautions that OpenSRE's safety is not guaranteed and recommends running it without modifying permissions.

### Source excerpt

Представьте: ночной алерт, приложение отдаёт пятисотки, но само оно живо. Понятно, что дальше начнётся знакомое -- вкладки с графиками, поиски в логах и попытки понять, кто и что изменил. Сколько на это обычно уходит времени? А что, если вместе с вами в инциденте будет разбираться ИИ-агент? Привет! Я Антон Воронцов, CRE в Yandex Cloud. В конце июля я в очередной раз листал свежие репозитории на GitHub, чтобы посмотреть, что происходит в моих смежных дисциплинах: SRE, автоматизациях и, понятное дело, ИИ. Вдруг я наткнулся на один интересный репозиторий, который активно рос: количество звёзд, коммиты и заинтересованные люди из разных стран -- всё это про OpenSRE. Эта статья о том, как я впервые контрибьютил во внешний проект, что стало самым сложным и как вообще работает этот инструмент. Читать далее

## PostgreSQL Migrator 1.0 : first stable release

DevFeed: [PostgreSQL Migrator 1.0 : first stable release](<https://devfeed.tech/articles/postgresql-migrator-1-0-first-stable-release-4722.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-migrator-10-first-stable-release-3377/>)

Published: 2026-09-10T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [migration](<https://devfeed.tech/topics/migration.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [releases](<https://devfeed.tech/topics/releases.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [ci](<https://devfeed.tech/topics/ci.md>)

Tags: [ci](<https://devfeed.tech/tags/ci.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

PostgreSQL Migrator 1.0 is the first stable release of an open-source tool for migrating Oracle, MySQL, and MariaDB databases to PostgreSQL. It supports full inspection and limited conversion and migration for selected database objects, with compatibility promised across 1.x releases.

### Source excerpt

Paris, 7th september 2026. The Dalibo team is pleased to announce the release of PostgreSQL Migrator 1.0 stable, a free and open-source tool designed to help migrate databases from Oracle and MySQL/MariaDB to PostgreSQL. Key features Easy installation: pure Go binary with zero proprietary dependencies. Fast, offline inspection: Extract the full source catalog once, then iterate on conversion offline. Complexity scoring: Quickly assess and compare the difficulty of migration projects. Interactive web UI: Browse both the original and converted catalogs, search objects, and identify migration blockers. Schema and data conversion: Converts datatype and SQL expression, convert column to boolean. Code analysis and transpilation: Transpiles and analyzes SQL, PL/SQL and routines with the companion transqlate tool. High-performance data copy: Streamed bulk COPY to PostgreSQL (or to files / pipes), with low memory usage and significantly higher throughput than traditional tools in our tests. Hackable & configurable: Reliable JSON catalog data, TOML configuration, and templating for fine-tuning. Supported features PostgreSQL Migrator supports migrating from Oracle Database 11g to 26ai, MySQL 8.4+ and MariaDB 10+ to PostgreSQL 16 up to 19. Version 1.0 has full inspection including jobs, system triggers, etc. However, conversion and migration is limited to role, schema, sequences, table, virtual columns, constraints and indexes. The documentation describes implemented and planned features including views, procedural objects, SQL Server and more. Stability We have built a demanding CI pipeline including end-to-end tests based on Oracle Free container and cypress. This effectively prevents regression and ensure quality. After one year of beta and rc, PostgreSQL Migrator is stable. We'll ensure configuration, CLI and project compatibility for all 1.x releases. License and availability PostgreSQL Migrator is released under the PostgreSQL License. Documentation: https://postgresql-mi

## pg\_vault\_tde v1.7.1 : Transparent Data Encryption for PostgreSQL 17 and 18

DevFeed: [pg\_vault\_tde v1.7.1 : Transparent Data Encryption for PostgreSQL 17 and 18](<https://devfeed.tech/articles/pg-vault-tde-v1-7-1-transparent-data-encryption-for-postgresql-17-and-18-4719.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pg_vault_tde-v171-transparent-data-encryption-for-postgresql-17-and-18-3376/>)

Author: Miriade Srl

Published: 2026-09-10T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Encryption](<https://devfeed.tech/topics/encryption.md>), [Database](<https://devfeed.tech/topics/database.md>), [Cryptography](<https://devfeed.tech/topics/cryptography.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

pg_vault_tde 1.7.1 adds transparent AES-256-GCM encryption for PostgreSQL 17 and 18, with externally managed keys and online per-table key rotation. It fixes AAD derivation for out-of-line TOAST values; data written by 1.7.0 or earlier must be exported before upgrading affected tables.

### Source excerpt

pg_vault_tde provides Transparent Data Encryption for PostgreSQL 17 and 18. A table access method, encrypted_heap, encrypts every tuple with AES-256-GCM before it reaches the storage manager and decrypts it after it leaves, so applications require no changes. Keys are held outside the database: HashiCorp Vault or OpenBao through the Transit engine, a PKCS#11 token or HSM, or a local PKCS#12 wallet. Data encryption keys are per table and can be rotated online. Requirements are PostgreSQL 17 or 18, OpenSSL 3.x, and the library listed in shared_preload_libraries. The current release is 1.7.1. It corrects the AAD derivation for out-of-line TOAST values, with the consequence that TOAST data written by 1.7.0 or earlier does not authenticate under 1.7.1: affected tables must be exported before the new binary is installed. The procedure is documented in the README. pg_vault_tde is released under the PostgreSQL licence. Sources, documentation and binary .deb and .rpm packages are on GitHub; the distribution is on PGXN.

[Next page](<https://devfeed.tech/tags/postgresql.md?cursor=WyIyMDI2LTA5LTEwVDAwOjAwOjAwKzAwOjAwIiwgIjFiYWY0Mzk5LTNhYzUtNGU3Yy04NWIyLTQwY2EzOTZkYmMyZSJd>)