Home / server / Questions / 605460
In Process
dwlz
Asked: 2014-06-17 05:17:21 +0800 CST

How can I set up an Amazon RDS for PostgreSQL database to act as a replica to a non-RDS PostgreSQL database?

  • 772

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.

postgresql

1 Answers

  1. 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.

    • 4