I wonder if you can help. I need to replicate a Postgres 8.4 database (master-slave style) from an on-premise server to an RDS instance on AWS running Postgres 9.x. I've read that Postgres > 9.0 has a nice replication mechanism, but before that tools like Slony ruled. The problem I'm seeing with Slony is that it seems to need a process to be running on the target database which is a problem for me because RDS is fully managed.
Can anybody suggest a path to make this happen? I'd like to avoid downtime of the source 8.4 database whilst taking a dump and then importing it on the other side.
Thanks in advance for you help!