Questions tagged with Database

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 ...

I have an RDS MariaDB setup with 2 replicas. I have sucessfully used Blue/Green deployments with this setup before. Now though, when I try to create a new Blue/Green deployment the process fails after...

Hi I'm creating a table with a crawler but when I run it does it succesfully but when I checked the tables isn't appearing even when in the crawler Table changes from last run appears table created....