All Content tagged with Database

I recently upgraded my Aurora serverless (v1) cluster to v2 having an engine version of 8.0.mysql_aurora.3.07.1. Why can't I enable backtracking at the moment? Is there any workaround without recreati...

Hello AWS Support Team, I am currently using an Amazon RDS PostgreSQL instance, and I need assistance in setting up a physical replica outside of AWS. The goal of this external replica is to have a lo...

I am looking for a viable approach to create a set of default users with different level of privileges into a DocumentDB instance (let's say read-only user, read/write user etc..). I do provision usi...

In my RDS Oracle (19c Oracle Standard Edition Two) there is no package rds_admin.rdsadmin_s3_tasks. Tried querying with DBA_SOURCE and DBA_OBJECTS as well and there is no such object. How to get this ...

"I recently encountered an issue where I received consecutive health check down alerts via email. One by one, all my sites went down, which run on different EC2 instances and connect to different RDSs...

Hello, I'm working with Amazon RDS for MySQL, and I need to know the default values for the following parameters: 1. interactive_timeout 2. wait_timeout I've checked the documentation but couldn't ...

Hi everyone, I found documentation on how to migrate things into Redshift serverless, but very limited resource for the other way around - migrating OUT of serverless to regular dc2. should I use the ...

Our PROD database ran into disk space issues and we had a lot of CDC data that was not created and was being retained in the SQL server transactional logs. CDC was enabled at the table level. When t...

I'm getting the following error when attempting to run a search query against OpenSearch domain. `"ConnectionError(HTTPSConnectionPool(host='search-osdomain7k309k4j-v82k34jcvhs-fvksd83874jflks43o....

I was trying to upgrade the version of Apache Airflow from 2.2.2 to 2.10.2 but I was getting the error with installing the packages in the requirement.txt file in dbt-redshift , dbt-postgres , dbt-cor...

When considering the configuration of connecting from Lambda to RDS, there are two main methods 1. Lambda→RDS Proxy→RDS 2. Lambda to RDS Let me ask two questions. 1. Is it best practice in the AWS ...

Hi, I have set up an Athena MySQL connector for federated queries to RDS. For some reason an extra column not present in my RDS table is added called "partition_name" all values set to "*". I have no...