From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | varunb(at)makenotion(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: CREATE SUBSCRIPTION issue |
Date: | 2023-11-08 13:34:38 |
Message-ID: | CAKFQuwaB5Nrj3sOxpBKv2RYXpCPN5Jt=4bnz4nUV1M8RUr-P_Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Wed, Nov 8, 2023 at 5:42 AM PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:
> 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.
>
The schema an object is located in is a fundamental component of its
name/identity. The system has no provisions for mapping names on the
publisher to different names on the subscriber.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-11-08 14:04:31 | Re: Another user complaint regarding visibility of pg_catalog data |
Previous Message | David G. Johnston | 2023-11-08 12:31:39 | Re: Another user complaint regarding visibility of pg_catalog data |