0
votes
0answers
27 views

What's causing Postgres to freeze?

I'm using Amazon RDS to run my Postgres database, v9.3.3. Recently, I had 2 instances where updating the schema caused the database to stop responding and I had to restart it in order to put the site ...
1
vote
0answers
38 views

Does amazon rds PostgreSQL require vacuum?

It isn't clear if auto vacuum is running in rds. Thanks!
0
votes
0answers
32 views

Will Amazon RDS for Postgres be as convenient as using Heroku Postgres?

I'm currently running a Heroku Rails app and our Postgres DB has grown to a data size of 50GB, and our DB cache hit rate is at 93%. We're on the legacy Ronin ($200/month) plan (1.7GB) and probably ...
0
votes
0answers
31 views

Amazon RDS, RedShift and Data Warehousing [closed]

Is Amazon RDS for Postgresql a viable choice for a data warehouse? I currently have a data warehouse environment running under Postgres 9.2 and am looking at cloud offerings. I considered Redshift, ...
2
votes
0answers
54 views

Postgres: missing disk space after truncate and re-insert

We've got a IP address range dataset stored in a table that was truncated and then re-populated with a slightly modified version of the dataset (almost identical in size). However, after truncating ...
0
votes
1answer
165 views

While importing 150 GB file on Amazon RDS, why connection is failing?

I am having Postgres database dump file of 150 GB on Amazon EC2 instance. While dumping the data on RDS from EC2 server I am getting error. The output of the command is as given below. It's giving ...
4
votes
2answers
269 views

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 ...
1
vote
0answers
249 views

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 ...
0
votes
0answers
147 views

How do a I edit .conf file for a postgres AWS RDS?

I would like to alter pg_hba.conf in my postgres RDS instance so that I can require ssl. I have found the Parameters Group manager in the RDS which allows me to alter parameters but it just references ...
5
votes
1answer
138 views

How to schedule PostgreSQL replication?

I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen. I'll be using postgres internal replication solution but as far as I ...