Re: [HACKERS] Online DW

[Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx>]

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 <craig@xxxxxxxxxxxxxxx> wrote:

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