One thing looks possible ( feature not available), just an idea
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
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>
>> 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