From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: varunb@makenotion.com
Subject: CREATE SUBSCRIPTION issue
Date: Wed, 08 Nov 2023 12:26:12 +0000
Message-ID: <169944637222.1769273.16704995876166490076@wrigleys.postgresql.org> (raw)
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.
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: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, varunb@makenotion.com
Subject: Re: CREATE SUBSCRIPTION issue
In-Reply-To: <169944637222.1769273.16704995876166490076@wrigleys.postgresql.org>
* 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