One thing looks possible ( feature not available), just an idea example/syntax:
BEGIN NOARCHIVE; --- transaction-1 --- transaction-2 . . --- transaction-N END; This/These will be performed in Production to clean-up archive which will not be sync with Archive/DW DB only one heads-up is Archive/DW DB may need to build WITHOUT CONSTRAINTS May need to introduce ARCHIVE system/tag in pg_hba.conf Thanks Sridhar OpenText On Fri, Jun 10, 2016 at 2:22 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > 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 >