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 am trying to connect to my Aurora PostgreSQL db, you must forgive me for I am new to AWS.
these settings keep returning this error in datagrip
> DBMS: PostgreSQL (no ver.)
Case sensitivity:...
2
answers
0
votes
3229
views
asked 9 months agolg...
Hello,
I'd like to get a cloudwatch alert setup when a failover event occurs. Does anyone know what I should be looking for in the postgresql.log or what cloudwatch metric I can use for this?...
3
answers
0
votes
544
views
asked 10 months agolg...
Redshift Federated query to postresql failing with ERROR: authentication method 10 not supportedlg...
We are trying to do Federated query from Redshift to Aurora PostgreSQL DB with Redshift version 1.0.51973 and Aurora PG latest version 15.2, please find the steps we followed for the...
1
answers
0
votes
1072
views
asked 10 months agolg...
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
0
votes
267
views
asked 10 months 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
414
views
asked 10 months 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
1627
views
asked 10 months 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
826
views
asked 10 months 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
1367
views
asked 10 months 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
226
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
612
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
300
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
224
views
asked a year agolg...