6

I'm trying to set up an PostgreSQL database on Amazon RDS as a replica to another PostgreSQL database that lives on a regular server. Most of the instructions I've found online require shell access so that you can copy over a bunch of data files that can't be manipulated through the psql shell.

Amazon RDS for PostgreSQL does not provide shell access, so these methods won't work. Is there another way to enable streaming replication?

Thanks in advance!

PS I've seen this question but it is not a duplicate, as it is asking about MySQL, specifically, and not PostgreSQL.

Community
  • 1
dwlz
  • 891
  • 3
  • 10
  • 19
  • AWS blog from late 2014 describes how this can be done: https://aws.amazon.com/blogs/aws/rds-postgres-read-replicas/ – bill Sep 14 '15 at 19:15

1 Answers1

4

At time of writing no, you can't.

See:

Please nag them, both on the forums:

and via any AWS sales/support contacts you may have.

Community
  • 1
Craig Ringer
  • 10,553
  • 9
  • 38
  • 59
  • Bummer. Thanks for the links to the relevant threads. I'll be sure to reach out. :) – dwlz Jun 17 '14 at 13:33
  • From that forum thread, 2014-09-10, "Amazon RDS for PostgreSQL announced support for Read Replicas, PostgreSQL 9.3.5, Data Migration enhancements." – jwadsack Sep 03 '15 at 22:04