Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [aws]

Amazon Web Services.

494 questions
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
18
votes
2 answers

How to set the wal_level in AWS RDS Postgresql?

How do I know which wal_level my AWS RDS Postgres 11.1 database has? I checked 'parameter groups', but was unable to find the wal_level. Once found, how do I change it?
Hauke
  • 283
  • 1
  • 2
  • 6
17
votes
1 answer

PostgreSQL: SSL SYSCALL error: EOF detected

First, I've searched for and found several posts relating to this error, and most of them point either to a RAM issue or an SSL issue, I tried overcoming the SSL possibility by adding the sslmode=disabled in the command line: psql -U waypoint -d…
Gonzalo Vasquez
  • 1,059
  • 2
  • 18
  • 33
15
votes
2 answers

Why use RDS over EC2 for Postgres?

I have a database currently running on EC2. As I have to move it to a bigger machine the question of using RDS came up. Pricing: I can get an EC2 c3.large instance with two SSDs (16GB each), two vCPUs and 4GB of memory on demand for $0.132 per hour…
kev
  • 397
  • 1
  • 4
  • 12
15
votes
1 answer

Best way to pg_dump PostgreSQL on RDS to S3

I need to dump my PostgreSQL on RDS to a file on S3 periodically (to use it elsewhere than AWS). Is there a better way than running a script that runs pg_dump and uploads results to S3 using e.g. boto3?
pmichna
  • 323
  • 2
  • 4
  • 9
12
votes
2 answers

Does AWS RDS support MEMORY storage engine?

Title says it all. Strangely can't find a result on this.
Marc L.
  • 223
  • 2
  • 7
9
votes
1 answer

Replication Lag on Postgres AWS RDS Service

We have a single master/single streaming replica Postgres 9.3 db on AWS. The load is not terribly high - this is a development/staging environment. (The production shows similar metrics). Point is the "ReplicaLag" shown in Cloudwatch oscillates…
MJB
  • 191
  • 1
  • 1
  • 4
9
votes
3 answers

How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?

I have an Amazon RDS Postgres DB and I created a "replicator" user and granted it the "replication" privilege. db=> create role replicator login password 'something'; CREATE ROLE db=> alter role replicator replication; ALTER ROLE db=> However,…
Evan
  • 199
  • 1
  • 4
9
votes
1 answer

Why does RDS PostgreSQL always recover on restart?

I am running an RDS instance of PostgreSQL 9.6.3: select version(); returns PostgreSQL 9.6.3 on x86_64-pc-linux-gnu [...]. I have found that after issuing a stop from the RDS console followed by a start the database always reports that the database…
Christopher Lewis
  • 101
  • 1
  • 5
9
votes
2 answers

Best practice for securely backing up RDS Postgres "offsite"?

We're running Postgres on RDS, which is largely great. The big issue with it, however, is to do with AWS' security model, which allows anyone with various permissions to delete everything - your DBs, your backups, the whole lot. In particular, you…
Pete Storey
  • 281
  • 1
  • 2
  • 4
8
votes
2 answers

MySQL on RDS, data transfer from one instance to another as a production job

I have a MySQL RDS instance ("production") from which I need to copy incremental data to another MySQL RDS instance ("reporting"). “Incremental data” being the new rows in certain tables. Currently I accomplish this via a PHP script which queries…
Alex Lo
  • 181
  • 1
  • 4
8
votes
1 answer

What AWS instance to choose for write-heavy PostgreSQL database server

We are now having problems trouble to tackle the intensive traffic to our servers during peak hours; see this related question on tuning the DB. At the moment we are using a smaller cloud service for the server hosting. Currently we are looking at…
lorgartzor
  • 365
  • 1
  • 3
  • 9
8
votes
1 answer

Postgres long autovacuum halting database

I have a fairly large table (1 million rows) and my database is stuck on an autovacuum (>30 mins) on the this table, causing the whole database to chock. Application won't even load now. -00:37:31.137859 autovacuum: VACUUM public.users SELECT…
Andrew Cetinic
  • 181
  • 1
  • 4
8
votes
2 answers

AWS RDS - Changing Instance Class

So I'm fairly new to AWS and I'm hoping you guys can reassure me as I couldn't find anything in the AWS documentation either way. I actually have two questions, the first: I have an RDS MySql instance in AWS that wasn't set up by myself (a previous…
Pheonyx
  • 183
  • 1
  • 4
7
votes
1 answer

Amazon RDS mysqbinlog "Could not find first log file name in binary log index file"

Preamble: We use RDS at AWS to manage our MySQL database. I know that RDS creates binary logs used for replication.. I want to harvest these binary logs and store them on S3, so that at any time, i can restore to an off-site database and replay the…
code ninja
  • 173
  • 1
  • 1
  • 6
1
2 3
…
32 33