Horton

Add worker type to pg_stat_subscription.

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: 13aeaf0797e75a0c53abb66ac907ba14b4e47f6b
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2023-09-25T21:12:43Z
Releases: 17.0 
Add worker type to pg_stat_subscription.

Thanks to commit 2a8b40e368, the logical replication worker type is
easily determined.  The worker type could already be deduced via
other columns such as leader_pid and relid, but that is unnecessary
complexity for users.

Bumps catversion.

Author: Peter Smith
Reviewed-by: Michael Paquier, Maxim Orlov, Amit Kapila
Discussion: https://postgr.es/m/CAHut%2BPtmbSMfErSk0S7xxVdZJ9XVE3xVLhqBTmT91kf57BeKDQ%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +12 −1
src/backend/catalog/system_views.sql modified +1 −0
src/backend/replication/logical/launcher.c modified +17 −1
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +3 −3
src/test/regress/expected/rules.out modified +2 −1
src/test/subscription/t/004_sync.pl modified +1 −1

Documentation touched

Discussion