I have two computers. Computer A is dedicated to collecting data and storing it in its local database. Computer B is for analysis. A is running flat out just with the data collection, so I want to replicate the collected data onto B. The catch is, analysis will generate its own derived data which should also be stored in the database (but only on B). My understanding is that the off-the-shelf replication mechanisms require the recipient database to be read-only.
Is it possible to do something like streaming replication, but which allows the recipient database to be read-write? Ideally, the schema containing the tables replicated from A would be read-only to analysis users, but separate schemas owned by those users would be read-write for them.
It is okay for the replica to be hours out of date.
I want to keep data collection on A writing to a local database, so that it can continue whether or not B is available.
(Currently I'm on 9.3 but about to upgrade to 9.4 betas for unrelated reasons.)