John,Yes, Rackspace supports slony. I used to work there and they use slony on their core system.Patrick,You cannot stream directly from 9.2 to 9.4. However, you can just create a separate 9.4 cluster (on a separate port).Then pg_dump from 9.2 in plain format and it will load on 9.4
damn!!! really? =( That's not good
will have to think about how will perform this....
I think what I would need to use is:
1 - upgrade master server
2 - by performing #1 - the slaves would become unused (streaming replication wouldn't work)
3 - Setup new slave running Postgres 9.4
4 - dump the db to the new server
Do you guys agree?