Questions tagged with PostgreSQL
Amazon RDS makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud.
Content language: English
Filter questions
Select tags to filter
Sort by
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
844 results
Hi team, I see that Amazon Aurora PostgreSQL 18.3+ already natively supports zero-ETL pipelines to Amazon Redshift. However, our current architecture relies on standard Amazon RDS, and we are planning...
**Starting a new backend process costs ~27 ms of CPU on RDS PG 17.11, versus
~4.5 ms on 14.19.** Because PostgreSQL forks one process per connection, and our
API opens 40–120 new connections/second, t...
In CloudWatch database insights, the SQL text is being truncated shorter than both `track_activity_query_size` and `pg_stat_statements.max`
The parameter group is applied and in sync, and the previous...
I'm running a Node.js/NestJS app on ECS Fargate (`awsvpc` network mode) connecting to RDS PostgreSQL in the same VPC. On a **genuinely fresh task's first boot**, my app makes two DB queries concurrent...
I am evaluating moving their TEMP tablespace to local NVMe (instance store) for temporary/sort operations, since high-IOPS workloads on EBS can become expensive — and TEMP I/O is a significant contri...
asked a month ago
I’m trying to understand the lifecycle behavior for an Amazon RDS for PostgreSQL instance after PostgreSQL 13 reached RDS end of standard support on February 28, 2026.
The instance was still running ...
## Summary
An RDS Proxy in front of an Aurora PostgreSQL cluster never accepts client connections. Every TCP connection attempt to the proxy's listener port times out, even from a Lambda function pla...
I'm unable to connect to my RDS MariaDB instance and need help troubleshooting the connection issue.
**Environment:**
* Engine: MariaDB 10.11.15
* Instance Class: db.t3.micro
* Region: e...
I created a Blue-green deployment from my postgres db, from 14 to 18 version.
Everything says that is available I can see the blue and green deployment great.
The main issue is when I tried to switc...
I have an Amazon RDS for PostgreSQL source table that is being replicated continuously using AWS DMS Serverless in CDC mode. `pglogical` is enabled, and the DMS task reads from PostgreSQL and sends th...
I have a AWS CDK defined Aurora database cluster, with engine version 6.11. I want to upgrade it to 17.9
Doing so on a small test cluster from the Console seemed to work without deleting the data and ...
### AWS DMS CDC Fails with ORA-24806 or "Converter not found" (Postgres to Oracle CLOB)
I am running an AWS DMS CDC task to sync an **AWS RDS PostgreSQL (v18.1)** source to an **AWS RDS Oracle 19 SE*...