> > > The replication slot connection could use any role that has been > configured to allow replication. So there is no way to know which > role is actually using a slot without it actually being connected. > You can look and see which roles have replication privileges by > checking the output of \du in psql, but there is nothing tying any > roles to any specific slots. i assume that a replication slot can only be used by 1 subscriber, and subscribers can migrate; just to be clear the conneinfo is only kept on the subscriber and used on the publisher, but not stored on the publisher (unless active) so if a replication slot is inactive, you can't contact for example the user that (implicitely) created the replication slot, to see if it is still needed for example. background: i'm trying out an atypical? setup with many students subscribing to a single publication server, thus with subscribers that are not always online. As the number of slots might quickly grow:) > -- mvg, Wim Bertels -- Swerve me? The path to my fixed purpose is laid with iron rails, whereon my soul is grooved to run. Over unsounded gorges, through the rifled hearts of mountains, under torrents' beds, unerringly I rush! -- Captain Ahab, "Moby Dick"
