On 10 June 2016 at 16:11, Sridhar N Bamandlapally <sridhar....@gmail.com> wrote:
> 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