Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
2
votes
0 answers

AWS Lambda links not working with RDS Postgres

I'm using Ruby on Jets (Rack based framework for AWS Lambda) for an AWS Lambda and using a Postgres RDS DB. All of my functions are now implemented but when I test or click and API endpoint through API Gateway, it times out and with a test, I get an…
Demian Sims
  • 871
  • 1
  • 14
  • 29
2
votes
3 answers

Connect to postgres RDS from ec2 using Sequelize

I created an ec2 instance, in default VPC, and configured my node.js project as I do on my local machine. I created RDS postgres instance in the default VPC and permitted all the traffic. After this I tried to run migrations from ec2 with "npx…
2
votes
1 answer

To delete a shared or public snapshot, you must use the log into the AWS account that owns the snapshot

I created a test PostgreSQL instance in AWS and deleted the instance but public snapshots are growing more. when I'm trying to delete those, it is saying 'To delete a shared or public snapshot, you must use the log into the AWS account that owns the…
abhimanyu
  • 730
  • 1
  • 10
  • 23
2
votes
1 answer

How to look at slow query logs for aurora serverless

I have created aws aurora mysql with serverless option. For parameter group I have set slow_query_log = 1 slow_query_log_file = /rdsdbdata/log/slowquery/mysql-slowquery.log log_output = TABLE When I connect to the instance and run show global…
kumar
  • 8,207
  • 20
  • 85
  • 176
2
votes
1 answer

Get current CPU utilization of AWS RDS through lambda python function

I tried the following code to get current cpu utilization of AWS RDS through lambda python.But i am getting the empty values: code: import json import boto3,datetime def lambda_handler(event, context): cloudwatch = boto3.client('cloudwatch') …
2
votes
1 answer

How to get credentials for a RDS read replica?

I have created a read replica for my Production RDS instance, However I don't know where can I see the log-in credentials of the replica. When I go to the secrets manages screen and try to create a new secret the replica instance is not present. And…
2
votes
0 answers

AWS Lambda RDS Proxy - Not able to select RDS Instance

I am not able to select any RDS instance from my lambda to setup a database proxy. I already created 3 different types (mysql, mariadb, aurora) and it never shows me a RDS instance to select. What do I have to do to be able to select a RDS Instance…
2
votes
1 answer

RDS not reachable when created with terraform

I've been trying to create RDS instance using terraform. The problem that I've been strugling with is that every time I create new instance, it's not reachable. I'm creating it in subnets group containing public and private subnets, security group…
2
votes
1 answer

Terraform IF condition

I'm working on AWS rds postgresql instance and we are using IAM authentication. I've created couple of roles, But for one role, I need to give a grant permission. I tried to use if condition but i'm getting an error that null values are not allowed…
2
votes
0 answers

ECONNREFUSED 127.0.0.1:5432 RDS, Postgres

I've been stuck on this error for quite a long time, and am reaching out to see if anyone knows what to do! I'm making an endpoint using Lambda that I want to, when hit, first insert a contract into a postgres db running on RDS and then insert the…
kp99
  • 21
  • 2
2
votes
1 answer

Is the server running on host accepting TCP/IP connections on port 5432?

I'm aware of similar topics. After applying the solution that has worked for many I'm still stuck with the same error. My RDS db instance with open port 5432: EC2 instance in which the db instance resides. Please note inbound rules applied: The…
mr_incredible
  • 837
  • 2
  • 8
  • 21
2
votes
0 answers

AWS RDS Serverless Data Types

I've asked this in the AWS RDS forum but received no response. I thought I'd try here. AWS RDS serverless returns metadata for columns in a query response. The metadata inlcudes an integer Type and a string TypeName for each column. Is there a list…
David U
  • 943
  • 1
  • 8
  • 22
2
votes
1 answer

Can't Connect to RDS mysql DB from Wordpress on Amazon linux EC2 Instance

I am getting Error establishing a database connection while trying to connect to mysql on Amazon RDS from my Wordpress instance. Wordpress is on my AWS Linux EC2 Instance, both are on the same VPC, same Security Group allowing 3306 inbound rule, db…
2
votes
1 answer

How to extract only change data (CDC) in AWS RDS (Postgres database) and dump change data to another RDS postgres instance?

Is there a way to capture only change data in RDS Postgres instance and write those change records to another RDS Postgres DB instance for later use? I have looked on few option like using Debezium but it doesn't seems to be helpful as I don't have…
MK dev
  • 67
  • 1
  • 9
2
votes
1 answer

Can you rely solely on security groups to securely restrict access to Publicly Accessible RDS?

I am trying to balance convenience/cost vs security while setting up RDS and lambda. My ultimate goal is to make the architecture as simple and cheap as possible while keeping it secure. I have a couple of basic requirements that gives me a headache…
imdev83
  • 23
  • 3