Am 12.06.19 um 14:50 schrieb Rahul Chordiya: > postgres=# > postgres=# select subscription_name, status FROM > pglogical.show_subscription_status(); > subscription_name | status > -------------------+-------- > (0 rows) > > postgres=# select pglogical.create_subscription(subscription_name := > 'subscription1', provider_dsn := 'host=10.101.40.70 port=5432 > dbname=registration user=repuser password=password', replication_sets > := '{my_set}'); > *ERROR: could not fetch remote node info: ERROR: schema "pglogical" > does not exist* > > What should I do? >
you have create the replication set (on the provider) in the postgres-database, but now you referencing to an other database, registration. There isn't this replication set defined.