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.
