Questions tagged [amazon-rds]

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

Filter by
Sorted by
Tagged with
2
votes
2answers
996 views

Minimum permission to execute sp_changedbowner SP

Is db_owner permission sufficient to execute sp_changedbowner? I'm looking to change the database owner of a RDS SQL instance. I'm the owner of the DB, and still couldn't execute sp_changedbowner as ...
1
vote
0answers
369 views

RDS ran out of space

I moved a 2 25 GB databases to an RDS instance with 100 GB of SSD storage allocated. However, I see that I only have 2 GB of space left! What can cause this behaviour? At first I thought logs, but ...
1
vote
1answer
89 views

AWS RDS showing more disk usage than PgAdmin statistics

I am using AWS RDS to host one PostgreSQL database. I notice that the disk usage at the AWS dashboard is much more (2x) than what is shown at PgAdmin. Hopefully someone can help me to figure out it. ...
0
votes
1answer
71 views

Simple Query intermittently returning 0 results

I'm having a strange problem and need help troubleshooting. if I run this query on my gallery table: SELECT * FROM `gallery` WHERE awarded = 1 ORDER BY awarded_date DESC LIMIT 29 OFFSET ...
1
vote
1answer
151 views

Know what tables each user is accessing

I have a database with a lot of users, all of them with full read privileges on all the tables but not all the users are reading all the tables. I want to have each user having as little privileges as ...
1
vote
2answers
585 views

Why does my query hang when I put one more id in where statement? [closed]

I have a query that looks like select count(*) FROM (joins) WHERE customer_id in (select id from customer limit 117) AND ... (more statements) It involves tables with several hundred million ...
1
vote
0answers
624 views

can't create schema as admin

I have a user dbadmin, which has the highest permissions possible in AWS RDS. Using dbadmin I created a database, foo, owned by fooadmin. As fooadmin, I can CREATE SCHEMA in that database. As ...
3
votes
1answer
571 views

Issues with GRANTing permissions to AD group

I have couple of Active directory groups authenticated to access my RDS SQL Server instance. I have granted access to a AD group to perform ALTER ANY connection with GRANT. When I log in as a user ...
0
votes
1answer
1k views

PostgreSQL on Amazon RDS: out of memory error on bytea field > 64MB

I am attempting to dump a modestly sized (less than 3GB) database from Postgres 9.5.4 running on Amazon RDS. The instance is a db.m4.xlarge, which has 4 virtual cores and 16GB RAM. It's using the ...
0
votes
1answer
50 views

How to make a table read/writes faster? [closed]

I am using AWS RDS DB in my web application. The problem is a table which has millions of rows in it and the number of reads/writes per second on the table are huge. This happens even though I have DB ...
0
votes
1answer
439 views

AWS RDS same file_guids

Getting this error on AWS RDS with MS SQL Database XXX cannot be restored because there is already an existing database with the same file_guids on the instance. I've imported from S3 once, it ...
4
votes
1answer
993 views

How to grant set the replication attribute on RDS PostgreSQL?

On the AWS RDS documentation I see that rds_superuser can: Grant and revoke the replication attribute onto all roles that are not the rds_superuser role. For more information, see this section in ...
0
votes
1answer
395 views

Best way to create a daily snapshotted read-only db in RDS?

We have a PostgreSQL db instance in RDS. In our application we need to run a daily export in the early hours of every day, the export and transformation may take some time and one issue we've found is ...
0
votes
0answers
2k views

Understanding swap impact on a small RDS with PostgreSQL

I have a db.t2.micro that regularly refresh materialized views with around 2 millions lines. I'm trying to understand how it's bad or not to have swap like this. The instance is When I fetch data it'...
5
votes
1answer
1k views

Refresh Materialized View impact on the DB

Hi we are running an PostgreSQL 9.6 database in Amazon RDS under a m4.large(2cpu 8gb) and a provisioned IOPS of 1000. The use case is the following: We have a table with several million of registries (...
1
vote
1answer
144 views

MySQL data precision confusion

I have two tables with same column. First table: DESC orders; Field Type Null Key Default Extra order_id int(8) unsigned zerofill NO PRI (null)...
3
votes
3answers
3k views

What can cause a rapid drop in RDS MySQL Database free storage space?

How could my MySQL database on Amazon RDS have recently gone from 10.5 GB free to "storage-full" status within about 1.5 hours? It's a 15GB MySQL 5.6.27 database running on a db.t2.micro instance. ...
0
votes
2answers
361 views

MySQL query optimization not using index

I'm running into an issue with my MySQL database and I would like to know if any of you could please shed some light. Background: I currently have entire schema configured with InnoDB. This database ...
1
vote
2answers
751 views

AWS RDS MariaDB replication to GCP Cloud SQL or Azure SQL DB

For disaster recovery, I need to replicate an Amazon Multi-AZ RDS instance currently using MariaDB to a different platform like Google Cloud Platform or Azure. If AWS is down for more than 30 minutes, ...
1
vote
1answer
40 views

How to solve this complex insertion problem

In our database we store policycase records. A policycase has a 1:1 relation to a (requested) policy record. The policy record has a 1:n relationship to policy_map. Where policy_map is a key, value ...
3
votes
2answers
679 views

AWS RDS Really Odd Error… #1041 OUT OF MEMORY, Buffers OK and Memory OK

I have an AWS RDS (MySQL 5.6.35) db.m3.medium that has given me a random error when attempting to modify a table's structure in the past two weeks: #1041 - Out of memory; check if mysqld or some ...
5
votes
2answers
1k views

Repacking RDS database with pg_repack isn't online

While running pg_repack on a RDS Postgresql 9.6.3, got this failure for one of writers: ProgrammingError: permission denied for relation log_24034858 CONTEXT: SQL statement "INSERT INTO repack....
2
votes
1answer
410 views

50% CPU usage on MySQL RDS instance (db.m3.medium) with 0 connections

We have a MySQL RDS instance which is still utilizing ~50% CPU after stopping our applications and terminating all connections (e.g. from MySQL workbench). The mysql-error-running.log is showing: ...
1
vote
2answers
499 views

AWS RDS Post Optimisation after a huge delete

I'm using AWS RDS MySQL. All the tables are in InnoDB and enable innoDB_file_per_table. One of my logging tables is growing too fast. I'd like to remove older than 1-week data. Even 1 week of data ...
3
votes
1answer
370 views

Create event trigger as non-superuser in Postgres

Is it possible to give a role or a set of attributes to a non-superuser in postgres that would allow the user to create an EVENT TRIGGER? Simple example of what (obviously) doesn't work in psql: =&...
2
votes
1answer
886 views

how can be changed hot_standby parameter on postgres 9.6 aws/rds?

I have a postgres solution on aws/rds with a master and a read replica. master slave hot_standby on on transaction_read_only on on ...
2
votes
2answers
123 views

How should I model a database structure to retain calculation results?

I am trying to improve the performance of the queries related to one table that I consider "weird", which could be created by the next script: CREATE TABLE `CalcTable` ( `id` int(11) NOT NULL ...
1
vote
0answers
384 views

Replication from slave broken after table rename/swap

We run a RDS MySQL master-slave replication setup and quite regularly add another replica (replicating from the slave) for maintenance, testing, analytics, etc. However, I currently cannot create a ...
0
votes
1answer
411 views

Amazon Postgres RDS: Update pg_attribute to update my custom attribute

I want to update my attribute to change its length. I am getting Error: Permission denied for relation pg_attribute. My SQL Query is like this: DO $$ BEGIN UPDATE pg_attribute SET ...
0
votes
1answer
138 views

Postgres: query on huge (11gb ) index does not return

Using Postgres 9.6, I have created a table with 435M rows which is 120GB in size and have added an index which is 11GB in size. I now want to iterate on the distinct values of the index, but the ...
0
votes
1answer
369 views

RDS Oracle SE - Performance troubleshooting options

I have an RDS Oracle SE2 instance with Amazon RDS. Our team is looking forward to move couple of applications to RDS. But we’re looking for options that are available in RDS Oracle SE to perform ...
0
votes
1answer
96 views

Created RDS db-instance Replica successfully, now how to connect it with server

I had created AWS RDS, MySQL db-instance successfully with the help of Github Pages Documentation. Thanks a lot 18F/OpenFEC Project. Now, Instead of Route 53 configuration for network connectivity, I ...
2
votes
2answers
1k views

Installing a language with Amazon RDS?

I am using an instance of Postgres on RDS and I am trying to run: => create language plperlu; but I get: ERROR: must be superuser to create procedural language "plperlu" If I run: => grant ...
2
votes
2answers
377 views

Better way to concatenate a sequence of string replacements in Amazon RDS?

I have a concatenation of string replacements in this way: CREATE OR REPLACE FUNCTION norm(t text) RETURNS text AS $$ declare t1 text; declare t2 text; ... declare t10 ...
1
vote
0answers
287 views

“must be superuser or have the same role to terminate other server processes” with PostgreSQL

Postgres 9.4.12 locally and 9.4.7 on AWS RDS. There are two database users: app and untrusted_dev (the latter to mirror AWS RDS: NOSUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION). app is ...
1
vote
1answer
855 views

Amazon RDS Database privileges question

I have created a database and have my username which is part of the rds_superuser group. I granted a friend access to my database and whenever he creates a new table I am unable to view his table and ...
2
votes
0answers
335 views

Query Store on Amazon RDS

I'm trying to use Query Store on SQL Server on Amazon RDS, and not having any luck. The query store works for a few hours after each failover, but then stops working. For example, our last manual ...
1
vote
1answer
1k views

'Can't create thread to handle new connection' on RDS

I have two production instance of MySQL on AWS RDS that failed with: 2017-06-20T15:48:35.226833Z 0 [ERROR] Error log throttle: 1 'Can't create thread to handle new connection' error(s) suppressed ...
2
votes
1answer
1k views

How do I increase the storage available for a SQL Server instance on AWS RDS?

The Amazon docs state that you cannot increase the storage allocated to a SQL Server RDS instance: Note that you cannot change the storage capacity nor the type of storage for a SQL Server DB ...
1
vote
1answer
816 views

triggers or else between 2 postgres databases hosted on a different datacenter

I'm trying to create a trigger inside of a Postgres RDS database hosted in Frankfurt that we will call "Frankfurt". That trigger will poll tables in a distant Postgres RDS database hosted in Seoul, ...
1
vote
1answer
1k views

'Out of memory' Error for MariaDB on RDS

We have a t2.medium instance on AWS' RDS platform (4gb, 2xCpu). We're using MariaDB 10.1.19 with a single database, ~120 tables and ~2gb of data in total. After running for about a week we get this ...
1
vote
1answer
232 views

RDS import from SQL backup

I'm migrating a SQL 2008 database from a corporate data center to an RDS intance on AWS. So far I have performed a native backup which gave me a .bak file Is it possible to simply upload this to S3 ...
1
vote
1answer
3k views

unable to create schema on amazon rds for postgres

I'm trying to create a schema on a postgres instance located on Amazon rds. That schema would be used to import data from an existing schema built on a local db. Issue is I do not have permissions ...
3
votes
1answer
260 views

What should I do to get my RDS instance running PostgreSQL 9.6 to perform at least as well as my instance running PostgreSQL 9.3?

I am attempting to switch our Amazon RDS instance from PostgreqSQL 9.3 with PostGIS 2.1 to PostgreSQL 9.6 with PostGIS 2.3. I launched a new instance from a Snapshot and updated the new instance from ...
2
votes
1answer
149 views

Does AWS ever `vacuumlo` PostgreSQL RDS instances?

Link to the long story happened before (and reason to have) this question. Does AWS ever vacuumlo PostgreSQL RDS instances?
3
votes
1answer
1k views

On Amazon RDS, what consumes storage space beyond the database files?

I recently right-sized the data and log files for an RDS database, leaving just a few GB of unallocated space. Shortly thereafter, something allocated, then deallocated, 1 GB of the margin of error. ...
2
votes
2answers
1k views

MySQL 5.6 to 5.7 In-Place Upgrade or Fresh Install?

I'm preparing to migrate a production database server on AWS RDS to 5.7 from version 5.6. I'm not sure that I trust the automatic upgrade service. Obviously, I would make a backup prior to doing ...
3
votes
2answers
2k views

How to `vacuumlo` an RDS PostgreSQL database?

As you may have noticed, as a fully managed data base as a service product, AWS Relational Data base Service (RDS) restricts the execution of userland commands. I was staging a production database, ...
3
votes
1answer
2k views

AWS RDS Postgres pg_hba.conf auth-method

I'm starting to use Amazon Web Service's Relational Database Server product (AWS RDS) and want to confirm I have not made a security blunder. My configuration: Postgres Publicly accessible Inbound ...
0
votes
1answer
544 views

Porting a MySQL back-end to AWS DynamoDB

I'm setting up a back-end for a mobile application using Amazon Web Services. I'm fine with S3 and Lambda, but about using DynamoDB I have some problems. Before using AWS, I was developing the core of ...