# Heroku Postgres

Heroku Postgres is a managed SQL database service provided by Heroku, based on 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.

## Borealis Isolated Postgres: Serious Database Security for the Common Runtime

DevFeed: [Borealis Isolated Postgres: Serious Database Security for the Common Runtime](<https://devfeed.tech/articles/borealis-isolated-postgres-serious-database-security-for-the-common-runtime-146521.md>)

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

Author: Joel Andrews

Published: 2026-11-20T17:24:16Z

Content type: article

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Database](<https://devfeed.tech/topics/database.md>), [Security](<https://devfeed.tech/topics/security.md>), [Amazon VPC](<https://devfeed.tech/topics/amazon-vpc.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>), [SELinux](<https://devfeed.tech/topics/selinux.md>), [Fail2ban](<https://devfeed.tech/topics/fail2ban.md>)

Tags: [add-ons](<https://devfeed.tech/tags/add-ons.md>), [database](<https://devfeed.tech/tags/database.md>), [database-security](<https://devfeed.tech/tags/database-security.md>), [ecosystem](<https://devfeed.tech/tags/ecosystem.md>), [heroku-postgres](<https://devfeed.tech/tags/heroku-postgres.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [runtime](<https://devfeed.tech/tags/runtime.md>)

### AI overview

Borealis Isolated Postgres provides network-isolated PostgreSQL for apps on Heroku's Common Runtime. Each database cluster sits in its own VPC and rejects incoming traffic by default, while three access paths support different needs: a buildpack creates secure app-to-database tunnels and can use a read-only URL; a Heroku CLI plugin opens temporary tunnels for administration and CI/CD, with CLI access read-only by default unless `--write-access` is supplied; and third-party integrations can connect through SSH port forwarding, read-only by default unless write access is enabled at creation. The article also describes TLS 1.2+ in transit, AES-256 at rest, restricted staff access and audit logging, temporary CLI credentials, weekly app credential rotation, and automatic minor PostgreSQL updates. Major upgrades are CLI-initiated and have under a minute of downtime. This is the vendor's account of its security features.

### Source excerpt

The power of Heroku lies in its simplicity. Developers can spin up an entire app stack, complete with its own database and caching layers with just a single command. No need for the specialized, time-consuming work of managing servers and virtual machines. This convenience applies to interacting with your app stack as well. Need to [...] The post Borealis Isolated Postgres: Serious Database Security for the Common Runtime appeared first on Heroku.

## Introducing Snapshot Migration to Heroku Postgres Advanced

DevFeed: [Introducing Snapshot Migration to Heroku Postgres Advanced](<https://devfeed.tech/articles/introducing-snapshot-migration-to-heroku-postgres-advanced-140977.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/introducing-snapshot-migration-heroku-postgres-advanced/>)

Author: Elliot Kozil

Published: 2026-11-17T20:29:26Z

Content type: release

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [Heroku](<https://devfeed.tech/topics/heroku.md>)

Tags: [advanced](<https://devfeed.tech/tags/advanced.md>), [cli](<https://devfeed.tech/tags/cli.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [heroku-postgres](<https://devfeed.tech/tags/heroku-postgres.md>), [interactive](<https://devfeed.tech/tags/interactive.md>), [migration](<https://devfeed.tech/tags/migration.md>), [news](<https://devfeed.tech/tags/news.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [snapshot](<https://devfeed.tech/tags/snapshot.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

Heroku's `heroku data:pg:migrate` CLI workflow moves a Postgres Classic database to Heroku Postgres Advanced in two phases. Preparation runs online: it checks the source, resets the destination, and copies supported settings; the destination can be created with the source's Postgres major version and matching Private or Shield Space networking. After preparation, migration must start within 24 hours. The snapshot phase takes the source offline, copies data, restores constraints and indexes, and validates the result, so downtime grows with database size. Failures trigger rollback and reopen the source; cancellation is available until the final step. Heroku recommends rehearsing on a fork to estimate downtime. Afterward, apps must be switched to the Advanced database, and followers, credential attachments, and dataclip targets may need follow-up setup. Streaming migrations are described as a future option intended to shorten cutover.

### Source excerpt

When we announced Heroku Postgres Advanced in October, migration tooling for Postgres Classic databases was the first item on our roadmap. The first part of that tooling is available today: heroku data:pg:migrate. heroku data:pg:migrate is a guided, interactive Heroku CLI workflow that moves a Postgres Classic tier database to Heroku Postgres Advanced. You don't write [...] The post Introducing Snapshot Migration to Heroku Postgres Advanced appeared first on Heroku.

## How we migrate TBs from Heroku without logical replication

DevFeed: [How we migrate TBs from Heroku without logical replication](<https://devfeed.tech/articles/how-we-migrate-tbs-from-heroku-without-logical-replication-130264.md>)

Original publisher: [Read original article](<https://planetscale.com/blog/migrate-from-heroku-to-planetscale>)

Author: Dmitrii Anisovich

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

Content type: tutorial

Language: en

Sources: [PlanetScale](<https://devfeed.tech/sources/blog-planetscale.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Heroku](<https://devfeed.tech/topics/heroku.md>), [Tool](<https://devfeed.tech/topics/tool.md>), [copy](<https://devfeed.tech/topics/copy.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [downtime](<https://devfeed.tech/tags/downtime.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [logical](<https://devfeed.tech/tags/logical.md>), [logical-replication](<https://devfeed.tech/tags/logical-replication.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [replication](<https://devfeed.tech/tags/replication.md>)

### AI overview

Heroku's standard Postgres plans lack logical replication, so PlanetScale's open-source Heroku Migrator uses Bucardo triggers to capture writes while it copies data and keeps the target in sync. The process starts with read-only discovery via ps-discovery and a Liftoff assessment; replicated tables need a primary key or unique index, and schema changes must be frozen during migration. After copying, the migrator rebuilds secondary and unique indexes in parallel, verifies schema and data checks, then supports a controlled traffic switch and rollback. For large migrations, version 2.0 addresses repeated full-copy restarts by separating data transfer from index rebuilding, uses TCP keepalives to detect dropped long-lived connections, and adds txntime indexes to Bucardo track tables to speed replication checks. The article reports a sample copy rate increase from about 60 to nearly 300 GB/hour, with index rebuilding taking about two hours; results depend on the database and migration conditions.

### Source excerpt

We've equipped our customers with an open source tool that not only quickly transfers your data but also provides a replication-based experience, so that any user can migrate from Heroku without extended downtime or the need to purchase a third-party product.

## ClickHouse Managed Postgres goes GA and Xata acquisition brings agentic capabilities to the service

DevFeed: [ClickHouse Managed Postgres goes GA and Xata acquisition brings agentic capabilities to the service](<https://devfeed.tech/articles/clickhouse-managed-postgres-goes-ga-and-xata-acquisition-brings-agentic-capabilities-to-the-service-124829.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/managed-postgres-ga-xata-acquisition>)

Author: Sai Srirampur

Published: 2026-11-09T16:56:11Z

Content type: release

Language: en

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

Topics: [Tinybird news](<https://devfeed.tech/topics/tinybird-news.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Heroku AI](<https://devfeed.tech/topics/heroku-ai.md>), [internal developer platform automation](<https://devfeed.tech/topics/internal-developer-platform-automation.md>), [OpenAPI Specification](<https://devfeed.tech/topics/openapi.md>)

Tags: [acquisition](<https://devfeed.tech/tags/acquisition.md>), [agent-memory](<https://devfeed.tech/tags/agent-memory.md>), [agent-sandboxing](<https://devfeed.tech/tags/agent-sandboxing.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-coding-agents](<https://devfeed.tech/tags/ai-coding-agents.md>), [ai-native](<https://devfeed.tech/tags/ai-native.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [developers](<https://devfeed.tech/tags/developers.md>), [developers-and-ai](<https://devfeed.tech/tags/developers-and-ai.md>), [instant](<https://devfeed.tech/tags/instant.md>), [managed](<https://devfeed.tech/tags/managed.md>), [nvme](<https://devfeed.tech/tags/nvme.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [scale](<https://devfeed.tech/tags/scale.md>), [zero](<https://devfeed.tech/tags/zero.md>)

### AI overview

ClickHouse Managed Postgres is generally available on AWS, combining local NVMe storage with native ClickHouse analytics connectivity. The excerpt reports 2-10x OLTP performance improvements, WAL-based sub-second replication through WalShadow, and ClickPipes as an included alternative; it also lists high availability, backups, pooling, replicas, observability, and enterprise security features. GCP remains in private preview. GA ends the beta discount and makes backup storage and public network egress billable, while ClickHouse connectivity and ClickPipes replication remain included. The Xata acquisition is intended to add copy-on-write instant branching and cloning, automatic idling, and scale-to-zero for isolated development and AI-agent environments. Existing Xata capabilities are available through customer onboarding; integration into ClickHouse Managed Postgres and a dedicated agent tier are planned, not yet described as launched.

### Source excerpt

ClickHouse Managed Postgres, our NVMe-backed Postgres service natively connected to ClickHouse, is generally available, and we're acquiring Xata to add instant branching, cloning and scale-to-zero for developers and AI agents.

## Postgres wait events, now in Query Insights

DevFeed: [Postgres wait events, now in Query Insights](<https://devfeed.tech/articles/postgres-wait-events-now-in-query-insights-89996.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/postgres-wait-events-query-insights>)

Author: Amog Iska

Published: 2026-10-19T11:15:28Z

Content type: release

Language: en

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

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>), [Prometheus](<https://devfeed.tech/topics/prometheus.md>), [Deadlock](<https://devfeed.tech/topics/deadlock.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [grafana](<https://devfeed.tech/tags/grafana.md>), [latency](<https://devfeed.tech/tags/latency.md>), [locks](<https://devfeed.tech/tags/locks.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [prometheus](<https://devfeed.tech/tags/prometheus.md>)

### AI overview

ClickHouse Managed Postgres Query Insights now reports wait event metrics, showing what active sessions are waiting on and how wait categories contribute to database load. It adds blocked-session and lock-wait charts, and exposes query, resource, and wait metrics through Prometheus for dashboards and alerting.

### Source excerpt

Query Insights for ClickHouse Managed Postgres now shows what active sessions are waiting on, with wait event breakdowns, blocked-session and lock-wait charts, and the same metrics in Prometheus.

## The Easiest Way to Replicate Postgres Data to Snowflake

DevFeed: [The Easiest Way to Replicate Postgres Data to Snowflake](<https://devfeed.tech/articles/the-easiest-way-to-replicate-postgres-data-to-snowflake-87879.md>)

Original publisher: [Read original article](<https://hackernoon.com/the-easiest-way-to-replicate-postgres-data-to-snowflake?source=rss>)

Author: Pipelineguy

Published: 2026-10-15T09:01:11Z

Content type: tutorial

Language: en

Sources: [HackerNoon](<https://devfeed.tech/sources/hackernoon.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Snowflake streaming data architecture](<https://devfeed.tech/topics/snowflake-streaming-data-architecture.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [CRUD](<https://devfeed.tech/topics/crud.md>)

Tags: [cdc](<https://devfeed.tech/tags/cdc.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [data-engineering](<https://devfeed.tech/tags/data-engineering.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [data-replication](<https://devfeed.tech/tags/data-replication.md>), [estuary](<https://devfeed.tech/tags/estuary.md>), [good-company](<https://devfeed.tech/tags/good-company.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>)

### AI overview

This tutorial shows how to build a PostgreSQL-to-Snowflake change data capture pipeline with Estuary. It covers enabling PostgreSQL logical replication, capturing changes into Estuary collections, configuring Snowflake materialization, and verifying that inserts, updates, and deletes reach the destination. It also discusses production considerations such as replication lag, WAL retention, backfills, schema changes, monitoring, and synchronization frequency.

### Source excerpt

Learn how to replicate PostgreSQL to Snowflake using Estuary and CDC. Build a step-by-step pipeline that captures inserts, updates, and deletes.

## Postgres at Open House NYC

DevFeed: [Postgres at Open House NYC](<https://devfeed.tech/articles/postgres-at-open-house-nyc-86381.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/postgres-at-open-house-nyc>)

Author: Sai Srirampur; Kaushik Iska

Published: 2026-10-13T15:35:19Z

Content type: news

Language: en

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

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Supabase](<https://devfeed.tech/topics/supabase.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [alloydb](<https://devfeed.tech/tags/alloydb.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-sql](<https://devfeed.tech/tags/cloud-sql.md>), [cloud-storage](<https://devfeed.tech/tags/cloud-storage.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

ClickHouse describes an integrated Postgres and ClickHouse stack for transactional and analytical workloads, including Managed Postgres, native CDC, the WalShadow replication engine, and a chdb Postgres extension. It reports WalShadow benchmark results and a live demo, and announces private preview availability on Google Cloud.

### Source excerpt

At Open House NYC, we showed how ClickHouse Managed Postgres and ClickHouse work as one stack, with a live WalShadow demo replicating Postgres into ClickHouse in under a second, plus the same-week Google Cloud and chdb extension launches.

## October 2026 Update: Heroku Innovations and New Features

DevFeed: [October 2026 Update: Heroku Innovations and New Features](<https://devfeed.tech/articles/october-2026-update-heroku-innovations-and-new-features-66921.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/october-2026-update-heroku-innovations-features/>)

Author: Keshav Pokkuluri

Published: 2026-10-07T18:17:45Z

Content type: release

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku](<https://devfeed.tech/topics/heroku.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [ci-cd](<https://devfeed.tech/tags/ci-cd.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [news](<https://devfeed.tech/tags/news.md>), [platform-updates](<https://devfeed.tech/tags/platform-updates.md>), [releases](<https://devfeed.tech/tags/releases.md>)

### AI overview

Heroku's October 2026 update covers a new managed Postgres tier with workload isolation, decoupled storage and compute scaling, plus platform changes to buildpacks, database defaults, architecture, access controls, credentials and Salesforce connectivity.

### Source excerpt

Heroku's continuous platform innovation keeps operational overhead out of your path while delivering our industry-best developer experience. We handle everything below your code, from the core infrastructure and OS maintenance to runtimes and dependencies, so developers can stay focused on building. You can see that ongoing innovation across our latest releases in managed data services, [...] The post October 2026 Update: Heroku Innovations and New Features appeared first on Heroku.

## A New Era for Managed Databases: Announcing Heroku Postgres Advanced

DevFeed: [A New Era for Managed Databases: Announcing Heroku Postgres Advanced](<https://devfeed.tech/articles/a-new-era-for-managed-databases-announcing-heroku-postgres-advanced-65822.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/new-era-managed-databases-announcing-heroku-postgres-advanced/>)

Author: Jonathan Brown

Published: 2026-10-06T18:35:12Z

Content type: news

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>), [connection draining](<https://devfeed.tech/topics/connection-draining.md>), [To-Do](<https://devfeed.tech/topics/todo.md>)

Tags: [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [availability](<https://devfeed.tech/tags/availability.md>), [connection-pooling](<https://devfeed.tech/tags/connection-pooling.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [heroku-postgres](<https://devfeed.tech/tags/heroku-postgres.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [news](<https://devfeed.tech/tags/news.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

Heroku announces Postgres Advanced, a managed database tier with compute and storage that scale independently, instance pools for read scaling and workload isolation, and support for PostgreSQL 16, 17, and 18. The post also describes elastic storage, background scaling and credential changes, and planned capabilities including migration tools, logical replication, autoscaling, global clusters, connection pooling, and sleep mode.

### Source excerpt

At Heroku, we've built a platform that allows developers to focus on their apps, not managing their infrastructure. Heroku Postgres Advanced carries forward that philosophy as our next-generation database offering, available today. The post A New Era for Managed Databases: Announcing Heroku Postgres Advanced appeared first on Heroku.

## A practical guide to cost optimization with Lakebase Postgres

DevFeed: [A practical guide to cost optimization with Lakebase Postgres](<https://devfeed.tech/articles/a-practical-guide-to-cost-optimization-with-lakebase-postgres-62674.md>)

Original publisher: [Read original article](<https://www.databricks.com/blog/practical-guide-cost-optimization-lakebase-postgres>)

Author: Benjamin Nwokeleme; Firas Farah; Jen Darrouzet

Published: 2026-09-30T16:53:12Z

Content type: tutorial

Language: en

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

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [cloud cost management](<https://devfeed.tech/topics/cloud-cost-management.md>)

Tags: [application-development](<https://devfeed.tech/tags/application-development.md>), [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [cost-optimization](<https://devfeed.tech/tags/cost-optimization.md>), [guide](<https://devfeed.tech/tags/guide.md>), [lakebase](<https://devfeed.tech/tags/lakebase.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [practical](<https://devfeed.tech/tags/practical.md>)

### AI overview

This guide explains how Lakebase's separated storage and compute, database branching, autoscaling, and scale-to-zero behavior can reduce costs. Branches share storage for development and testing environments, while adjustable compute limits help align capacity with demand and cap spending. Scale to zero can eliminate compute costs during inactivity, with resumption taking a few hundred milliseconds.

### Source excerpt

Lakebase is a fully managed Postgres database, built for the operational realities...

## App hosting platforms with managed Postgres compared (2026)

DevFeed: [App hosting platforms with managed Postgres compared (2026)](<https://devfeed.tech/articles/app-hosting-platforms-with-managed-postgres-compared-2026-65030.md>)

Original publisher: [Read original article](<https://www.prisma.io/blog/app-hosting-platforms-with-managed-postgres-2026>)

Author: Gregory Boch

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

Content type: comparison

Language: en

Sources: [Prisma](<https://devfeed.tech/sources/prisma-blog.md>)

Topics: [hosting](<https://devfeed.tech/topics/hosting.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>)

Tags: [backups](<https://devfeed.tech/tags/backups.md>), [compute](<https://devfeed.tech/tags/compute.md>), [cost](<https://devfeed.tech/tags/cost.md>), [fly-io](<https://devfeed.tech/tags/fly-io.md>), [hosting](<https://devfeed.tech/tags/hosting.md>), [neon](<https://devfeed.tech/tags/neon.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [prisma](<https://devfeed.tech/tags/prisma.md>), [supabase](<https://devfeed.tech/tags/supabase.md>), [vercel](<https://devfeed.tech/tags/vercel.md>)

### AI overview

This comparison evaluates Prisma Compute with Prisma Postgres, Railway, Render, Fly.io, Supabase, Neon, and Vercel for hosting applications alongside managed Postgres. It compares language and runtime support, preview deployments, scaling behavior, pooling, backups and point-in-time recovery, and pricing, with recommendations for different application needs.

### Source excerpt

Prisma Compute, Railway, Render, Fly.io, Supabase, Neon and Vercel compared for an app next to managed Postgres: previews, idle cost, pooling, backups and prices.

## Can your Postgres survive a bad query?

DevFeed: [Can your Postgres survive a bad query?](<https://devfeed.tech/articles/can-your-postgres-survive-a-bad-query-61404.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/can-your-postgres-survive-a-bad-query>)

Author: Kevin Biju Kizhake Kanichery

Published: 2026-09-28T15:37:06Z

Content type: article

Language: en

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

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [cloud-sql](<https://devfeed.tech/tags/cloud-sql.md>), [database](<https://devfeed.tech/tags/database.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [memory-management](<https://devfeed.tech/tags/memory-management.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [reliability](<https://devfeed.tech/tags/reliability.md>)

### AI overview

The article examines how Postgres providers respond when a query exhausts memory, comparing query failures and cluster survival through a recursive query benchmark across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.

### Source excerpt

How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.

## Inside branch-based restores in Lakebase Postgres

DevFeed: [Inside branch-based restores in Lakebase Postgres](<https://devfeed.tech/articles/inside-branch-based-restores-in-lakebase-postgres-61222.md>)

Original publisher: [Read original article](<https://neon.com/blog/inside-branch-based-restores-in-lakebase-postgres>)

Author: Carlota Soto

Published: 2026-09-28T12:00:00Z

Content type: article

Language: en

Sources: [Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>)

Tags: [databases](<https://devfeed.tech/tags/databases.md>), [failover](<https://devfeed.tech/tags/failover.md>), [lakebase](<https://devfeed.tech/tags/lakebase.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [product](<https://devfeed.tech/tags/product.md>), [production](<https://devfeed.tech/tags/production.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [scale](<https://devfeed.tech/tags/scale.md>)

### AI overview

The article explains how Lakebase Postgres uses branch creation at a chosen point in database history for restores. Traditional managed Postgres point-in-time recovery provisions an instance, restores a snapshot, and replays WAL, which can take hours at large scale. The branch-based approach points to existing history and attaches independent compute, making a past state queryable quickly; it also describes how agent platforms could use checkpoints to support undo workflows.

### Source excerpt

Restores are broken in managed OLTP, and they have been broken for a long time. They are slow, and they get slower with scale. The databases that need recovery most, the large production ones, are the ones left waiting the longest.

## Hosting and Postgres after your first 100 users

DevFeed: [Hosting and Postgres after your first 100 users](<https://devfeed.tech/articles/hosting-and-postgres-after-your-first-100-users-60623.md>)

Original publisher: [Read original article](<https://www.prisma.io/blog/choosing-hosting-and-postgres-after-your-first-100-users>)

Author: Gregory Boch

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

Content type: article

Language: en

Sources: [Prisma](<https://devfeed.tech/sources/prisma-blog.md>)

Topics: [hosting](<https://devfeed.tech/topics/hosting.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>)

Tags: [connection-pooling](<https://devfeed.tech/tags/connection-pooling.md>), [cost](<https://devfeed.tech/tags/cost.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [render](<https://devfeed.tech/tags/render.md>)

### AI overview

The article offers a checklist for hosting and Postgres decisions as an app reaches its first 100 users. It explains connection pooling, deployment location and pricing, including when Prisma Compute or a long-lived host may fit, and identifies early checks such as testing a database restore and setting a spending limit.

### Source excerpt

A scaling checklist, where to run your app, what Postgres costs at 100, 1,000 and 10,000 users with the arithmetic shown, and signs you have outgrown it.

## Neon vs Prisma Postgres: app and database in one place

DevFeed: [Neon vs Prisma Postgres: app and database in one place](<https://devfeed.tech/articles/neon-vs-prisma-postgres-app-and-database-in-one-place-60624.md>)

Original publisher: [Read original article](<https://www.prisma.io/blog/neon-vs-prisma-postgres-app-hosting-in-one-place>)

Author: Gregory Boch

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

Content type: comparison

Language: en

Sources: [Prisma](<https://devfeed.tech/sources/prisma-blog.md>)

Topics: [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>), [Shopify](<https://devfeed.tech/topics/shopify.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Database](<https://devfeed.tech/topics/database.md>), [Deployment Strategies](<https://devfeed.tech/topics/deployment-strategies.md>), [Prisma](<https://devfeed.tech/topics/prisma.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [app-hosting](<https://devfeed.tech/tags/app-hosting.md>), [backend](<https://devfeed.tech/tags/backend.md>), [better](<https://devfeed.tech/tags/better.md>), [database](<https://devfeed.tech/tags/database.md>), [dependency](<https://devfeed.tech/tags/dependency.md>), [github-actions](<https://devfeed.tech/tags/github-actions.md>), [neon](<https://devfeed.tech/tags/neon.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

The article compares Neon and Prisma's app hosting alongside Postgres, covering deployment models, database connections, preview environments, idle costs, and product gaps. It outlines when each stack may fit, including cases where Neon still requires a separate frontend host and where Prisma Composer remains in Early Access.

### Source excerpt

Neon and Prisma can both host your app next to Postgres. Compare previews, connection handling, idle cost and restores, and see when Neon is the better pick.

## 6 Lesser-Known Heroku CLI Commands You Probably Aren't Using

DevFeed: [6 Lesser-Known Heroku CLI Commands You Probably Aren't Using](<https://devfeed.tech/articles/6-lesser-known-heroku-cli-commands-you-probably-aren-t-using-26361.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/6-lesser-known-heroku-cli-commands/>)

Author: Andy Smith

Published: 2026-08-25T16:28:53Z

Content type: tutorial

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku](<https://devfeed.tech/topics/heroku.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [Developer experience](<https://devfeed.tech/topics/developer-experience.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [developer-productivity](<https://devfeed.tech/topics/developer-productivity.md>)

Tags: [apm](<https://devfeed.tech/tags/apm.md>), [cli](<https://devfeed.tech/tags/cli.md>), [code](<https://devfeed.tech/tags/code.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [commands](<https://devfeed.tech/tags/commands.md>), [config](<https://devfeed.tech/tags/config.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [credentials](<https://devfeed.tech/tags/credentials.md>), [database](<https://devfeed.tech/tags/database.md>), [developer-experience](<https://devfeed.tech/tags/developer-experience.md>), [developer-tools](<https://devfeed.tech/tags/developer-tools.md>), [ecosystem](<https://devfeed.tech/tags/ecosystem.md>), [engineering-velocity](<https://devfeed.tech/tags/engineering-velocity.md>), [environment](<https://devfeed.tech/tags/environment.md>), [export](<https://devfeed.tech/tags/export.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [heroku-postgres](<https://devfeed.tech/tags/heroku-postgres.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [productivity](<https://devfeed.tech/tags/productivity.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

The excerpt describes Heroku CLI shortcuts for keeping setup and troubleshooting in the terminal. For local configuration, it recommends exporting variables from a sandbox or staging app; exporting overwrites an existing environment file, while retrieving one variable can append it. Include that file in `.gitignore` to avoid committing credentials. It warns against pulling configuration from production. A second tip begins describing a command that inspects active Heroku Postgres queries to avoid writing queries against internal system tables, but the excerpt ends before giving the command or further details.

### Source excerpt

Improving developer experience in the command line relies on minimizing context switches. While most engineers use the Heroku CLI strictly for basic tasks like pushing code, it contains a powerful suite of command line tools built to optimize your workflow. If you want to keep your focus locked on writing code, these six Heroku CLI commands will instantly upgrade your daily productivity. The post 6 Lesser-Known Heroku CLI Commands You Probably Aren't Using appeared first on Heroku.

## The Startup's Postgres Survival Guide: What HN Is Saying About Hatchet's Battle-Tested Advice

DevFeed: [The Startup's Postgres Survival Guide: What HN Is Saying About Hatchet's Battle-Tested Advice](<https://devfeed.tech/articles/the-startup-s-postgres-survival-guide-what-hn-is-saying-about-hatchet-s-battle-tested-advice-56315.md>)

Original publisher: [Read original article](<https://www.developersdigest.tech/blog/startup-postgres-survival-guide-hn>)

Author: Developers Digest

Published: 2026-07-22T00:00:00Z

Content type: article

Language: en

Sources: [Developers Digest](<https://devfeed.tech/sources/developers-digest.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>)

Tags: [databases](<https://devfeed.tech/tags/databases.md>), [hacker-news](<https://devfeed.tech/tags/hacker-news.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [news](<https://devfeed.tech/tags/news.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [production](<https://devfeed.tech/tags/production.md>), [startup](<https://devfeed.tech/tags/startup.md>), [startups](<https://devfeed.tech/tags/startups.md>)

### AI overview

The document describes a practical review of a Postgres operations guide, covering what it gets right, community criticism, and lessons for startups running Postgres in production.

### Source excerpt

A practical look at the operational Postgres guide that hit the HN front page - what it gets right, what the community pushed back on, and what every startup should internalize about running Postgres in production.

## A 15-Second Health Check for Your Heroku Connect Data Pipeline

DevFeed: [A 15-Second Health Check for Your Heroku Connect Data Pipeline](<https://devfeed.tech/articles/a-15-second-health-check-for-your-heroku-connect-data-pipeline-26410.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/health-check-for-your-heroku-connect-data-pipeline/>)

Author: Nick Prey

Published: 2026-06-24T15:35:14Z

Content type: article

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [health check](<https://devfeed.tech/topics/health-check.md>), [data observability](<https://devfeed.tech/topics/data-observability.md>), [Heroku](<https://devfeed.tech/topics/heroku.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Database](<https://devfeed.tech/topics/database.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [audit](<https://devfeed.tech/tags/audit.md>), [capacity](<https://devfeed.tech/tags/capacity.md>), [cli](<https://devfeed.tech/tags/cli.md>), [command](<https://devfeed.tech/tags/command.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [database-schema](<https://devfeed.tech/tags/database-schema.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [environment](<https://devfeed.tech/tags/environment.md>), [fields](<https://devfeed.tech/tags/fields.md>), [health-check](<https://devfeed.tech/tags/health-check.md>), [heroku-connect](<https://devfeed.tech/tags/heroku-connect.md>), [mapping](<https://devfeed.tech/tags/mapping.md>), [permissions](<https://devfeed.tech/tags/permissions.md>), [plugin](<https://devfeed.tech/tags/plugin.md>), [salesforce](<https://devfeed.tech/tags/salesforce.md>)

### AI overview

Heroku Connect's CLI plugin provides a diagnostic command that checks pipeline health across two areas: environment settings such as the connection endpoint, permissions, and database capacity; and table mappings and field properties for schema alignment. Its sequential output is intended to surface direct warnings about configuration mismatches, including outdated API versions or unsupported field types, without requiring users to search logs or database states. The excerpt recommends running this check proactively before schema updates or migrations; it does not include the command syntax or the complete set of checks.

### Source excerpt

Heroku Connect is a fully managed, bidirectional data sync service between Salesforce and Heroku Postgres that lets developers read and write Salesforce data using standard SQL. The sync is straightforward to set up and operates smoothly in the background, but when a field does not update as expected or data seems to lag, you do not need to guess what went wrong. The post A 15-Second Health Check for Your Heroku Connect Data Pipeline appeared first on Heroku.

## The Best PostgreSQL Hosting for Developers in 2026

DevFeed: [The Best PostgreSQL Hosting for Developers in 2026](<https://devfeed.tech/articles/the-best-postgresql-hosting-for-developers-in-2026-95510.md>)

Original publisher: [Read original article](<https://blog.railway.com/p/best-postgresql-hosting-2026>)

Author: Angelo Saraceno

Published: 2026-05-25T00:00:00Z

Content type: comparison

Language: en

Sources: [Railway](<https://devfeed.tech/sources/railway.md>)

Topics: [hosting](<https://devfeed.tech/topics/hosting.md>), [The Three Main Cloud Service Models](<https://devfeed.tech/topics/the-three-main-cloud-service-models.md>), [Comparing SaaS, PaaS, and IaaS](<https://devfeed.tech/topics/comparing-saas-paas-and-iaas.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [best](<https://devfeed.tech/tags/best.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [developers](<https://devfeed.tech/tags/developers.md>), [for-developers](<https://devfeed.tech/tags/for-developers.md>), [hosting](<https://devfeed.tech/tags/hosting.md>), [hyperscaler](<https://devfeed.tech/tags/hyperscaler.md>), [net](<https://devfeed.tech/tags/net.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [railway](<https://devfeed.tech/tags/railway.md>), [ranking](<https://devfeed.tech/tags/ranking.md>), [saas](<https://devfeed.tech/tags/saas.md>)

### AI overview

Choose the hosting model before the vendor: integrated PaaS keeps app and database together on one platform and private network; dedicated Postgres SaaS emphasizes database features while you bring compute; hyperscaler services integrate with existing cloud accounts, IAM, and VPCs. The source treats application proximity as a key factor and recommends checking for automatic failover, point-in-time recovery, pooling, extensions, observability, restorable backups, and network adjacency. Neon stands out for copy-on-write branching and scale-to-zero, with cold starts and migration coordination as tradeoffs; Supabase bundles Postgres with auth, storage, and APIs, adding product lock-in. Railway and Render offer app-and-database adjacency, while AWS RDS/Aurora, Google Cloud SQL, and Azure Database for PostgreSQL fit teams already on those clouds. Crunchy Bridge emphasizes Postgres operations; Aiven offers multi-cloud portability at a premium. The rankings reflect the author's perspective, and Railway's entry is by an employee who discloses that affiliation.

### Source excerpt

Postgres hosting fragmented into three shapes in 2026: integrated PaaS, dedicated SaaS, and hyperscaler-native. A ranking that helps you pick the shape before you pick the vendor.

## Book Review - Just Use Postgres!

DevFeed: [Book Review - Just Use Postgres!](<https://devfeed.tech/articles/book-review-just-use-postgres-21980.md>)

Original publisher: [Read original article](<https://vladmihalcea.com/book-review-just-use-postgres/>)

Author: vladmihalcea

Published: 2025-11-24T09:00:34Z

Content type: article

Language: en

Sources: [Vlad Mihalcea](<https://devfeed.tech/sources/vlad-mihalcea.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Database](<https://devfeed.tech/topics/database.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [Generative AI](<https://devfeed.tech/topics/generative-ai.md>)

Tags: [applications](<https://devfeed.tech/tags/applications.md>), [book](<https://devfeed.tech/tags/book.md>), [book-review](<https://devfeed.tech/tags/book-review.md>), [content](<https://devfeed.tech/tags/content.md>), [data-integrity](<https://devfeed.tech/tags/data-integrity.md>), [developer](<https://devfeed.tech/tags/developer.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [extension](<https://devfeed.tech/tags/extension.md>), [features](<https://devfeed.tech/tags/features.md>), [introduction](<https://devfeed.tech/tags/introduction.md>), [modern](<https://devfeed.tech/tags/modern.md>), [pages](<https://devfeed.tech/tags/pages.md>), [parts](<https://devfeed.tech/tags/parts.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [review](<https://devfeed.tech/tags/review.md>), [software](<https://devfeed.tech/tags/software.md>), [software-developer](<https://devfeed.tech/tags/software-developer.md>), [useful](<https://devfeed.tech/tags/useful.md>), [wonderful](<https://devfeed.tech/tags/wonderful.md>)

### AI overview

The review describes Just Use Postgres! as a 402-page, three-part book for developers using or considering PostgreSQL. Its first part covers SQL fundamentals and features such as transactions, views, recursive queries, window functions, and several index types. The second focuses on PostgreSQL's non-relational capabilities, including JSON and full-text search, with related querying and indexing options. The third turns to the Postgres extension ecosystem; the excerpt mentions embedding storage for ML and GenAI and TimescaleDB for time-series data, but ends before completing that discussion.

### Source excerpt

Introduction My friend, Denis Magda, wrote a wonderful book called Just Use Postgres!, and I'm glad that I got the chance to read it. Audience This book is useful for any software developer who's either using PostgreSQL or plans on using it because it covers a lot of features that are very useful for modern applications. No matter your level of seniority, you are definitely going to learn from Denis' book. Content Just Use Postgres! has 402 pages, 3 parts, and 11 chapters. The first part is an introduction to PostgreSQL and... Read More The post Book Review - Just Use Postgres! appeared first on Vlad Mihalcea.

## Introducing the Next Generation of Heroku Postgres - Unlocking Performance, Scale, and Zero-Friction Ops

DevFeed: [Introducing the Next Generation of Heroku Postgres - Unlocking Performance, Scale, and Zero-Friction Ops](<https://devfeed.tech/articles/introducing-the-next-generation-of-heroku-postgres-unlocking-performance-scale-and-zero-friction-ops-26459.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/introducing-the-next-generation-of-heroku-postgres/>)

Author: Jonathan Brown

Published: 2025-10-14T15:00:18Z

Content type: release

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Heroku](<https://devfeed.tech/topics/heroku.md>), [Cloud Architecture](<https://devfeed.tech/topics/cloud-architecture.md>)

Tags: [advanced](<https://devfeed.tech/tags/advanced.md>), [ai](<https://devfeed.tech/tags/ai.md>), [applications](<https://devfeed.tech/tags/applications.md>), [capabilities](<https://devfeed.tech/tags/capabilities.md>), [customers](<https://devfeed.tech/tags/customers.md>), [data](<https://devfeed.tech/tags/data.md>), [developers](<https://devfeed.tech/tags/developers.md>), [flexibility](<https://devfeed.tech/tags/flexibility.md>), [foundation](<https://devfeed.tech/tags/foundation.md>), [future](<https://devfeed.tech/tags/future.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [heroku-postgres](<https://devfeed.tech/tags/heroku-postgres.md>), [limits](<https://devfeed.tech/tags/limits.md>), [mission](<https://devfeed.tech/tags/mission.md>), [news](<https://devfeed.tech/tags/news.md>), [ops](<https://devfeed.tech/tags/ops.md>), [performance](<https://devfeed.tech/tags/performance.md>), [performance-scale](<https://devfeed.tech/tags/performance-scale.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [product-features](<https://devfeed.tech/tags/product-features.md>), [scale](<https://devfeed.tech/tags/scale.md>), [zero](<https://devfeed.tech/tags/zero.md>)

### AI overview

Heroku Postgres Advanced is a new managed tier built on AWS database technology, with Heroku adding developer-facing capabilities and operational automation. The excerpt says its architecture is designed for non-disruptive, zero-downtime scaling, and reports over 4x throughput in initial tests, storage capacity above 200 TB, and increased connection capacity. It also says compute and storage are decoupled for flexibility, but the excerpt ends before explaining how that flexibility works. Heroku invites customers to sign up for a pilot.

### Source excerpt

We are thrilled to announce the next generation of Heroku Postgres to power a data foundation for the next wave of intelligent and mission-critical applications. This roadmap has been driven by listening closely to our customers, culminating in the introduction of a new Heroku Postgres Advanced tier. This revolutionary data foundation is designed to eliminate previous scaling limits, unlock unprecedented architectural flexibility and performance, and reduce operational friction. As the AI PaaS from Salesforce, Heroku is the force multiplier for developers building this future with an integrated platform with powerful capabilities made simple to use - removing friction along the software delivery lifecycle. We invite you to sign up for the pilot. The post Introducing the Next Generation of Heroku Postgres - Unlocking Performance, Scale, and Zero-Friction Ops appeared first on Heroku.

## Triage and Fix with Confidence: heroku run and OTel on Heroku Fir

DevFeed: [Triage and Fix with Confidence: heroku run and OTel on Heroku Fir](<https://devfeed.tech/articles/triage-and-fix-with-confidence-heroku-run-and-otel-on-heroku-fir-26444.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/heroku-run-and-otel-on-heroku-fir/>)

Author: Su Glasgo

Published: 2025-09-08T21:33:43Z

Content type: article

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku](<https://devfeed.tech/topics/heroku.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [health check](<https://devfeed.tech/topics/health-check.md>)

Tags: [cloud-infrastructure](<https://devfeed.tech/tags/cloud-infrastructure.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [debugging](<https://devfeed.tech/tags/debugging.md>), [dynos](<https://devfeed.tech/tags/dynos.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [fir](<https://devfeed.tech/tags/fir.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [interactive](<https://devfeed.tech/tags/interactive.md>), [interactive-cli](<https://devfeed.tech/tags/interactive-cli.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [opentelemetry](<https://devfeed.tech/tags/opentelemetry.md>), [operations](<https://devfeed.tech/tags/operations.md>), [performance-optimization](<https://devfeed.tech/tags/performance-optimization.md>)

### AI overview

Heroku Fir's `heroku run` launches a dedicated one-off dyno for interactive administrative or maintenance work, relaying terminal input and output while keeping the task separate from formation dynos. The excerpt presents this as a way to investigate failures or run a database migration with the app's code and environment variables, without consuming resources from a live web dyno. Using it on Fir requires a public SSH key on the account and a deployed application. The excerpt ends before the example command or any additional workflow details.

### Source excerpt

When Production Goes Sideways Imagine this: It's 2 AM, your phone buzzes with an alert, and your dashboards are screaming. Production is down. Sound familiar? An automated health check has failed, and your internal dashboards are showing a spike in errors. You've just pushed a new release that included a critical database schema change, and [...] The post Triage and Fix with Confidence: <code>heroku run</code> and OTel on Heroku Fir appeared first on Heroku.

## From Heroku to Neon: The dev.to Story

DevFeed: [From Heroku to Neon: The dev.to Story](<https://devfeed.tech/articles/from-heroku-to-neon-the-dev-to-story-5200.md>)

Original publisher: [Read original article](<https://neon.com/blog/dev-from-heroku-to-neon>)

Author: Carlota Soto

Published: 2025-06-19T16:04:37Z

Content type: article

Language: en

Sources: [Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Heroku](<https://devfeed.tech/topics/heroku.md>), [software-development](<https://devfeed.tech/topics/software-development.md>)

Tags: [case-studies](<https://devfeed.tech/tags/case-studies.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [developer](<https://devfeed.tech/tags/developer.md>), [developer-experience](<https://devfeed.tech/tags/developer-experience.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

A case study of DEV's migration from Heroku Postgres to Neon as its developer community and database workload grew. It describes Heroku's scaling rigidity, unused capacity, limited replica options, operational overhead, and the search for a provider offering more flexible scaling and developer-focused capabilities.

### Source excerpt

"We didn't just want a better Postgres database, we wanted a partner who shared our focus on developers. With Neon, we finally have a setup that scales with our platform and our values." (Peter Frank, DEV Co-Founder) DEV needs no introduction. For millions of developers getting s...

## Heroku Postgres Upgrade Guide: Simplify Your Move to Version 17

DevFeed: [Heroku Postgres Upgrade Guide: Simplify Your Move to Version 17](<https://devfeed.tech/articles/heroku-postgres-upgrade-guide-simplify-your-move-to-version-17-26441.md>)

Original publisher: [Read original article](<https://www.heroku.com/blog/heroku-postgres-upgrade-guide-simplify-move-version-17/>)

Author: Kavya Premkumar

Published: 2025-05-29T15:30:32Z

Content type: tutorial

Language: en

Sources: [Heroku](<https://devfeed.tech/sources/heroku.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>), [version](<https://devfeed.tech/topics/version.md>)

Tags: [cli](<https://devfeed.tech/tags/cli.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [heroku-postgres](<https://devfeed.tech/tags/heroku-postgres.md>), [platform-updates](<https://devfeed.tech/tags/platform-updates.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

### AI overview

Postgres 17 is available on Heroku, which says it has simplified its upgrade process. Heroku Postgres handles provisioning, maintenance, backups, high availability, and monitoring. The article recommends keeping versions current for security updates, bug fixes, performance improvements, new features, and compatibility; it notes unsupported versions no longer receive community security releases. Heroku says each major version is supported for three years. The supplied excerpt ends during its description of the version lifecycle and provides no upgrade steps.

### Source excerpt

If you've ever deployed an app on Heroku, chances are you've used Heroku Postgres -- our fully managed, reliable, and scalable Postgres database service. It's the backbone for millions of applications, from weekend side projects to enterprise-grade systems running in production. But Postgres, like all software, continues to evolve. With new versions released each year, [...] The post Heroku Postgres Upgrade Guide: Simplify Your Move to Version 17 appeared first on Heroku.

[Next page](<https://devfeed.tech/topics/heroku-postgres.md?cursor=WyIyMDI1LTA1LTI5VDE1OjMwOjMyKzAwOjAwIiwgIjZkN2UzMmJmLTI4YzYtNDJkNy05ZGQ2LTBhOTEyYTE0MDc5MiJd>)