Questions 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 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.
460 results
We're planning major version upgrades from Aurora PostgreSQL 17 to 18 and have hit a problem with the new optimizer statistics transfer in pg_upgrade. On our databases the statistics phase dominates t...
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 2 months 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 2 months 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...