Create the slot on the remote and the subscription on the global
Create the slot on the remote and the subscription on the global

CREATE SUBSCRIPTION normally works great on the global and properly creates the
pg_replication_slot on the remotes.  Except...

Creating the slot and subscription enabled in the same command will hang when replicating
between databases in the same cluster. Instead, we'll do the following:

1) On the remote, create a logical replication slot with pgoutput plugin name.
2) On the global, create the subscription without a slot but reference the
previously created slot name.
From: https://www.postgresql.org/docs/10/sql-createsubscription.html

jrafanie/manageiq,kbrock/manageiq,agrare/manageiq,agrare/manageiq,agrare/manageiq,NickLaMuro/manageiq,chessbyte/manageiq,jrafanie/manageiq,kbrock/manageiq,chessbyte/manageiq,jrafanie/manageiq,kbrock/manageiq,NickLaMuro/manageiq,chessbyte/manageiq,ManageIQ/manageiq,ManageIQ/manageiq,mzazrivec/manageiq,ManageIQ/manageiq,mzazrivec/manageiq,NickLaMuro/manageiq,mzazrivec/manageiq,ManageIQ/manageiq,kbrock/manageiq,agrare/manageiq,chessbyte/manageiq,jrafanie/manageiq,NickLaMuro/manageiq,mzazrivec/manageiq