# RDS for PostgreSQL

A managed Amazon RDS service for deploying and operating PostgreSQL databases, including upgrades, storage, replication, backups, and security.

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

## Fix circular role dependencies before upgrading Amazon RDS and Amazon Aurora PostgreSQL

DevFeed: [Fix circular role dependencies before upgrading Amazon RDS and Amazon Aurora PostgreSQL](<https://devfeed.tech/articles/fix-circular-role-dependencies-before-upgrading-amazon-rds-and-amazon-aurora-postgresql-4708.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/resolve-circular-role-dependencies-during-upgrades-of-amazon-rds-for-postgresql-and-amazon-aurora/>)

Author: Ravi Teja Adabala

Published: 2026-08-31T23:42:55Z

Content type: article

Language: en

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

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>), [Graphs](<https://devfeed.tech/topics/graphs.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [database](<https://devfeed.tech/tags/database.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This article explains how circular PostgreSQL role dependencies can cause major version upgrades of Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL to stall or roll back when upgrading from PostgreSQL 14 or earlier to PostgreSQL 15 or later. It describes a diagnostic query and steps to resolve the dependencies before the upgrade.

### Source excerpt

Circular role dependencies can stall or roll back a major version upgrade of Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL when you move from PostgreSQL 14 or earlier to 15 or later. Learn why this happens, how to detect it with a single pre-upgrade query, and how to clear it before you upgrade.

## Optimize your AWS RDS Dev Environments with Neon Postgres

DevFeed: [Optimize your AWS RDS Dev Environments with Neon Postgres](<https://devfeed.tech/articles/optimize-your-aws-rds-dev-environments-with-neon-postgres-5203.md>)

Original publisher: [Read original article](<https://neon.com/blog/development-environments-for-aws-rds-using-neon-postgres>)

Author: Brad Van Vugt

Published: 2024-07-16T12:24:14Z

Content type: article

Language: en

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

Topics: [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Developer experience](<https://devfeed.tech/topics/developer-experience.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Provisioning](<https://devfeed.tech/topics/provisioning.md>), [configuration](<https://devfeed.tech/topics/configuration.md>)

Tags: [aws](<https://devfeed.tech/tags/aws.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [developer-experience](<https://devfeed.tech/tags/developer-experience.md>), [development](<https://devfeed.tech/tags/development.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [product](<https://devfeed.tech/tags/product.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>)

### AI overview

The article explains why AWS RDS for PostgreSQL can be difficult and expensive to use for development, citing slow provisioning, complex configuration, weak support for shared team workflows, and data consistency challenges. It recommends using Neon for development while retaining RDS as the production database.

### Source excerpt

AWS RDS for PostgreSQL is the most widely-used hosted Postgres solution there is, so naturally we hear a lot from developers that use it. While it can be a solid offering, it's quite lacking when it comes to developer experience, and doesn't support modern developer workflows. We...

## How Proposales integrated Neon in their Postgres development workflow

DevFeed: [How Proposales integrated Neon in their Postgres development workflow](<https://devfeed.tech/articles/how-proposales-integrated-neon-in-their-postgres-development-workflow-5279.md>)

Original publisher: [Read original article](<https://neon.com/blog/frictionless-development-experience-with-neon-branching>)

Author: Raouf Chebri

Published: 2022-12-08T19:35:25Z

Content type: article

Language: en

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

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Docker](<https://devfeed.tech/topics/docker.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [data](<https://devfeed.tech/topics/data.md>), [Developer experience](<https://devfeed.tech/topics/developer-experience.md>)

Tags: [case-studies](<https://devfeed.tech/tags/case-studies.md>), [collaboration](<https://devfeed.tech/tags/collaboration.md>), [development](<https://devfeed.tech/tags/development.md>), [docker](<https://devfeed.tech/tags/docker.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [security](<https://devfeed.tech/tags/security.md>), [testing](<https://devfeed.tech/tags/testing.md>), [workflow](<https://devfeed.tech/tags/workflow.md>), [workflows](<https://devfeed.tech/tags/workflows.md>)

### AI overview

The article describes how Proposales integrated Neon database branching into its Postgres development workflow. Proposales kept AWS RDS for PostgreSQL in production but replaced shared development databases and local Postgres with Docker with isolated cloud database branches. This improved collaboration and testing while reducing conflicts, data-loss risks, security concerns, and local resource requirements.

### Source excerpt

Switching databases is like a heart transplant, and migrating all your database's production, staging, and development environments across providers is a risky process that requires significant effort and expertise, all of which can be quite intimidating. But you don't have to ch...

## Update Amazon RDS max\_connections with Parameter Group

DevFeed: [Update Amazon RDS max\_connections with Parameter Group](<https://devfeed.tech/articles/update-amazon-rds-max-connections-with-parameter-group-20076.md>)

Original publisher: [Read original article](<http://jollygoodcode.com/blog/2016/01/28/update-amazon-rds-max_connections-with-parameter-group.html>)

Published: 2016-01-28T15:46:52Z

Content type: tutorial

Language: en

Sources: [Jolly Good Code](<https://devfeed.tech/sources/jolly-good-code.md>)

Topics: [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [parameter](<https://devfeed.tech/tags/parameter.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds](<https://devfeed.tech/tags/rds.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [update](<https://devfeed.tech/tags/update.md>)

### AI overview

The article concerns updating the max_connections setting for Amazon RDS for PostgreSQL using a parameter group. It notes that default max_connections values differ by instance.

### Source excerpt

Do you use Amazon RDS for PostgreSQL? Do you know that, by default, each instance comes with a different number of max_connections?