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.
Hello,
I'm trying to figure out if there is a way with Aurora Serverless v2 to migrate tenants from one db instance to another.
Say for example that I'm using "Aurora Serverless v2 - Postgres...
1
answers
1
votes
315
views
asked a year agolg...
I need to migrate some large object data from pg_catalog and for that I need lo_compat_privileges to be set to ON but I can't do this as it is not modifiable. Is there a way to modify this?
Thanks
1
answers
0
votes
511
views
asked a year agolg...
Hi,
I have around 15 RDS instances, most of them Aurora Postgres. I want to check the cost at the instance level so I can know which instances are used more. Is there a way to check the cost per...
3
answers
0
votes
1993
views
asked a year agolg...
## Background
We are trying to migrate a relatively large table with 200+ million rows from the Aurora PostgreSQL source to the DynamoDB target. While reading the guide, ["Using an Amazon DynamoDB...
1
answers
0
votes
1008
views
asked a year agolg...
I have my Aurora Postgres cluster configured to log slow queries (log_min_duration_statement: 1000). How can I setup a Cloudwatch alert to notify me when a query's average speed exceeds this?
Or do I...
2
answers
0
votes
1628
views
asked a year agolg...
Hi experts,
Currently, we are using the point-in-time recovery for Aurora Postgres. However, this will create a new cluster which our service is not connected to. We are currently manually dumping...
1
answers
1
votes
298
views
asked a year agolg...
Several issues:
1. AWS Auto-generates code that lists the struct type as an "Object" which fails:
ChangeSchema_node1685651062990 = ApplyMapping.apply(
frame=AWSGlueDataCatalog_node1685651050820,
...
1
answers
0
votes
683
views
asked a year agolg...
Hi Team,
Aurora postgre SQL we dont have point in time recovery option on snapshot level
Automated back up option and We do see point in time recovery option on the CLuster level.
Is this how it...
1
answers
0
votes
390
views
asked a year agolg...
We've are using Aurora Serverless V1, using PostgreSQL 11, and are running into some issues that *might* be caused by eventually consistent reads, but I'm having a hard time finding documentation for...
1
answers
0
votes
274
views
asked a year agolg...
I'm trying to convert coordinates in and out of the OSGB 1936 / 27700 / "British National Grid" projection, but I'm getting different results to our old Postgres 9.x local DB. For example, for this...
1
answers
0
votes
315
views
asked a year agolg...
I recently migrated a 6TB Postgresql database from RDS to Aurora. Within the first week and with what I would consider relatively light activity, I saw my BackupRetentionPeriodStorageUsed peak at 42...
1
answers
0
votes
259
views
asked a year agolg...
My system has a write intensive workload largely consisting of deletes and inserts. The work is applied by drawing from queues such that I can control the concurrency. The transactions touch about...
0
answers
0
votes
120
views
asked a year agolg...