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.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
