Currently, in order to use pg_createsubscriber you must have superuser privileges on the source database.
This requires stems from the use of FOR ALL TABLES <https://www.postgresql.org/docs/18/sql-createpublication.html#SQL-CREATEPUBLICATION-PARAMS-FOR-ALL-TABLES> in the CREATE PUBLICATION command used. As far as I am aware, none of the other steps performed on the source server require superuser. I wonder whether pg_createsubscriber could be extended to use an existing publication, after confirming that it is equivalent to the one it would have created itself. In my use case for pg_createsubscriber, I would prefer not to give the downstream server superuser privileges, since it wouldn't need them for any other reason. I could probably contribute this feature myself, if it is agreeable. Thanks, Zane
