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

Select up to 5 tags to filter
Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

Hello AWS Community, I am experiencing a challenging issue with my AWS RDS Serverless V1 instance and seeking guidance. For about a month now, I've noticed a significant and unexplained increase in...
0
answers
0
votes
187
views
asked 9 months ago
Hi fam, I have this requirement, **DB alerts by query execution latency** , this means we need to set alarm one of our query running more that 5 second. but i did not find any metric...
1
answers
0
votes
264
views
layansp
asked 9 months ago
Hello All, We want some guidance, if the below design looks okay for our customer use case. And if someone already implemented such thing.. We currently have financial systems transaction data...
2
answers
0
votes
322
views
Veem
asked 9 months ago
We are observing consistently that the v2 serverless doesn't fall back to 0.5 ACUs when there is no activity on the database. It stays at 1.5-2 leading to 3 times the cost. I have attached two charts...
2
answers
0
votes
365
views
ruchit
asked 9 months ago
SQL Error [0A000]: ERROR: extension "hypopg" is not available Detail: Could not open extension control file "/rdsdbbin/aurora-15.4.15.4.1.18244.0/share/postgresql/extension/hypopg.control": No such...
2
answers
0
votes
253
views
subba
asked 9 months ago
Hello, I want to export data from some Aurora PostgreSQL database to a S3 bucket using `aws_s3.query_export_to_s3` ([related documentation...
2
answers
0
votes
323
views
Pierre
asked 9 months ago
When PostgreSQL is configured with `logical_replication = 1` and `synchronous_commit = off`, we see differing behavior between Aurora PostgreSQL and locally run PostgreSQL on Ubuntu. With locally run...
Accepted AnswerAurora PostgreSQL
4
answers
0
votes
409
views
asked 9 months ago
Hi, I'm trying to investigate high CPU load on my Aurora Postgres cluster. When inspecting the performance insight metrics i can see that it's always an SQL query called "Other" that seem to be the...
2
answers
0
votes
733
views
Matthis
asked 9 months ago
Hi, In a Aurora PostgreSQL table, we would like to setup TTL (Time-to-live) kind of thing, where rows will expire or will be deleted automatically after few hours/days. What is the best way to do...
1
answers
0
votes
2614
views
asked 9 months ago
Hi, Both Aurora Global database and cross-region read replica has many similarities. Could you please explain the exact difference between Aurora Global database and cross-region read...
1
answers
0
votes
1076
views
asked 10 months ago
I set up an Aurora Serverless v2 database in RDS. When I try to access the Query Editor, I get a message telling me I must first set up the Data API. When I tried to setup the Data API, the...
3
answers
0
votes
1226
views
profile picture
asked 10 months ago
How to rotate secrets(credentials) for Aurora mysql.postgresql using cloudformation. In the documentation, i see only its specified for RDS...
1
answers
0
votes
269
views
AWS
asked 10 months ago