On 10 June 2016 at 18:56, John R Pierce <pie...@hogranch.com> wrote: > On 6/10/2016 2:18 AM, Sridhar N Bamandlapally wrote: > >> 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 >> > > there's a whole lot of implied magic here unless you want to get way more > specific what these features do, exactly, under all possible conditions.
I'd go further than that and say I can't see how something like this could possibly work with physical (block based) replication. It's total hand-waving. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services