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.
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
310
views
asked 6 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
201
views
asked 6 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
231
views
asked 6 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
304
views
asked 6 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
430
views
asked 6 months agolg...
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
1630
views
asked 6 months agolg...
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
713
views
asked 6 months agolg...
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
904
views
asked 6 months agolg...
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
194
views
asked 7 months agolg...
An error occurred while calling o93.getDynamicFrame. The connection attempt failed.
The AWS Glue Visual Editor script is not working when I use same script to create a new job. The AWS Glue Visual...
3
answers
0
votes
421
views
asked 7 months agolg...
Received this event almost a week ago:
incoming-webhook
{"Event Source":"db-instance","Event Time":"2023-11-08 03:02:07.404","Identifier...
2
answers
0
votes
200
views
asked 7 months agolg...
Is it possible to run a Glue Crawler on an Aurora Postgres 15 Serverless v2 database?
Following this issue here:
https://github.com/awslabs/aws-advanced-jdbc-wrapper/issues/653
For the last few...
0
answers
0
votes
174
views
asked 7 months agolg...