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 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
