Stack Overflow
Stack Overflow

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:

790 questions
7
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:…
t q
  • 4,593
  • 8
  • 56
  • 91
7
votes
0 answers

How to create a proxy connection on mysql workbench

My company is using http proxy connection to connect through the internet. I am trying to connect to my RDS MySQL instance on AWS by using MySQL Workbench. However, I get failed error. I need to configure my workbench to connect through my company…
Fady Berty
  • 71
  • 1
  • 5
7
votes
0 answers

Parameter group for SET GLOBAL foreign_key_checks in RDS

I am using RDS AWS for my mysql instance. Currently, i need to set global foreign_key_checks in RDS. but it says that I need a super priviledge access to do so. I realise I might miss to set the parameter group for this command. Could I know how to…
Robert Limanto
  • 2,068
  • 4
  • 17
  • 27
7
votes
2 answers

How to setup cross region replica of AWS RDS for PostgreSQL

I have a RDS for PostgreSQL setup in ASIA and would like to have a read copy in US. But unfortunately just found from the official site that only RDS for MySQL has cross-region replica but not for PostgreSQL. And I saw this page introduced other…
Randy Huang
  • 328
  • 3
  • 10
7
votes
4 answers

Cannot Delete Amazon RDS SQL Server Database

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
mee nothus
  • 191
  • 3
  • 7
6
votes
1 answer

rds_superuser role in postgres RDS server

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 that he had a role "rds_superuser" attached. (so I…
Tomislav Mikulin
  • 5,306
  • 4
  • 23
  • 36
6
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
  • 23,101
  • 16
  • 132
  • 246
6
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
  • 5,076
  • 10
  • 40
  • 72
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,470
  • 1
  • 15
  • 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
  • 131
  • 1
  • 1
  • 7
6
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…
Jesse Whitham
  • 824
  • 9
  • 32
6
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
  • 925
  • 6
  • 25
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
  • 670
  • 8
  • 17
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
  • 595
  • 1
  • 7
  • 25
6
votes
2 answers

ERROR 1465 "Triggers can not be created on system tables" after restore from SQL created by mysqldump

I'm running a mysql 5.6 server on amazon RDS and set up a read replica I use to create backups using mysqldump. I tried with the "--all-databases" option, but when I'm trying to import the SQL created by mysqldump, I end up with this error from the…
Bernhard
  • 665
  • 1
  • 6
  • 22
1 2
3
…
52 53