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.

Improve this question
1

1 Answer 1

Reset to default
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.

Improve this answer
2
  • Bummer. Thanks for the links to the relevant threads. I'll be sure to reach out. :)
    – Dan Loewenherz
    Jun 17, 2014 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 3, 2015 at 22:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .