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.

1

1 Answer 1

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.

2
  • Bummer. Thanks for the links to the relevant threads. I'll be sure to reach out. :)
    – dwlz
    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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.