Re: how to upgrade production PostgreSQL from 9.4 to 11.3

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