pgsql: Add required database and origin filtering for logical messages.

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add required database and origin filtering for logical messages.
Date: 2016-04-14 00:41:12
Message-ID: E1aqVLM-0006ci-Q6@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add required database and origin filtering for logical messages.

Logical messages, added in 3fe3511d05, during decoding failed to filter
messages emitted in other databases and messages emitted "under" a
replication origin the output plugin isn't interested in.

Add tests to verify that both types of filtering actually work. While
touching message.sql remove hunk obsoleted by d25379e.

Bump XLOG_PAGE_MAGIC because xl_logical_message changed and because
3fe3511d05 had omitted doing so. 3fe3511d05 additionally didn't bump
catversion, but 7a542700d has done so since.

Author: Petr Jelinek
Reported-By: Andres Freund
Discussion: 20160406142513(dot)wotqy3ba3kanr423(at)alap3(dot)anarazel(dot)de

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/be65eddd80093a923b091dc60776aa6f966d1f07

Modified Files
--------------
contrib/test_decoding/expected/messages.out | 26 +++++++++++++++++++++++---
contrib/test_decoding/expected/replorigin.out | 6 ++++++
contrib/test_decoding/sql/messages.sql | 13 +++++++++++--
contrib/test_decoding/sql/replorigin.sql | 2 ++
src/backend/replication/logical/decode.c | 23 ++++++++++++++---------
src/backend/replication/logical/message.c | 6 ++++++
src/include/access/xlog_internal.h | 2 +-
src/include/replication/message.h | 1 +
8 files changed, 64 insertions(+), 15 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Stephen Frost 2016-04-14 01:31:36 pgsql: Disallow SET SESSION AUTHORIZATION pg_*
Previous Message Tom Lane 2016-04-14 00:16:59 Re: pgsql: Fix pg_dump so pg_upgrade'ing an extension with simple opfamilie