Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0jBf-007R1R-Pq for pgsql-docs@arkaria.postgresql.org; Wed, 08 Nov 2023 14:05:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r0jBe-003i9X-DI for pgsql-docs@arkaria.postgresql.org; Wed, 08 Nov 2023 14:05:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0jBe-003i9P-5X for pgsql-docs@lists.postgresql.org; Wed, 08 Nov 2023 14:05:42 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0jBY-005MPm-1J for pgsql-docs@lists.postgresql.org; Wed, 08 Nov 2023 14:05:41 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-9c603e2354fso173658766b.1 for ; Wed, 08 Nov 2023 06:05:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699452335; x=1700057135; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=A6rp2RSHAQgzMOYBMOYKaA/uT0AAcdmsGfDlcrmNBiw=; b=W1Ubg/o6GlaOIHW5tgTjUxDT2uVgG3QEVsSgaUe/VVUt+5G7eSXQwI2q0XKtBkqlkz kKuQSZtlgzY6GGnxcDEMpn+t/4moJfbjXWazMAEpb2t7y7IAwxRnBBIz4/K0FAWq/ARq H23hBvo4nJdFR2LUUM7HO4WXEls3HxitRnGNCd+HYCCX4jCAK06GkwiYK+wScIvovXO1 GhBMDLbpWoAgry5q85kBQBrSTNauLzAUiZ4DTrv5Mm6YXct6Pi43SKrC7R2c0mP4o6cf T+XoJq/nYeNRIzHh4FVIQJTwK+D89hgnhiH0vEUBZzJJpoaC2FbPbWfEzwKXQTOzLn2x 5c3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699452335; x=1700057135; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=A6rp2RSHAQgzMOYBMOYKaA/uT0AAcdmsGfDlcrmNBiw=; b=F1j/63q2ZT8xg/bG3hejPnb/RH68Ezt3MOy8Y3g9pI9ViHM8nj+h/DbKnWBzQPPo0N eoj7P1WuS7h/N8fN/NE0xYxT2yRl35FbRBfrYe7WqdctmYp8qMasAceoYujysqlA65q7 iAPN3HhFkVnoiINL86w0R3NykjhFPJuDBR4J0MmtJ0VmDiUE7Z/KTOjyv6UAvgROwAVW F/y5aDjMvAyJIm9QaTyxoX1eP+ngXneGD9e2cZoPdmdC5gnBW3cwUOkKWLqH8bIFtaNi 1vOZphb8B7Qcn+EG05XVvjvlCOwVWlxDaKljGGj2XCFz1T9qq9JFuCCMe5ZHVXSSzTi0 jymQ== X-Gm-Message-State: AOJu0YwyzPzf9v4xk1PLqdIlKQZpL5ZYKeHVevSpfvFHpuKvJdr8Hv+1 /7U8LQaL7aF6DuYSiQ0isgUJtQ== X-Google-Smtp-Source: AGHT+IGiySTDzTcmfx3xAECA8iwPW7e8L7y1Sb0FTnZ6AGrKAeHGL0Va+WIW+PMshzt5dO5+oXEeKQ== X-Received: by 2002:a17:907:9706:b0:9ad:f60c:7287 with SMTP id jg6-20020a170907970600b009adf60c7287mr1765281ejc.28.1699452335220; Wed, 08 Nov 2023 06:05:35 -0800 (PST) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id hk6-20020a170906c9c600b009ddaf5ebb6fsm1107894ejb.177.2023.11.08.06.05.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 08 Nov 2023 06:05:35 -0800 (PST) Message-ID: <5e2cb89f52e848c413bbd9a44110677e13f44706.camel@cybertec.at> Subject: Re: CREATE SUBSCRIPTION issue From: Laurenz Albe To: varunb@makenotion.com, pgsql-docs@lists.postgresql.org Date: Wed, 08 Nov 2023 15:05:34 +0100 In-Reply-To: <169944637222.1769273.16704995876166490076@wrigleys.postgresql.org> References: <169944637222.1769273.16704995876166490076@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. >=20 > 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. >=20 > 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 ca= n > setup such subscription such that schema name shouldn't be an issue. That is not supported yet. You cannot do that. Yours, Laurenz Albe