On 10 June 2016 at 16:11, Sridhar N Bamandlapally <sridhar....@gmail.com>

> Hi
> Is there any feature in PostgreSQL where online DW (Dataware housing) is
> possible ?
> am looking for scenario like
> 1. Production DB will have CURRENT + LAST 7 DAYS data only
> 2. Archive/DW DB will have CURRENT + COMPLETE HISTORY
> expecting 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.

 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Reply via email to