pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedCREATE SUBSCRIPTION issue
3+ messages / 3 participants
[nested] [flat]
* CREATE SUBSCRIPTION issue
@ 2023-11-08 12:26 PG Doc comments form <noreply@postgresql.org>
2023-11-08 13:34 ` Re: CREATE SUBSCRIPTION issue David G. Johnston <david.g.johnston@gmail.com>
2023-11-08 14:05 ` Re: CREATE SUBSCRIPTION issue Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 3+ messages in thread
From: PG Doc comments form @ 2023-11-08 12:26 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: varunb@makenotion.com
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: CREATE SUBSCRIPTION issue
2023-11-08 12:26 CREATE SUBSCRIPTION issue PG Doc comments form <noreply@postgresql.org>
@ 2023-11-08 13:34 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: David G. Johnston @ 2023-11-08 13:34 UTC (permalink / raw)
To: varunb@makenotion.com; pgsql-docs@lists.postgresql.org
On Wed, Nov 8, 2023 at 5:42 AM PG Doc comments form <noreply@postgresql.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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: CREATE SUBSCRIPTION issue
2023-11-08 12:26 CREATE SUBSCRIPTION issue PG Doc comments form <noreply@postgresql.org>
@ 2023-11-08 14:05 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2023-11-08 14:05 UTC (permalink / raw)
To: varunb@makenotion.com; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-11-08 14:05 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-08 12:26 CREATE SUBSCRIPTION issue PG Doc comments form <noreply@postgresql.org>
2023-11-08 13:34 ` David G. Johnston <david.g.johnston@gmail.com>
2023-11-08 14:05 ` Laurenz Albe <laurenz.albe@cybertec.at>
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