We're moving to Postgres 9.2 on RHEL 7 and as part of this we are going to setup a slave database as our data warehouse. We would like to use the streaming replication that's built into 9.2, so we would want to remove all of the data from an old partition on the master but have it stay on the slave. I was reading the documentation [1] and it sound like this is not possible.
Is there a way to make this sort of setup work with the streaming replication that's built into Postgres 9.2?
Thanks,Is there a way to make this sort of setup work with the streaming replication that's built into Postgres 9.2?
