Postgres Pro
Downloads
Home   >   mailing lists

Re: Online DW - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Online DW
Date
Msg-id CAMsr+YEKOc01aB7YQPvAL7d+ZeYP4XFh6PL8axSu7dzqEJ=CBw@mail.gmail.com
Whole thread Raw
In response to Re: Online DW  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-hackers
Tree view
On 11 June 2016 at 12:29, Sridhar N Bamandlapally <sridhar.bn1@gmail.com> 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,

Archive db need read-only, used for maintaining integrity with other business applications


In a separate mail to -general I've asked Sridhar to keep this discussion to -general, not -hackers, from now on.


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Rename max_parallel_degree?
Next
From: Noah Misch
Date:
Subject: Re: parallel workers and client encoding