Questions tagged [slony]
3 questions
2
votes
1 answer
How can I start replication of on premise Postgres 8.4 into AWS RDS Postgres 9.x?
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…
migueldavid
- 31
- 4
1
vote
1 answer
Clean DB from Slony objects
I have old DB server Postgres 8.4 and Slony (slave, to which only a table replicates)
I'm trying to migrate to new server with Postgres 9.x without slony and slony deamon, I would later setup other replication.
My plan is:
1. OLD DB: pg_dumpall -U…
LubieCiastka
- 23
- 5
0
votes
1 answer
Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?
I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do some computationally intensive calculations on the…
Amandasaurus
- 30,211
- 62
- 184
- 246