Questions tagged [rds]

This tag might refer to Microsoft Remote Desktop Services, Microsoft Robotics Developer Studio, or Microsoft Remote Data Service. For Amazon RDS, please use the [tag:amazon-rds] tag instead.

This tag might refer to Microsoft Remote Desktop Services, Microsoft Robotics Developer Studio, or Microsoft Remote Data Service. For Amazon RDS, please use the tag instead.

For more info, please visit:

821 questions
6
votes
3 answers

AWS RDS Certificate Authority update

I recently received an email regarding a required update to my RDS Certificate Authority. The instructions on the RDS side seems straight forward:…
weber
  • 303
  • 2
  • 11
6
votes
2 answers

How to set DBParameterGroup Family property for Postgres 10.6

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 example: Family: aurora5.6. I tried Family:…
briancaffey
  • 1,637
  • 4
  • 20
  • 40
6
votes
1 answer

Cannot Delete ENI - RDS Already Deleted

I tried to deploy code to an ElasticBeanstalk environment. Every-time I try to deploy this branch to an environment EB kills all instances, ELB, RDS, etc and tries to rebuild but fails. This leaves the environment in a bad state because it deletes…
Joseph Crawford
  • 1,320
  • 1
  • 10
  • 29
6
votes
1 answer

Using docker with RDS (Prod), but confused about local DB setup (dev)

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 container-based DB (this is a requirement). I realize that…
Donald
  • 121
  • 1
  • 6
6
votes
2 answers

How to exclude some tables from RDS Mysql replication

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 temporary table tmp as (select * from tb); ...do not…
costamatrix
  • 500
  • 5
  • 15
6
votes
1 answer

Resize Shared buffer size in Postgresql hosted in AWS RDS

We are facing performance issue on Production Postgresql Database server which is hosted in AWS RDS server. So that we installed postgresql in EC2 instance Linux server for pre-production and tried with shared buffer value 15% of RAM value we get…
6
votes
2 answers

value of max_connections in AWS RDS

does anyone know where I can found the highest value of max_connections in AWS RDS? I'm primarily interested in the db.t2 instances running MySQL. I cannot find any appropriate link about that. Thanks!!
Jacob
  • 493
  • 1
  • 5
  • 18
6
votes
4 answers

Synchronize data from MySql to Amazon RedShift

We do some aggregation on huge datasets in Amazon RedShift, and we have some relatively small amount of data in MySQL. For some of the joins in RedShift we need the data in MySQL. What is the best way to synchronize the MySql data to RedShift? Is…
Gavriel
  • 18,088
  • 12
  • 63
  • 98
5
votes
1 answer

RDS logging not appearing for PostgreSQL

I followed the instructions here, the summary of my parameter group changes are shown here: I rebooted the instance and everything, and I got this new log file: Inside error/postgres.log, I only have this: 2018-03-13 12:39:38…
abbood
  • 21,507
  • 9
  • 112
  • 218
5
votes
1 answer

AccessDenied: Not authorized to perform rds:DescribeDBInstances

I'd like to programmatically list my RDS database instances and cluster snapshots, so I've attached the following IAM policy directly to one of my users: { "Version": "2012-10-17", "Statement": [ { "Sid":…
Rob Johansen
  • 4,576
  • 7
  • 37
  • 68
5
votes
2 answers

Can't access to RDS from Amazon Lambda, same VPC and correct role permissions

i can't successfully connect to RDS from Amazon Lambda in production. For Amazon Lambda i'm using Serverless framework, executing sls offline i can connect with RDS from localhost, but in production Amazon Lambda doesn't. Both are in same VPC, in…
fabian818
  • 57
  • 1
  • 7
5
votes
2 answers

Is it possible to dump a RDS database to S3 using AWS Data Pipeline?

Basically I want to pg_dump my RDS database to S3 using AWS Data Pipeline, I am not 100% sure if this is possible I got up to the stage where the SqlDataNode wants a selectQuery at which point i am wondering what to do. Below is my template so…
5
votes
2 answers

Amazon Postgres RDS pg_stat_statements not loaded

I configured my RDS Postgres 9.6.1 instance so, that the pg_stat_activity is loaded via 'shared_preload_libraries' parameter shared_preload_libraries=pg_stat_statements,pg_hint_plan The I rebooted my instance and then check if the…
Detlef Brendle
  • 103
  • 1
  • 6
5
votes
0 answers

EC2 instance can't connect to RDS, from same VPC/Subnet

I have one EC2 instance that can connect to RDS, and another that can't. They are in the same VPC/Subnet/AZ They have the same IAM role They have different (but similar) security groups, both allow all inbound The subnets are showing in the…
user31415629
  • 755
  • 4
  • 17
5
votes
1 answer

How to FIX AWS DMS to RDS connection Error?

I'm having a tough time connecting DMS instances to RDS instances and need some help. Situation: I've created Postgres and SQLServer RDS instances both with public access using the same (default) VPC and no SSL. I've added VPC inbound firewall rules…
garyM
  • 693
  • 2
  • 11
  • 26
1 2
3
54 55