I created an AWS VPC with public and private subnet. I created an RDS(MySQL) inside private subnet. I want to access the RDS from internet (From my home machine). I have kept the flag Publicly Ac...

I wanted to create a replicate of my production database for staging and created the staging DB instance from a production snapshot. However, this new instance still has the Database Name: "product...

I am trying to create a DMS task to migrate data from RDS Postgres instance to S3 bucket. The full load works all fine, but the continuous replication is failing. Its giving this error: "logical d...

I can see there is a user from my aws rds console, AWS Console -> RDS -> Databases -> Configuration -> Availability But I forgot what was the password of this user? How can I see/ re...

Our database was running 16 GB of ram, 4 vcpu and 60 GB of disk (m4.xlarge aws rds machine) 3 months ago, and it was running fine until, from one moment to another, it started with an increase of t...

Terraform allows you to define Postgres master user and password with the options username and password. But there is no option to set up an application postgres user, how would you do that?

I'm trying to write a Lambda function using Node.js which connects to my RDS database. The database is working and accessible from my Elastic Beanstalk environment. When I run the function, it retu...

I created an Amazon Aurora instance in my VPC. When the instance was created, it came with 2 endpoints, a writer and a reader endpoint. The instance is using a security policy with an ingress rule...

I've tried two methods and both fall flat... BULK INSERT TEMPUSERIMPORT1357081926 FROM 'C:\uploads\19E0E1.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = '\n') You do not have permission to...

I got the same answer everywhere on the internet regarding my question of how to get the IP address of an RDS instance in AWS, but I don't know what dig is, and how to use it. How to allocat...

For management-related reasons, I need the Public Accessibility option set to "No" for the RDS. However, we're also looking into being able to access the RDS from our local devices. The only way w...

I'm designing a Rails webapp using Docker and for a variety of reasons, I'd like to use RDS in the Production environment for its configurability & durability purposes, rather than a Docker con...

If there is corruption in one database in an AWS sql server RDS instance, what is the best way to restore that one database? The backups are of the whole instance so you wouldn't want to restore fr...

I recently received an email regarding a required update to my RDS Certificate Authority. The instructions on the RDS side seems straight forward: https://docs.aws.amazon.com/AmazonRDS/latest/UserG...

Ive created an instance/database on aws and when I try to connect to it through my terminal, by running the code below, I get an error. The line I run in the terminal is: psql --host=testdb.c7hgi...

AWS recently announced the need to: Update Your Amazon RDS SSL/TLS Certificates by October 31, 2019 I have a Rails application hosted with a classic Elastic Beanstalk load balancer, which conn...

I want to run an old .NET application in a docker windows server container (https://hub.docker.com/r/microsoft/windowsservercore/). Everything would be easy if this application didn't require an U...

i have a cluster structure on RDS (master/slave)...and all the temporary tables created on the master are replicated on the slave. I don't want that.... I want that statements like: create te...

I've made a mistake in the naming scheme of a database on an Amazon RDS SQL Server instance but don't seem to have permissions to delete it Can anybody give me any guidance? Thanks

I'm using Postgres 10.6 with RDS. I'm trying to setup a DBParameterGroup to set some custom parameters, but I'm not sure what to put for the family name in CloudFormation. The documentation had one...

I want to launch an RDS instance from CloudFormation. I am constructing the JSON template based on the AWS documentation . I want to set the PreferredBackupWindow parameter, but there is no examp...

I used to install and do: $ sudo yum install -y postgresql94-server postgresql94 $ pg_dump -h name-of-db.us-east-1.rds.amazonaws.com -U user dbName > dump After RDS upgrade to 9.5.2 I get thi...

I'm migrating our WordPress database to RDS which is also being used by other services in our infrastructure. But I couldn't find any configuration option for wp-config.php where I could specify th...

I want to update an Enum in RDS Mysql and add a value to an column. I have huge data existing in the same table which I want to update. I assume that while updating the schema of the table, the tab...

I just created a new postgres RDS instace on aws (through the dashboard), and I gave it a default user, lets call him "jack". When I logged in to the instance, I saw my created user "jack", and th...