Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

980 questions
71
votes
8 answers

ERROR: no schema has been selected to create in

I am working on an amazon RDS postgresql database where I know there had been some issue with the public schema (maybe it was dropped). But apparently the schema exists, and anyway the problem is not solved. Here is a sample session with a newly…
Emanuele Paolini
  • 813
  • 1
  • 6
  • 7
39
votes
4 answers

What is the optimal way to upgrade production RDS instance?

I have MySQL small RDS instance as part of my production system and I want to upgrade it to medium instance with provided IOPS. As old-school DBA I'm aware about "add slave; promote to master; switch clients" method, but AWS promises to provide…
Vitaly Karasik DevOps
  • 623
  • 2
  • 6
  • 14
36
votes
3 answers

How to speed up select distinct?

I have a simple select distinct on some time series data: SELECT DISTINCT user_id FROM events WHERE project_id = 6 AND time > '2015-01-11 8:00:00' AND time < '2015-02-10 8:00:00'; And it takes 112 seconds. Here's the query…
Sam
  • 637
  • 2
  • 7
  • 12
34
votes
3 answers

Why do I get a PostgreSQL permission error when specifying a tablespace in the "create database" command?

When I create a database in PostgreSQL without explicitly specifying a default tablespace the database is created without issue (I'm logged in as the pgsys user): postgres=> create database rich1; CREATE DATABASE postgres=> \l+ …
HuggieRich
  • 441
  • 1
  • 4
  • 5
32
votes
4 answers

GRANT USAGE on all schemas in a database?

I want to GRANT USAGE to a user/role for a given database. The database has many schemas. I know there's an ON ALL TABLES IN SCHEMA, but I want "all schemas". I tried GRANT USAGE .. ON DATABASE, but that's obviously wrong (it doesn't actually…
300D7309EF17
  • 431
  • 1
  • 4
  • 6
32
votes
2 answers

Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance

At work, we host all our webservers on Amazon EC2 and usually have used MySQL databases installed on the same box as our Apache webserver, and communicated with them on localhost. We now face a need to migrate our database to its own server for one…
Mark Amery
  • 1,106
  • 3
  • 14
  • 24
26
votes
1 answer

Multiple databases in same AWS RDS PostgreSQL instance

I have an existing database in a RDS AWS PostgreSQL instance. I need to create one more database in this instance as spinning up a separate cluster will be expensive. There doesn't seem to be any option to create one more database inside this…
Pravs_thedataguy
  • 575
  • 1
  • 7
  • 13
22
votes
2 answers

Does amazon rds PostgreSQL require vacuum?

It isn't clear if auto vacuum is running in rds. Thanks!
Chris kinsman
  • 221
  • 1
  • 2
  • 3
22
votes
2 answers

Get postgres snapshot from Amazon RDS

I can not find a simple way to get a copy of the nightly backup I take of my Amazon RDS postgres instance so I can restore it on my local machine to play with. Right now I'm doing a pg_dump when I need a copy, but it would be nicer (and faster,…
Hsiu Dai
  • 351
  • 1
  • 2
  • 5
22
votes
1 answer

CPU usage constantly high after upgrading from Postgres 9.5 to 9.6 to 10.6

I upgraded my RDS instance (db.t2.medium) from Postgres 9.5 to 9.6 couple of days back. Since the upgrade, the CPU usage was almost 100% all the time. This brought down my application. Presuming that the problem is with the 9.6 version, I did…
Raj
  • 405
  • 1
  • 4
  • 9
22
votes
1 answer

PostgeSQL 9.3: Is it safe to stop VACUUM FULL?

I'm using PostgreSQL 9.3 on RDS. Once in a while, I run a VACUUM FULL operation on the database. However, such operation can take quite a while and it blocks other tables, so the need to stop the operation might arise. Is it safe to stop a VACUUM…
Adam Matan
  • 12,079
  • 30
  • 82
  • 96
18
votes
2 answers

Privileges for database owner; application user

Quick version: What command should I issue to enable a database owner to allow it to access tables in this database and can this be done from that owner's account? Longer Version: I am creating a database on RDS. I have a 'root' user that I have…
Andy Davis
  • 293
  • 1
  • 2
  • 9
18
votes
2 answers

Should I increase max_connections in AWS RDS t1-micro for MySQL?

I have an AWS RDS t1-micro running MySQL 5.5. It gives me too many connections error. I checked and it allows 34 maximum connections concurrently. What I have read is that i can increase this max value by creating a DB parameter group for this Micro…
user23577
  • 241
  • 1
  • 3
  • 4
17
votes
1 answer

How to temporarily disable foreign keys in Amazon RDS PostgreSQL?

I'm migrating existing test environment to Amazon RDS PostgreSQL. The test framework has a feature of reloading data in certain tables to an earlier state. For this it disables foreign keys, deletes existing data, loads save state and enables…
Piotr Findeisen
  • 581
  • 1
  • 4
  • 11
16
votes
3 answers

How can I determine how many IOPs I need for my AWS RDS database?

I am migrating part of a mysql database into AWS. The data in question is 99% write, and each row has about 1k of varchar fields, a datetime and 4 ints. I estimate that we will need between 20-25k records inserted/hour during peak times. I ran…
chris
  • 1,232
  • 5
  • 17
  • 29
1
2 3
…
65 66