diff options
| author | Andres Freund | 2015-04-21 09:51:06 +0000 |
|---|---|---|
| committer | Andres Freund | 2015-04-21 09:51:06 +0000 |
| commit | d811c037cea2e929ee5823aab6e1bca0df8be245 (patch) | |
| tree | 46cd4fdf2fc78c9f20d8c65c15814e019b08af9b /src/test | |
| parent | 528c2e44ab0a5ba49a5a04689dae3f674b71c15e (diff) | |
Add 'active_in' column to pg_replication_slots.
Right now it is visible whether a replication slot is active in any
session, but not in which. Adding the active_in column, containing the
pid of the backend having acquired the slot, makes it much easier to
associate pg_replication_slots entries with the corresponding
pg_stat_replication/pg_stat_activity row.
This should have been done from the start, but I (Andres) dropped the
ball there somehow.
Author: Craig Ringer, revised by me Discussion:
CAMsr+YFKgZca5_7_ouaMWxA5PneJC9LNViPzpDHusaPhU9pA7g@mail.gmail.com
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/rules.out | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 71fa44a6bea..1577ff0e297 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -1396,10 +1396,11 @@ pg_replication_slots| SELECT l.slot_name, l.datoid, d.datname AS database, l.active, + l.active_in, l.xmin, l.catalog_xmin, l.restart_lsn - FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, active, xmin, catalog_xmin, restart_lsn) + FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, active, active_in, xmin, catalog_xmin, restart_lsn) LEFT JOIN pg_database d ON ((l.datoid = d.oid))); pg_roles| SELECT pg_authid.rolname, pg_authid.rolsuper, |