On 11 June 2016 at 12:29, Sridhar N Bamandlapally
wrote:
> I need every transaction coming from application sync with both production
> and archive db,
>
> but the transactions I do to clean old data(before 7 days) on production
> db in daily maintenance window should not sync with archive db,
>
Ok, let me put this way,
I need every transaction coming from application sync with both production
and archive db,
but the transactions I do to clean old data(before 7 days) on production db
in daily maintenance window should not sync with archive db,
Archive db need read-only, used for maintain
On Fri, Jun 10, 2016 at 4:11 AM, 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
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
On 10 June 2016 at 16:11, Sridhar N Bamandlapally
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
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
Thanks
Sridhar