From: Laurenz Albe <laurenz.albe@cybertec.at>
To: varunb@makenotion.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: CREATE SUBSCRIPTION issue
Date: Wed, 08 Nov 2023 15:05:34 +0100
Message-ID: <5e2cb89f52e848c413bbd9a44110677e13f44706.camel@cybertec.at> (raw)
In-Reply-To: <169944637222.1769273.16704995876166490076@wrigleys.postgresql.org>
References: <169944637222.1769273.16704995876166490076@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, varunb@makenotion.com, pgsql-docs@lists.postgresql.org
Subject: Re: CREATE SUBSCRIPTION issue
In-Reply-To: <5e2cb89f52e848c413bbd9a44110677e13f44706.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox