Questions tagged with Database

What happens *specifically* when the AWS RDS Database that's being accessed through an RDS Proxy doesn't have any connections to give? I've found the following information in the [RDS Proxy user...

Our current setup involves AWS Glue in operation, where data is being extracted from one SQL Server and loaded into another SQL Server through use of AWS Glue Studio for selected tables. Is there a...

I am trying to migrate some oracle DB schemas from RDS1 to RDS2. I used the instructions in this link for export /import of few schemas using data pump API since I dont have access to Operating...

Following [this guide from AWS about Enabling cross-Region automated backups](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html#AutomatedBackups.Replicating.Enable), I...

Hello all, I see multiple docs on the internet, stating the difference between aurora Mysql and aurora postgres. But I want to understand the real views of the experienced folks here. While we are...

How do I connect Amazon RDS - Microsoft SQL Server through Glue Spark type jobs using python?

Upon trying `CREATE EXTENSION postgis_sfcgal;`, I got the following error: "ERROR: Could not open extension control file "/rdsdbbin/postgres-15.4.R1/share/extension/postgis_sfcgal.control": No such...

Hi, We are currently investigating the use of the Timestream Athena connector (https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html) as a way of enabling our data teams to work...

Hello, I've recently re-architected my application, which is written in Ruby on Rails and uses a PostgreSQL 13 database, from a setup where everything was in public networks, as shown in the attached...

I'm seeking guidance on a specific requirement and the recommended approach to achieve it. My data is currently stored in an AWS Aurora SQL database (let's say host1/db1) . The objective is to...

Hello, When are you planing to upgrade to latest 11.x version of MariaDb. This is an important version that brings a major and crucial update as there is a change to MariaDb Query optimizer which...

Hello All, We have not used partitioning in mysql before. Now that we are opting for daily range partitioning on a date column of a table in AWS Aurora mysql. I have few questions around same ...