Questions tagged [amazon-rds]

0 votes
0 replies
Migrating pmp-check-aws-rds from boto2 to boto3
I'm looking to use pmp-check-aws-rds to monitor my RDS instances using Nagios. The plugin is currently using Python2.7 and boto library. I was ab...
asked 1 month ago
1 votes
0 replies
Spring Boot Data JPA dropping commits with Postgres 9.5
Recently, my application has been seeing commits dropped and I am totally puzzled. No logs, no errors, everything continues as if things would be...
0 votes
1 replies
Does migration in a DB automatically gets reflected in read replica?
I created a read replica from Postgres DB in AWS RDS. Now if I run a migration in main DB will the read replica automatically migrate? 0 1 A...
0 votes
0 replies
Non AWS server connecting to AWS RDS database is much slower
I am migrating away from a hosting company who currently host my PHP-based web application and MySQL database on the same server. Their server s...
0 votes
1 replies
DATABASES is improperly configured rds postgres django
I had deployed my django app on elasticbeanstalk but when I am connecting with rds is shows this error: ImproperlyConfigured("settings.DATABA...
1 votes
0 replies
Postgres: copy database from one server to another on AWS RDS using PGAdmin
I have 2 postgres database instances on my aws account, basically they both run different engines of postgres and there is no way to downgrade. s...
0 votes
0 replies
Aurora connection from a EC2 in another region
My EC2 instance is in Asia Pacific (Sydney), and I have an Aurora Mysql in US East (N. Virginia). I tried to make the VPC peering connection, se...
-1 votes
0 replies
Is it possible to create a linked server between Amazon RDS and MySQL?
I have a RDS SQL Server and would like to create a linked server. Would just let to know if this is possible and what kind of steps would I need...
asked 1 month ago
0 votes
1 replies
Database Connection Error from Glue spark
I need to connect RDS Postgre db which is behind a VPC in a private subnet from Glue. I am not able to connect the db using Glue Connection which...
0 votes
0 replies
c3p0 with amazon postgres RDS
I'm trying to connect to RDS using c3p0, when not using RDS the code works but fails with RDS, pure java with DriverManager can create a connecti...
asked 1 month ago
0 votes
1 replies
Could not find S3 endpoint or NAT gateway for subnetId
I am unable to connect AWS Glue with RDS VPC S3 endpoint validation failed for SubnetId: subnet-7e8a2. VPC: vpc-4d2d25. Reason: Could not fin...
0 votes
1 replies
PostgreSQL queries not killed on app server shutdown
I have a WildFly which hosts an app which is calling some long running SQL queries (say queries or SP calls which take 10-20 mins or more). Prev...
1 votes
0 replies
How to connect to Oracle database running on AWS RDS using Rstudio
I'm using RJDBC to connect to the database, but I'm not able to connect to exact schema in which my target tables are located. I need some mecha...
1 votes
0 replies
Shutting down ExecutorService 'applicationTaskExecutor'
I have a Spring-boot application deployed in docker container within in AWS ECS cluster. My application stack is => Spring Boot -- JPA -- MyS...
0 votes
1 replies
AWS RDS and PDO don't work SQLSTATE[HY000] [2002] [duplicate]
This question already has an answer here: Connect to mysql on Amazon EC2 from a remote server...
0 votes
0 replies
replication from EC2 TO RDS AWS
In the context of a migration project towards RDS I would like to create a transactional replication between a SQL service instance put in premis...
asked 1 month ago
1 votes
1 replies
AWS RDS - creating a “replica” database daily automatically
Apologies if this isn't the right place to ask this question. I'm looking to create an automated copy (backup) of my AWS RDS (MySQL) database d...
asked 1 month ago
1 votes
2 replies
How to Connect to RDS Instance from AWS Glue Python Shell?
I am trying to access RDS Instance from AWS Glue, I have a few python scripts running in EC2 instances and I currently use PYODBC to connect, but...
0 votes
1 replies
Is there now a way to get all “AWS region names” for RDS, in boto3?
I'm trying to get all AWS region names for RDS, using boto3. However, it seems that the answers I get depend on the region I query. My script...
0 votes
0 replies
CloudFormation templates for Global Aurora Database
I am trying to write Cloudformation template to get a aws Global Aurora Database. However I am not able to figure out where and how to add the Gl...
1 votes
1 replies
Securing AWS RDS credentials for Lambda
Right now I am passing the username and password in as environment variables. The variables are retrieved from a different file so the cloudforma...
0 votes
1 replies
Node in EKS doesn't resolve DNS names of RDS (IP working)
Once again I shall require help from Stack Overflow :). We have a fresh public access endpoint EKS Cluster, an app inside the nodes that return...
0 votes
1 replies
AWS Cloudformation DB Instance IAM Roles
I'm trying to associate an IAM role with by DB Instance as documented here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMy...
1 votes
1 replies
Is it possible to load data into Amazon RDS from ETL tool (pentaho or SSIS)
i am just here stuck to choose one of the ETL tool (Pentaho or SSIS) My Source data will be on server and the destination data warehouse database...
asked 1 month ago
-2 votes
0 replies
Disaster Recovery In AWS
We are planning to do disaster recovery in aws and we are using RDS-PostgreSQL, Document Db in us-east-1. I want to want to create new infra in n...