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 1tXMWQ-005qL7-FP for pgsql-general@arkaria.postgresql.org; Mon, 13 Jan 2025 15:38:34 +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 1tXMWP-00AuYr-4M for pgsql-general@arkaria.postgresql.org; Mon, 13 Jan 2025 15:38:33 +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 1tXMWO-00AuYj-Ph for pgsql-general@lists.postgresql.org; Mon, 13 Jan 2025 15:38:33 +0000 Received: from mail-pl1-x629.google.com ([2607:f8b0:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tXMWN-000C7u-0k for pgsql-general@postgresql.org; Mon, 13 Jan 2025 15:38:32 +0000 Received: by mail-pl1-x629.google.com with SMTP id d9443c01a7336-21675fd60feso101258875ad.2 for ; Mon, 13 Jan 2025 07:38:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736782709; x=1737387509; darn=postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=FyAEjzIjmqa6S7t8bn3LprmFK9WRQMzStDCZXQSF9bw=; b=OhGPj4T8YLjBcfMxqQd1plKey3xgwyNtcKQtl6qcgbJqZgYCMUrxMzgFXaPuRFcoqR xfmgeCAQv+hEJ0RBDaaU36aiaOpbc3rooUh0Z9hS5ClAvY+h+mOUlIlOcOQBJrPubhkX J2G+tNQsGp2nyDzz3Eh9xkl7WyY7YshzcfM4RzU9KcOx9QKtgjVdXpR9rppma7I/myZE UtfzWWh6V+xhRrVAy93411kkoua+6mpeyAkP94kv1UMXHUvuECGWtCYlJE15vAH3B623 GPHoPsapS9JOQzKuufDRRSMCxg7MAVhWF6oXNpQEDUA27EpGE0F9WlKEOyURgCUljQjo BsUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736782709; x=1737387509; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=FyAEjzIjmqa6S7t8bn3LprmFK9WRQMzStDCZXQSF9bw=; b=BfVigFfPjDojOxzyiYd6+6eKiBwZIwbWm1s10Vhq3lRgdS35OvouCZQT05WEP5JRXu eEWDw91boey9XkYD8MyHpIlsimmfxO22cWdPRqPQAS122hWjIR2DWIaiFrNZZyROr4lJ Qltcu4okTKujtcMhSRRnuG24qP/XcTbBqNIt2V+S4i3tzbOLqS9HGpN5v5UN8KhGikXC ATfnGWWspAcivT0Kr8qRCSw07wDoGEHLGFRNbbz0F3lvAp991FoFkxoVFNpLIINhvghj wo/DiJeH9loGq3aeMyt7ysazm7Er8RLP8p6q/+TirtAo+6f6qKIHOCCjed6wnszQG0ZW cvTw== X-Gm-Message-State: AOJu0Yymz8LD6qjwQdIgPpCximWu6JONPfh6VjYIODZKAjJGmzleTTVt vlfLNfBufE74r8itXWwHkFMLpnjmYIx6JQANDY0FEMans6ggHoD6qdI+2w== X-Gm-Gg: ASbGncvK3fVi5+SKV2L3k4OJItUABQmHbLE6kICWSXtoYE4DEV0+qY+FxgA1KJ+ZJ/v 0eEhVRkUx/jZJ6VaD7appkaobNjFg2WGkRZStkjGxK5aqNzYlKcrU03nmF8Yp0QkS0hZyIGZtHV tQY2G/PYpntFCnpY1PJkKB3kvNFjBMAp2CjZNUgFjh56jfoPoE1AzSfT7IPC4IMyd4ffT1IhixH pzGlqIuVWtVIuzRdPnla4mAFzPUfQTRdb74rKIGfEAIJ/LHUGyB5inFGWJohgLYPBYyGkrkXSGt qYKKo9K+7A== X-Google-Smtp-Source: AGHT+IGxanlQjXxHyYLuVDK5U/umabE687N0XaxK+onpQazIJSjdwAMdljYxAwSo8DQ77U/ubMBP+w== X-Received: by 2002:a17:903:2342:b0:216:69ca:770b with SMTP id d9443c01a7336-21a83f48c24mr358283075ad.12.1736782709106; Mon, 13 Jan 2025 07:38:29 -0800 (PST) Received: from smtpclient.apple ([2601:681:4c01:7310:790d:dc1d:d05b:d17b]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-21a9f10e2c6sm54409455ad.33.2025.01.13.07.38.28 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 13 Jan 2025 07:38:28 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-592554FB-D9B3-448F-A082-2F10CB17BA5E Content-Transfer-Encoding: 7bit From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Need help in logical replication Date: Mon, 13 Jan 2025 08:38:17 -0700 Message-Id: <73765C83-D886-4FE6-8213-08CEAF0057A8@gmail.com> References: Cc: pgsql-general In-Reply-To: To: Divyansh Gupta JNsThMAudy X-Mailer: iPhone Mail (22B91) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-592554FB-D9B3-448F-A082-2F10CB17BA5E Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > On Jan 13, 2025, at 5:30=E2=80=AFAM, Divyansh Gupta JNsThMAudy wrote: >=20 > =EF=BB=BF > Hii PostgreSQL Community, >=20 > I am setting up logical replication between two clusters in the same subne= t group. I=E2=80=99ve created a publication on the primary and a subscriptio= n on the secondary, and the replication slot has been created. However, the s= lot remains inactive, and changes aren=E2=80=99t being applied on the subscr= iber. >=20 > I am using AWS RDS for that >=20 > Could you please help me identify the possible cause and resolution for th= is issue? >=20 > Thank you in advance! >=20 >=20 Maybe you could send your ddl in plain text? >=20 --Apple-Mail-592554FB-D9B3-448F-A082-2F10CB17BA5E Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable


On Jan 13, 2025, at 5:30=E2=80=AFAM, Divyansh Gupta JNsThMAudy <ag15= 67827@gmail.com> wrote:

=EF=BB=BF

Hii PostgreSQL Community,

I am setting up logical replication between two clusters in the same su= bnet group. I=E2=80=99ve created a publication on the primary and a subscrip= tion on the secondary, and the replication slot has been created. However, t= he slot remains inactive, and changes aren=E2=80=99t being applied on the su= bscriber.

I am using AWS RDS for that

Could you please help me i= dentify the possible cause and resolution for this issue?

Thank you in= advance!


Maybe you could= send your ddl in plain text?


= --Apple-Mail-592554FB-D9B3-448F-A082-2F10CB17BA5E--