pgsql: Add required database and origin filtering for logical messages. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Add required database and origin filtering for logical messages.
Date
Msg-id E1aqVLM-0006ci-Q6@gemulon.postgresql.org
Whole thread Raw
List 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.wotqy3ba3kanr423@alap3.anarazel.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(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Fix pg_dump so pg_upgrade'ing an extension with simple opfamilie
Next
From: Stephen Frost
Date:
Subject: pgsql: Disallow SET SESSION AUTHORIZATION pg_*