All Content tagged with Aurora PostgreSQL
The PostgreSQL-compatible edition of Aurora delivers up to 3X the throughput of standard PostgreSQL running on the same hardware, enabling existing PostgreSQL applications and tools to run without requiring modification.
Content language: English
Filter content
Select tags to filter
Sort by
Sort by most recent
535 results
Sakshi_AryaSUPPORT ENGINEER
published 11 days ago3 votes88 views
When using LIST-partitioned tables on Aurora PostgreSQL or RDS for PostgreSQL, teams often track per-partition row counts for load balancing decisions. A common approach — row-level triggers updating ...
Hi,
We have setup a Aurora PostgreSQL database with a serverless V2. We have our applications hosted in EC2 instances and are connecting this DB.
All of sudden, the application stopped working, we h...
We are using postgres 17.9 in aurora gov cloud.
I have attempted a direct and a blue/green upgrade.
Extensions — only plpgsql, btree_gin, btree_gist, ltree, pg_stat_statements, pg_trgm, uuid-ossp ins...
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 ...
## Summary
The PostgreSQL `vacuumlo` utility removes orphaned large objects from a database to reclaim storage. However, `vacuumlo` only inspects columns with the native `oid` data type when determin...
asked a month ago
Is it possible to configure AWS Database Migration Service (DMS) in Full Load + CDC mode using an Amazon Aurora PostgreSQL Read Replica as the source? The goal is to capture ongoing data changes and r...
asked a month ago
Hello,
I have a Aurora PostgreSQL cluster and I see the following "Pending Maintenance" tasks:
1) New Operating System patch is available (os-upgrade)
2) Upgrade to platform version 4 (serverless-pla...
Hi everyone,
I am seeking guidance on an issue we encountered during testing a database upgrade. We recently received a notification from AWS that our RDS PostgreSQL minor version is being deprecated...
How to migrate a, aurora postgres instance from PG13 to PG16 ?
Which is the best way to do it that AWS recommand ?
We try with Blue/Green deployment and we have this error :
Creation of blue/green d...
On the case, but not limited to this origin:
Origin: Aurora-postgres
Destination: Redshift
When a varchar/nvarchar length changes in the source table, it does not get applied to Redshift; it appears o...
A table with approximately 1,000 rows and a primary key has been stuck in **ResyncInitiated** state for over 2 hours after triggering a refresh via `ALTER DATABASE INTEGRATION REFRESH TABLE`.
T...
[Aurora Postgres 17][Bug?] INSERT ON CONFLICT against parent table works, but logs error with invalid ON CONFLICT clause
```
Instance Family Class: db.t4g
PostgreSQL 17.5 on x86_64-pc-linux-gnu, com...