| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | varunb(at)makenotion(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: CREATE SUBSCRIPTION issue |
| Date: | 2023-11-08 14:05:34 |
| Message-ID: | 5e2cb89f52e848c413bbd9a44110677e13f44706.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Wed, 2023-11-08 at 12:26 +0000, PG Doc comments form wrote:
> 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.
That is not supported yet. You cannot do that.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2023-11-08 17:42:02 | Re: Version 14/15 documentation Section "Alter Default Privileges" |
| Previous Message | Laurenz Albe | 2023-11-08 14:04:31 | Re: Another user complaint regarding visibility of pg_catalog data |