Questions tagged with Aurora PostgreSQL
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.
I have some database on my RDS but suddently when i want to check the database was gone meanwhile i have the record, how it can be happend? is the anyone outside can help me how to recovery the...
2
answers
0
votes
277
views
asked 4 months agolg...
I'm trying to use the new Aurora resolver tools in Appsync, but it seems that the select utility function is incomplete.
It appears that there is not a supported operator for IN LIST, so my backup...
0
answers
0
votes
80
views
asked 4 months agolg...
Hi there.
I noticed that the Aurora reader instances that are added by the autoscaler do not use the newer CA. It always uses the default rsa-ca-2019.
Since I already updated all of my Aurora...
2
answers
0
votes
157
views
asked 5 months agolg...
Hi Team,
I am unable to check aurora MySQL database replication via AWS console, But i am able to see MySQL replication lag. Can someone tell me how to check this?
1
answers
0
votes
254
views
asked 5 months agolg...
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
170
views
asked 5 months agolg...
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
191
views
asked 5 months agolg...
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
185
views
asked 5 months agolg...
Aurora Serverless v2 doesn't go back to 0.5 ACUs even when there is no activity on the databaselg...
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
291
views
asked 5 months agolg...
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
182
views
asked 5 months agolg...
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
206
views
asked 5 months agolg...
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
259
views
asked 5 months agolg...
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
361
views
asked 5 months agolg...