On 10 June 2016 at 16:11, Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx> wrote:
HiIs there any feature in PostgreSQL where online DW (Dataware housing) is possible ?am looking for scenario like1. Production DB will have CURRENT + LAST 7 DAYS data only2. Archive/DW DB will have CURRENT + COMPLETE HISTORYexpecting something like streaming, but not ETL
There's nothing built-in, but that's exactly the sort of thing pglogical is intended for. You can also build something along those lines with Londiste fairly easily.
Hopefully this is the sort of thing we can move toward with built-in logical replication in coming releases.
