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
10
votes
2 answers

aws rds, lost connection to MySQL server during query, when importing large file

I try to import an 1.4G mysql file into aws rds. I tried the 2 cpu and 4G mem option. I still got error: Lost connection to MySQL server during query. My quetion is that how do I import large mysql file into rds.
kenpeter
  • 7,404
  • 14
  • 64
  • 95
10
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…
Manivannan Thirugnanam
  • 827
  • 12
  • 18
10
votes
1 answer

Why would a rails 5 upgrade drastically increase database CPU usage?

I upgraded a production app from rails 4 to rails 5 a few days ago, and I have seen a big increase in CPU utilization on my RDS postgresql instance. There does not seem to be any associated increase in database requests or decrease in speed. What…
nbrustein
  • 727
  • 5
  • 16
10
votes
2 answers

Restore only one database in an AWS RDS Sql Server instance

If there is corruption in one database in an AWS sql server RDS instance, what is the best way to restore that one database? The backups are of the whole instance so you wouldn't want to restore from AWS backups and lose data on the other good…
user1473443
  • 133
  • 1
  • 5
10
votes
1 answer

Clipboard operations in Delphi

Local workstation: Win 7 Terminal Server: Win 2008 Server Outlook: 2003 running on local workstation. I'm trying to implement copying and pasting of Outlook messages from local workstation to terminal server. Using the code below, I am able to copy…
fr21
  • 1,746
  • 7
  • 26
  • 45
10
votes
2 answers

On RDS can I create Tables in a Read Replica that are not present on the Master?

We have a separate RDS Instance to handle session state tables, however found that the session DB load is very low. if we can convert the instance handling session as a Read Replica of the main DB, then we can use it for read-only tasks that are…
Subramanyam
  • 101
  • 1
  • 4
9
votes
2 answers

pg_dump: how to install on Amazon Linux for PostgreSQL 9.5.2?

I used to install and do: $ sudo yum install -y postgresql94-server postgresql94 $ pg_dump -h name-of-db.us-east-1.rds.amazonaws.com -U user dbName > dump After RDS upgrade to 9.5.2 I get this: pg_dump: server version: 9.5.2; pg_dump version:…
Amir Mehler
  • 4,140
  • 3
  • 27
  • 36
9
votes
1 answer

RDS snapshot restore taking too long

As part of our blue-green deployment strategy we are snapshoting the prod RDS instance and then restoring this snapshot into a new instance applying db migrations after it and linking the newly Green application to it. Our RDS instance has a 100 GB…
user1990009
  • 855
  • 1
  • 7
  • 16
9
votes
2 answers

How to set Amazon RDS SQL_MODE with multiple values

MySQL allows parameter SQL_MODE to be set to multiple values in the my.cnf file. How can I do the same on Amazon RDS? UPDATE: This problem has been fixed...see below.
jago
  • 457
  • 3
  • 7
  • 15
8
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
  • 2,339
  • 6
  • 34
  • 62
8
votes
3 answers

Is there a way to have AWS RDS Public Accessibility = No but still accessible outside of EC2 instance?

For management-related reasons, I need the Public Accessibility option set to "No" for the RDS. However, we're also looking into being able to access the RDS from our local devices. The only way we're able to do so is by selecting "Yes" in Public…
ZekiraDrake
  • 155
  • 1
  • 2
  • 10
8
votes
2 answers

Amazon RDS Postgres -> Give permission to pg_catalog

I need to grant permission to the master user(MasterUsername) the access of of pg_catalog. GRANT USAGE ON SCHEMA pg_catalog TO ; On running this, I get the below warning: WARNING: no privileges were granted for…
Pavanraotk
  • 1,097
  • 4
  • 15
  • 33
8
votes
1 answer

Slow PostgreSQL sequential scans on RDS?

I have an RDS PostgreSQL instance that's running simple queries, much slower than I would expect - particularly sequential scans, like copying a table or counting a table. Eg. create table copied_table as (select * from original_table) or select…
jastr
  • 881
  • 1
  • 9
  • 19
8
votes
4 answers

Unable to select Database Foo using Ec2 and RDS

I have set up an RDS Database Instance with a security group where I use my EC2 Elastic IP as my CIDR/IP. I have also associated the security group with my EC2. My security group on the EC2 Instance looks like this. I associated one of the 3306…
Eric Brotto
  • 53,471
  • 32
  • 129
  • 174
7
votes
2 answers

How to get password of the Amazon aws rds user?

I can see there is a user from my aws rds console, AWS Console -> RDS -> Databases -> Configuration -> Availability But I forgot what was the password of this user? How can I see/ retrieve the password? Moreover how can I add new users for my…
Sazzad Hissain Khan
  • 37,929
  • 33
  • 189
  • 256
1
2
3
…
52 53