MySQL version - 8.0.23 on RDS I am replicating my local database to AWS RDS MySQL instance. But I am getting this error: 2021-11-11T22:43:09.091947Z 378 [ERROR] [MY-010584] [Repl] Slave I/O for cha...

I have created two subnets for rds but still, I am getting error DB Subnet Group doesn't meet the availability zone coverage requirement. Please add subnets to cover at least 2 availability zones. ...

I have Postgres RDS instance which was available and working 7 days ago. Today I noticed in my app log, which is hosted in an EC2 instance that connectivity fails with FATAL: password authenticatio...

I'm running a v2 instance and from the documentation aws states you should only be paying for resources that you are actually using. I have an instance than is most of the time at 0 connections but...

I have created a deployment package for AWS Lambda with my python file and the dependencies including sqlalchemy and psycopg2. The code works perfectly in accessing the DB locally. But when I impor...

New to cloudformation. I am spawning PostgreSQL RDS instance using a aws cloudformation script. Is there a way to enable PostGIS (and other extensions) from aws cloudFormation script?

I had so much trouble doing this - I thought I would make a Q/A on StackOverflow to explain the process. The question is about copying an RDS postgres database for development usage - especially f...

I created a SQL Server RDS Instance in AWS and it seems to be up and running, but if I try to connect to it using Management Studio I get this error: Here is the text of the error: A network-relat...

[This is not a duplicate question] I have created a RDS MySQL instance with same Security Policy and under same VPC as my EC2 instance. However when i am trying to access the Instance from EC2 ma...

I need assistance as I'm having trouble connecting to a managed Postgres database on RDS. I'm encountering the following error message: "no pg_hba.conf entry for host '16.151.149.51', user 'an...

I am currently using Memory optimized DB class in AWS (8 CPUs) because some push notifications in our app cause the CPU utilization to skyrocket, but 99% of the time CPU utilization is at about 10%...

I'm trying to connect a local instance of Directus 9 running on Docker engine 20 on an macOS M1 to an AWS RDS Postgres 15. I'm able to connect to the RDS database ok locally with Postico, so public...

I am using AWS Amazon Web Service RDS for database. I have set up a database instance but how should I add the tables in that database instance or create any new tables in the database? Any idea ho...

I am trying to load data from the s3 bucket to amazon RDS database. I know this is not the programming question. But I really appreciate help. I have used the code below: aws rds restore-db-instan...

I'm having a hard time importing data from S3 into an RDS postgres instance. According to the docs, you can use this syntax: aws_s3.table_import_from_s3 ( table_name text, column_list text, o...

I have an AWS RDS instance up and running. When the DB is queried from my website (also on AWS, same region) it runs beautifully. But, if I try to connect to the database from my local developments...

The EC2 instance/live web can connect just fine to the RDS database. But when I want to debug the code in my local machine, I can't connect to the database and got this error: OperationalError: ...

This is a FastAPI project using SQLAlchemy and an AWS RDS postgres database. The waits (AAS) on database suddenly increase above 2 (for a 2 vCPU - t4g.small instance), and when checking on Performa...

I'm running an Aurora PostgreSQL (Serverless) cluster. After I deploy the infrastructure for the first time, and every time I re-deploy, I want to run database schema migrations (add tables, add co...

I can't seem to connect to my DB instance in AWS. I'm using the pg package and following the examples from the website is not working. A search for "aws postgres database does not exist" really is...

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR...

I'm trying to set the pg_trgm.word_similarity_threshold GUC parameter on an RDS postgres (13) instance. I have tried setting it with a post-deployment SQL script: SET pg_trgm.word_similarity_thresh...

I created a read-replica for an RDS instance, Does AWS handles the load-balancing automatically or it needs another configuration or implementation in the code ? and if so Is there a reference for ...

I am looking to use AWS RDS IAM database authentication with Ruby on Rails, as it allows a convenient way for AWS users to manage database permissions and avoid storing database passwords in their ...

I am trying to setup minimal permissions for doing aws rds copy-db-snapshot with a KMS encryption key: $ aws rds copy-db-snapshot --source-db-snapshot-identifier rds-backup-share- mysql --target-d...