Re: Recommendation for upgrading from PostgreSQL 9.3

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Recommendation for upgrading from PostgreSQL 9.3
Дата
Msg-id CAFj8pRCr=xuz+qF0Lh06_p3d2H7526msUeWM7Mv2RU24GFx_Ug@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Recommendation for upgrading from PostgreSQL 9.3  (Karl Martin Skoldebrand <KS0C77263@TechMahindra.com>)
Ответы RE: Recommendation for upgrading from PostgreSQL 9.3  (Karl Martin Skoldebrand <KS0C77263@TechMahindra.com>)
Список pgsql-general
Дерево обсуждения


po 12. 11. 2018 v 11:45 odesílatel Karl Martin Skoldebrand <KS0C77263@techmahindra.com> napsal:

I found a note on logical replication in PostgreSQL 10.x with the caveat “There are also a number of caveats regarding what objects are actually replicated—for example, only tables are replicated, such objects as views and sequences are not.”

 

Does replication in 10.x now include views etc? We have quite a number of those that would it be if they are included.


PostgreSQL doesn't add new features in minor versions - so all limits for 10 are valid for 10.x

The replication doesn't copy views - but the views (not materialized views) are stored queries. So if you replicate data, then views are refreshed automatically. The significant limit of logical replication of PostgreSQL 10, 11 is impossibility to replicated DDL commands - the change of schema should be distributed by different method.

Regards

Pavel

 

/M

============================================================================================================================

Disclaimer:  This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.

============================================================================================================================

В списке pgsql-general по дате отправления:

Предыдущее
От: Karl Martin Skoldebrand
Дата:
Сообщение: RE: Recommendation for upgrading from PostgreSQL 9.3
Следующее
От: Karl Martin Skoldebrand
Дата:
Сообщение: RE: Recommendation for upgrading from PostgreSQL 9.3