CREATE SUBSCRIPTION issue
От | PG Doc comments form |
---|---|
Тема | CREATE SUBSCRIPTION issue |
Дата | |
Msg-id | 169944637222.1769273.16704995876166490076@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: CREATE SUBSCRIPTION issue
Re: CREATE SUBSCRIPTION issue |
Список | pgsql-docs |
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/logical-replication-row-filter.html Description: Hey I'm using create subscription to subscribe to a table. I have two different hosts and I want to setup replication between them. In host 1 I have one schema public and a table domain. In host 2 I have multiple schemas schema1, schema2, schema3. I want to copy the data from the host1 to host2 into schema1 and 2 and 3. While setting up the subscription it's giving me error saying 'relation "public.domain" does not exist'. because in host2 the table is created in schema1. So table would look like "schema1.domain". Any idea on how we can setup such subscription such that schema name shouldn't be an issue.
В списке pgsql-docs по дате отправления: