Re: [HACKERS] Online DW
От | Craig Ringer |
---|---|
Тема | Re: [HACKERS] Online DW |
Дата | |
Msg-id | CAMsr+YGUH69c5EBkERaegn+v2Kagy=y-b1S3j6LufN-wqfnfHg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [HACKERS] Online DW (John R Pierce <pierce@hogranch.com>) |
Ответы |
Re: [HACKERS] Online DW
|
Список | pgsql-general |
On 10 June 2016 at 18:56, John R Pierce <pierce@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.
В списке pgsql-general по дате отправления: