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
532 results
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 ...
2
answers
0
votes
23
views
asked a day ago
## 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...
0
answers
0
votes
37
views
asked 7 days 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...
1
answers
0
votes
51
views
asked 13 days 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...
Accepted AnswerAurora PostgreSQL
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...
2
answers
0
votes
67
views
asked a month ago
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...
Accepted AnswerAurora PostgreSQL
4
answers
0
votes
124
views
asked a month ago
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...
1
answers
0
votes
69
views
asked 2 months ago
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...
3
answers
0
votes
113
views
asked 2 months ago
[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...
1
answers
0
votes
44
views
asked 2 months ago
Taylor ChuEXPERT
published 2 months ago1 votes289 views
This guide provides an AWS CLI and Bash script using `jq` to automate parameter group migration across **all RDS engines** — including PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and Aurora.
Hello,
We are planning to upgrade our Aurora PostgreSQL cluster from version 14.x to 17.x using Blue/Green Deployments. The minimum required version for this approach is 14.9 or later. Since our curre...
2
answers
0
votes
95
views
asked 2 months ago
Francesco PentaEXPERT
published 3 months ago0 votes1.2K views
This article provides general guidance on migrating Database resources from one region to another using a logical dump.